OTBI Prompt

Question

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)?

RVohra · Answer

@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!

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28260/otbi-prompt

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:

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/advanced-techniques-reference-stored-values-variables.html#GUID-0861B851-8E5D-45C3-9E92-B27821CF6F96

Advanced Techniques - How Dashboard Prompts and Analysis Prompts Interact:

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/advanced-techniques-how-dashboard-prompts-and-analysis-prompts-interact.html

Display Prompt filter values in a OTBI report:

https://erpwebtutor.com/display-prompt-filter-values-in-a-otbi-report/

Hope this help.

Thank you

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28260/otbi-prompt

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?

Create Prompts

Thanks.