Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K 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
Hierarchical Columns & Graph Drill Down Appending Issue

Hi,
I am using OBIEE12c and created a bar graph based on Hierarchical column and one measure. When i click on bar graph, it gets drill down to next level.
I have observered that the previous level also gets appended in the graph X- Axis.
Like, If I have one Hierarchy as Country --> State--> City Then while clicking on Country it drill to State level but in X-axis(Horizental)the lebel description showing as Country State.
I know, its product statndard functionality.
My client want me to display only selected level on drill. Means if I drill from Country to State, only State should be display in X-axis (Horizental) lebel.
Could you please let me know how to restrict the previous lebel getting appened in graph.
Best Regards,
Ritesh
Answers
-
Hello, You can pull the Hierarchy itself to Presentation layer and create your graph from the Hierarchy itself (not the Hierarchical columns)then you would achieve the functionality you want.
Below is the sample screenshot
Thanks
DNK
0 -
Thanks DNK.
Its working fine now.
0 -
Hello, Is there any reason you kept as Assumed answered.Do you need anything to confirm on this?If not please make answered and close the thread.
Thanks
DNK
0