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.