nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

How can i create a prompt to filter two graphs at the same time

John305

Hello,

I am creating an analysis and i want to have a prompt filtering both graphs , how can i do it ?

Thank you , i dont use OBIEE that much !

Find more posts tagged with

Accepted answers

All comments

DNK

If you are trying to put the analyses on the dashboard. Please create a dashboard prompt and you can search internet on how to create dashboard prompts in OBIEE

Thanks

DNK

John305

If i create a dashboard prompt , then i will have to choose a prompt then to execute the report , i can't after that change the value of the prompt .

Is there any dynamic prompt to change a prompt value without executing again the report ?

Thank youu

ArijitC

In dashboard properties or prompt page properties , if you hide apply and reset button ...it will not ask you to submit the report again. It will apply new prompt as soon as it is selected. Check if this is what you want ... Par your requirement you need to use dashboard prompt.

Gianni Ceresa

Your screenshot looks like a single analysis with 2 views, right? If it's the case the easiest way is to set a master-detail, so the table view where you have the year prompt will drive the other view on the left (a chart I guess) and change the year directly.

If it's 2 analysis or you want it in a dashboard page than you can also do what others above posted with a prompt (just remove the column YEAR from the prompt area of the table view as it will always contains a single value, so useless).

John305

Thank you Gianni , One more question

When i put the prompt and the Report in the same dashboard the prompt doesn't filter the report ... do i have to make the link somwhere ?

Thank you

Gianni Ceresa

In the analysis you need to add a filter on the column as "is prompted".

Because it's a real filter (so the query sent to the source contains a WHERE clause filtering the value, you change the value a new query is executed), while the one you used as example is just a visualization filter (so the query is executed once without filters).

John305

Hello GIanni ,

Just to understand well

Case of Analysis report ( not dashboard ) :

I have 2 Graphs in the same report , if i want to have only one prompt for both graphs , i try to create a master detail channel MD01 with my YEAR_ID column

then i go to my second graph ( in the same report ) i make the YEAR_ID as a prompt and define the graph as a listener to my Master detail MD01 but it doesnt work

John305

It works Thank you Gianni !

Gianni Ceresa

So you managed to get master-detail to work?

Or you managed to fix the dashboard prompt issue not filtering your analysis?

John305

I used the filter prompt with the dashboard , for the master-detail i didn't try it ! but the second solution is better tho.

When i try to see the report as a .pdf it becomes in disorder , is it normal ?

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80