Categories
- All Categories
- 10 Oracle Analytics Sharing Center
- 13 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Passing Selected Parameters from Graph to Pivot/Table Views
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.
Answers
-
You are on the right track. The Master Detail functionality should help you achieve this.
https://docs.oracle.com/en/cloud/paas/bi-cloud/bilug/linking-views-master-detail-relationships.html
0 -
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...
0 -
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.
0 -
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...
0
