OBIEE - passing dashboard prompt into multiple analysis — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE - passing dashboard prompt into multiple analysis

Received Response
61
Views
4
Comments
3427784
3427784 Rank 4 - Community Specialist

Hi OBIEE gurus,

I am stuck on a specific problem (scenario provided below).

I want to be able to pass my dashboard prompt values into 6 separate analysis. Example - users will select a "Region" in the dashboard prompt (which already has 6 states pre-set for each region in the USA) and will render 6 analysis to show revenue over time for each of those 6 states for the given dashboard prompt value selected under "Region". I've looked into presentation variables but that doesn't seem to be a solution for this problem. I have also looked into trellis but I don't like how the graphs are crunched up together. Any help would be greatly appreciated!

Answers

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

    Why would it not pass the filtered value to the analyses? Is it because they are all based on different Subject Areas? Any if they are based on different SAs why would a presentation variable not work? Both approaches are there since more than a decade and extremely banal configuration.

    Also: You're not providing a lot of information...

  • 3427784
    3427784 Rank 4 - Community Specialist

    Thanks for your reply Christian. They are all under the same SA. I know that it will pass the filter value into the analyses but my problem is having the values from the dashboard prompt to automatically pass into 6 analyses. Eg - Select "Northeast" under region prompt, and the expectation is to have the dashboard display 6 separate analyses that are currently pre-set the Northeast region. It will show NY, PA, DC, etc. and their revenues over time. Hoping this makes sense if not I will upload some examples here shortly once I am back home.

  • Still not sure to get exactly what you expect but ...

    Do you want to display a different set of analysis based on the selected value of your prompt?

    Because you generally do that with a single analysis using either a trellis view or the "section" property of the selected view (table or chart) which will repeat the view for each value of the column.

    Now if you have your own analysis hardcoded for various values and so want your prompt to decide which analysis to display, you need to use sections in the dashboard and conditions on each section to decide if you display it or not.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    3427784 wrote:They are all under the same SA. I know that it will pass the filter value into the analyses but my problem is having the values from the dashboard prompt to automatically pass into 6 analyses.

    If the analyses are all the same SA and have a filter got "Region = IS PROMPTED" then 'Northeast' will be passed to all analyses. That's how the product works since it was invented.

    If you then want another split by states within that region - why use different analyses in the first place? Why not filter one analysis by region and then split by state inside the visualization?