Drill-down/up on Dimension Members

Drilling down on Y dimension

You can drill down/up to a dimension level by clicking on Drill level option in the grid. Also you can drill-down and up the dimension by clicking on the 6 (down arrow) and 5 (up arrow) icons beside the dimension member. Only the member that was selected will be drilled (Drill Level drills down/up the whole dimension).

Lets start with following Query data set:

$images\2-cc-drilldownon-0.gif$

Following figure shows the drill-down for OR in the customer dimension.

$images\2-cc-drilldownony-1.gif$

Now if we perform one more drill-down (on Albany), we will see:

$images\2-cc-drilldownony-2.gif$

Drilling down on X dimension

Lets start with following Query data set:

$images\2-cc-drilldownon-0.gif$

Following figure shows drill-down on time dimension, Q1.

$images\2-cc-drilldownonx-1.gif$

Drilling down on both dimensions

In following figure you can observe how depth of drill-down is illustrated through the shading of the cells in the grid when both X and Y dimension have a drill-down.

$images\2-cc-drilldownonxy-1.gif$

$images\imrcleft.gif$