Hierachical graph drilldown return link option

Question

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.

Layman-Oracle · Answer

Yes, the analysis/graph was built using the hierarchy pulled in from the presentation layer.

Robert Angel · Answer

See => Hierarchical Columns & Graph Drill Down Appending Issue

Did you construct your graph with the hierarchy as described in the hit above?

Layman-Oracle · Answer

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