IPivotDimensions.Count

Syntax

Count: Integer;

Description

The Count property returns the number of data source dimensions, on which basis the table is formed.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier.

Sub Main;

Var

MB: IMetabase;

Expr: IEaxAnalyzer;

Pivot: IPivot;

Dims: IPivotDimensions;

Dim: IPivotDimension;

DimInst: IDimInstance;

i, j: Integer;

Begin

MB := MetabaseClass.Active;

Expr := MB.ItemById("EXPRESS_REPORT").Bind As IEaxAnalyzer;

Pivot := Expr.Pivot;

Dims := Pivot.Dimensions;

For i := 0 To Dims.Count - 1 Do

Dim := Dims.Item(i);

DimInst := Dim .DimInstance;

Debug.WriteLine(DimInst.Name);

Debug.Indent;

For j := 0 To DimInst.Elements.Count - 1 Do

Debug.WriteLine(DimInst.Elements.Name(i));

End For;

Debug.Unindent;

End For;

End Sub Main;

After executing the example, all the elements and names of dimensions, that are in express report data sources, are displayed in the development environment console.