Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 51 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 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
