IPivot.DimCount

Syntax

DimCount: Integer;

Description

The DimCount property returns the number of data sources dimensions, on which the table is based.

Example

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

Sub UserProc;
Var
    MB: IMetabase;
    Expr: IEaxAnalyzer;
    Pivot: IPivot;
    DimInst: IDimInstance;
    i, j: Integer;
Begin
    MB := MetabaseClass.Active;
    Expr := MB.ItemById("EXPRESS_REPORT").Bind As IEaxAnalyzer;
    Pivot := Expr.Pivot;
    For i := 0 To Pivot.DimCount - 1 Do
        DimInst := Pivot.DimItem(i);
        Debug.WriteLine(DimInst.Name);
        Debug.Indent;
        For j := 0 To DimInst.Elements.Count - 1 Do
            Debug.WriteLine(DimInst.Elements.Name(j));
        End For;
        Debug.Unindent;
    End For;
End Sub UserProc;

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.

See also:

IPivot