TDecisionSource.DrillDimIndex Method

Collapses a dimension to focus on a single value.

Pascal

procedure DrillDimIndex(dimGroup: TDimGroup; Index: Integer; ValueIndex: Integer; bOpen: Boolean);

C++

__fastcall DrillDimIndex(TDimGroup dimGroup, int Index, int ValueIndex, Boolean bOpen);

Description

Call DrillDimIndex to "drill down" on a dimension, so that only the summaries for a single value are displayed.

The dimGroup parameter specifies the type of dimension to be drilled. If dimGroup is dgRow, the Index parameter identifies a row dimension to be drilled. If dimGroup is dgCol, Index identifies a column dimension to be drilled. No other values for dimGroup should be used with the DrillDimIndex method. The first row or column dimension has an Index of 0, the second dimension has an Index of 1, and so on.

The ValueIndex parameter is the index of single value from all values over the dimension that should be displayed. To display only the summaries over the entire dimension, rather than for a single value along the dimension, set ValueIndex to -1.

The bOpen parameter specifies whether closed dimensions are counted when interpreting Index. Only open dimensions are counted when bOpen is true.

To restore the dimension from its drilled state so that it displays all values again, use the ToggleDimIndex method.

Note: Do not drill a dimension of the Decision Source unless the CurrentSum property specifies an additive summary. Additive Summaries are SUM and COUNT. AVERAGE (unless calculated internally by the Decision Cube), MAX, and MIN are not additive.