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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
111
Views
12
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

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 !

pastedImage_0.png

«1

Answers

  • DNK
    DNK Rank 3 - Community Apprentice

    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
    John305 Rank 5 - Community Champion

    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
    ArijitC Rank 6 - Analytics Lead

    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.

    pastedImage_1.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    John305 Rank 5 - Community Champion

    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
    Gianni Ceresa Mod

    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
    John305 Rank 5 - Community Champion

    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

    pastedImage_0.png

    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
    John305 Rank 5 - Community Champion

    It works Thank you Gianni !

  • Gianni Ceresa
    Gianni Ceresa Mod

    So you managed to get master-detail to work?

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

  • John305
    John305 Rank 5 - Community Champion

    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 ?