Passing Selected Parameters from Graph to Pivot/Table Views

Question

Dear GURUS,

I have a requirement where I need to build a Dashboard with 2 Graphs and 4 Pivots depending on the Graphs. As per my understanding, it is not a simple case of navigation (maybe, Master-Detail linking, but am unable to figure out).

Environment Details:

OBIEE 12.2.1.3 (I am not using Oracle Visual Analyzer)

Requirement:

Create a dashboard with 2 Stacked Bar Graphs and 4 Pivot views. When a value in the Graph is selected, all the Pivot views should show the data corresponding to that Graph.

There are no Prompts in the Dashboard.

When nothing is selected in the graph, it should display all the values in the Pivot Tables:

If I am selecting certain value in the graph, then the Pivot Views should get filtered out for those specific values:

Here, the selected value is count (Measure) and passed filters to the Pivot Views are Service Name, BU, Count.

Please help me understand how should I proceed here.

Any pointers is appreciated.

Many Thanks in Advance.

SonPat99 · Answer

Hello Joel,

This is not working for me either.

When I am clicking on the graph, it is not passing the values to the Pivot reports.

All these reports are in separate SECTIONS...

Joel Acha · Answer

Then in that case, use is prompted filters on your analyses with the pivot views.

https://docs.oracle.com/middleware/12213/biee/BIEUG/GUID-663B5A97-06B1-4486-8C5E-4261B1758581.htm

Youll need the columns that you want to filter on to be common to both analyses So that the values can be passed down for filtering.

SonPat99 · Answer

Hello Joel,

Thanks for the quick response...

As far as I understand, Master-Detail linking is used in the same report/analysis.

I am not sure how to use it for multiple reports...

Do you have knowledge of any documentation that explains this with multiple reports?

Also, what will be my column for creating the channel as I am using the measure in the master graph, but nothing like that in detail report.

Please help me understand this. Any example will be of much help...