Hierarchical Columns & Graph Drill Down Appending Issue — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Hierarchical Columns & Graph Drill Down Appending Issue

Received Response
11
Views
3
Comments
user9193115
user9193115 Rank 1 - Community Starter

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

  • DNK
    DNK Rank 3 - Community Apprentice

    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

    pastedImage_0.png

    Thanks

    DNK

  • user9193115
    user9193115 Rank 1 - Community Starter

    Thanks DNK.

    Its working fine now.

  • DNK
    DNK Rank 3 - Community Apprentice

    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