| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Drilling in Grids"
(Created page with '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. R…') |
m (Centered table) |
||
| Line 13: | Line 13: | ||
; {{Menu|[[Grid Properties]]|Appearance|Show drill indicator}} | ; {{Menu|[[Grid Properties]]|Appearance|Show drill indicator}} | ||
: If a member is drillable, a symbol can be displayed before the member's caption: | : If a member is drillable, a symbol can be displayed before the member's caption: | ||
| − | :{| class="wikitable" | + | :{| class="wikitable" style="margin: 1em auto 1em auto;" |
| + || Member can be drilled down | | + || Member can be drilled down | ||
|- | |- | ||
| − | | - || Member can be drilled up | + | | align="center" | - || Member can be drilled up |
|- | |- | ||
| || Member cannot be drilled | | || Member cannot be drilled | ||
Revision as of 17:51, 5 October 2010
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:
|
|
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.
