IPivotDimensions.Item

Syntax

Item(Index: Integer): IPivotDimension;

Parameters

Index - dimension index.

Description

The Item property returns properties 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 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.