IPivotDimension.DimInstance

The DimInstance property returns data of a dimension, which index is passed by the Index parameter.

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;
    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 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.

IPivotDimension.DimInstance

Syntax

Description

Example