Oracle Analytics and AI

User_B857U

Riyaz Ali-Oracle

Hi @User_B857U ,

Try the below:

1. Create the Dashboard Prompt:
   Go to New → Dashboard Prompt.
   Select a subject area that contains the column you want to prompt (e.g., Business Unit, Department).
   Add the column as a Column Prompt.
   Set it to populate a presentation variable, e.g., P_BU.
2. Modify Each Query in the Union Analysis
   Open your union analysis.
   For each query block, apply a filter using the presentation variable:
   sql
   "Business Unit"."Name" = @{P_BU}
   This ensures that the prompt value is passed to all parts of the union.
3. Add the Prompt and Analysis to a Dashboard
   Create a new dashboard or edit an existing one.
   Add the dashboard prompt to the top section.
   Add the union analysis below it.
   Ensure the prompt is set to apply to the entire dashboard page.

Check the below as it might be helpful:

Creating Analyses and Dashboards in Oracle Transactional Business Intelligence

Thanks,
Riyaz Ali