How can i filter ONCE in my Dashboard — 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 filter ONCE in my Dashboard

Received Response
51
Views
7
Comments
John305
John305 Rank 5 - Community Champion
edited Aug 13, 2024 6:03PM in Oracle Analytics Cloud and Server

Hi everyone, i am new in OBIEE ,

to construct my dashboard , i did each graph apart , but when i wanna regroup all the graphs in one dashboard , i want to use "One" list to filter "All" graphs. what is the solution  ?

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok first of all:

    John305 wrote:to construct my dashboard , i did each graph apart

    What does that mean? Do you have one analysis object per graph in your catalog?

    John305 wrote:i want to use "One" list to filter "All" graphs. what is the solution ?

    Graphs always talk to all objects which are listening for a prompt-able filter column; either one simply set as "Is Prompted" or one which in Answers isn't marked as "Protected".

  • John305
    John305 Rank 5 - Community Champion

    I did an analys for each graph , and i want to regroup all of them in a dashboard and filter once for all graphs.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    As I said: What you "want" is the normal behaviour of a prompt. It's how they work.

    If you use the same dimensional attribute for filtering - for example "Time"."Year" - and you create a dashboard prompt with the prompt column "Time"."Year" and your analyses (all of them) have "Time"."Year" = "is prompted" then it will do what you want.

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    I'm going to take a guess here and say that you probably built the prompts for each graph within each analysis (by going to the 'Prompts' tab).

    *My below instructions are assuming that all of your graphs are coming from the same subject area. If they are not then we'll need to be a bit more creative and use variable prompts**

    I think what you'll want to do is remove those prompts from within the analysis.

    Then for each attribute that you were prompting, add a filter within the analysis for those attributes -- and then set the operator to 'is prompted' for each one.

    Then create a Dashboard Prompt that prompts for each attribute that you want to prompt on.

    Place your new Dashboard Prompt and your graph reports on a dashboard. Voila! The one dashboard prompt will now work for all of your graphs.

    I hope this helps.

  • John305
    John305 Rank 5 - Community Champion

    i removed all my filter from analysis and i create a dashboard ( image below ) , i create a prompt , but i dont know where to put it

    pastedImage_0.png

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    I'm very sorry. I see all of the text in the screenshots are in French.

    I only speak English 

    You should just be able to put your new dashboard prompt right at the top (or anywhere for that matter) of your dashboard -- just by dragging it from your Catalog pane into your Layout pane.

  • John305
    John305 Rank 5 - Community Champion

    I got what you said guys , thank you it works !