Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Hierachical graph drilldown return link option
Hi,
With OBIEE 12.2.1.2, I have created a report using a parent-child hierarchy -similar to the "Value Based (Parent Child) Hierarchy" report in SampleApp V607 (Dashboard - 6.10 report building features). I have created a vertical bar graph view which allows parent -> child drilldown on clicking any parent bar. However I am struggling to find a configuration option which allows a return to the previous parent view. Is there one available?
Also, once a drill down action is done on the Graph view, the graph data is not updated with the hierarchical prompt override set up in the selection steps. Am I missing something? The table view for the same analysis is updated though.
Answers
-
On your first question when you use this functionality what happens is the underlying analysis is dynamically re-rendered to be filtered to the value you clicked on and adds the child member (key or descriptive equivalent) to the presentation.
Using the back arrow will revert you to the pre-drill condition, I don't know of any other for drill in place as standard.
I am not following your second statement - could you post a picture please or explain further?
"the graph data is not updated with the hierarchical prompt override set up in the selection steps" - aren't we drilling down here - where did the selection steps come into this?
0 -
Thanks Robert. Unfortunately the browser back does not revert to the pre-drill graph view. I have added a graph view to the sample App (prodney/bitech#1) report "Value Based (Parent Child) Hierarchy" here
For #2, say my initial graph view is for Top level Account. I drill on one account value which takes me to the child account graph view. I have built a hierarchical prompt based on the parent child hierarchy and added selection steps to my analysis to override data with prompt selection. I have two views on the analysis - a table view and a vertical bar graph view. Added the prompt and analysis (both views) to a dashboard.
I drill on the top level parent account in the graph to see the children accounts. Now I select a value from the hierarchical prompt and hit apply. The data in the table changes but the graph remains the same. So, in the image below - Account hierarchy prompt has a selection of child account US Motor Works - Wholesale. The table view has changed but the graph view has not
0 -
See => Hierarchical Columns & Graph Drill Down Appending Issue
Did you construct your graph with the hierarchy as described in the hit above?
0 -
Yes, the analysis/graph was built using the hierarchy pulled in from the presentation layer.
0