Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OTBI Prompt
How would a prompted input be used for filtering the analysis (i.e user selects a date in a calendar dating from that date till present for generating the analysis)?
Answers
-
Hi,
Please check below resources to get more understanding on prompts and how to use them:
Filtering OTBI report off of the current system date? — Oracle
OTBI - Need filter on from date to To date as sysdate — Cloud Customer Connect
Fusion Katta: Oracle Fusion HCM OTBI - Chapter 5: Filtering and Prompts in OTBI Reports?
Thanks.
1 -
Hi @User_M2U6X,
Welcome to the Oracle Analytics & AI Community!
You have to define a Presentation Variable while defining the Prompt and then need to use that Presentation Variable in the filter or in case you want to use it in any calculations.
- Create Prompt: In the Dashboard Prompt, create a prompt for a column and set a presentation variable (e.g. pv_Dept).
- In the Analysis, change the filter to "is equal to / is in" and add the expression: @{pv_Dept}.
Please take a look into the following docs for more information on Presentation Variable and some examples
Presentation Variable:
Advanced Techniques - How Dashboard Prompts and Analysis Prompts Interact:
Display Prompt filter values in a OTBI report:
https://erpwebtutor.com/display-prompt-filter-values-in-a-otbi-report/
Hope this help.
Thank you
1 -
@User_M2U6X , Welcome to the Oracle Analytics Community.
Here are the high-level steps with the screenshot …
- Go to Fusion → Tools → Reports and Analytics → Browse Catalog → New → Dashboard Prompt.
- Select the same Subject Area used by the analysis.
- Add Column Prompt.
Configure:
- Column: e.g. Transaction Date
- Operator: is equal to / is between (not important for this case)
- Prompt type: Date
- Set a Variable: Presentation Variable
Example: Variable Name: P_FROM_DATE
This gives users a calendar picker.
Save the prompt.
Use the Presentation Variable in the Analysis Filter
Open the OTBI Analysis → Criteria → Filters.
Add filter: Transaction Date >= @{P_FROM_DATE}{01/01/2000}
Hope it helps!
0
