Tuesday, 5 August 2014

Drill-able hierarchical charts in OBIEE 11g


This is a discovery more than a solution. OBIEE 11g lets us use Hierarchical column as dimensional attributes for charts.

Using hierarchical columns in chart enables us to create drill-able charts. The default view can be the top level view and the user can then drill to a more granular view in the chart on the fly.

Consider the following Analysis. I have dragged hierarchical time dimension column and a measure column. I have created a tabular and a graph view on top of these 2 columns.











Note that the Time total label (highlighted in the above screenshot) is drill-able.

We can see the following week end dates if we drill from 'Time total' label.


3 comments:

Anonymous said...

Hi! I have tried this but when you have drilled down to detail level, how to you "drill-up" or go back to initial graph? There's no back button.

Abhi said...

Vishal Pathak,

Can you post complete steps, I tried but no working for me.

Regards,

Vishal Pathak said...

Its a feature not a solution so no steps for this. Hierarchical columns can be used for drill down in charts.