OBIEE - passing dashboard prompt into multiple analysis

Question

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!

[Deleted User] · Answer

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?

Gianni Ceresa · Answer

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.

3427784 · Answer

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.