Difference between revisions of "Drilling in Grids"

(Drill Across)
(Drill Across)
 
Line 31: Line 31:
 
[[File:GridDrillAcross1.png]]
 
[[File:GridDrillAcross1.png]]
  
 
+
The data is filtered to 2007, and drilled into the promotions.
When we click OK the data is filtered to 2007, and drilled into the promotions.
 
  
 
[[File:GridDrillAcross2.png]]
 
[[File:GridDrillAcross2.png]]

Latest revision as of 13:05, 14 October 2013

Drilling up and down is probably the simplest OLAP technique to master: it is simply a way of expanding and collapsing the cells in a Grid report to show their component parts. Row or column members can be drilled down to show the child members on the level below, or drilled up again to hide them.

To drill down on a cell, double-click on it. The following shows what happens when you double-click on the All Customer cell:

GridDrilling1.png GridDrilling2.png

Double-clicking on the cell again returns the Grid to its previous state.

Drilling Options

Grid Properties > Appearance > Show drill indicator
If a member is drillable, a symbol can be displayed before the member's caption:
+ Member can be drilled down
- Member can be drilled up
Member cannot be drilled
Grid Properties > Appearance > Indent members when drilling
The indentation of the members in a Grid reflects what level they are on if this option is selected. The size of indentation can also be adjusted.


Drill Across

New in Version 7.6

The drill across menu allows you to expand the grid using a dimension that isn't currently in the grid. In this example we expand the data for 2007 by drilling into the promotions.

GridDrillAcross1.png

The data is filtered to 2007, and drilled into the promotions.

GridDrillAcross2.png

See Also