IPivotEvaluatorDimCalculatesList.Item

Syntax

Item(Index: Integer): Integer;

Options

Index is an index of the calculated factor in collection of factors that were created relatively to the Element dimension element.

Description

The Item property returns an index of the calculated factor in collection of factors of the whole dimension.

Comments

Index of the calculated factor, created relatively to the Element element, is defined by the Index parameter.

Example

Executing the example requires a form with the Button1 button, the UiErAnalyzer component named UiErAnalyzer1, and any components that are used for displaying data of a report, loaded into the UiErAnalyzer1 component.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);

Var

OLAP: IEaxAnalyzer;

Grid: IEaxGrid;

Pivot: IPivot;

Dim: IDimInstance;

Calcs: IPivotEvaluatorDimCalculates;

Calc: IPivotEvaluatorDimCalculatesItem;

List: IPivotEvaluatorDimCalculatesList;

i: Integer;

Begin

OLAP := UiErAnalyzer1.ErAnalyzer;

Grid := OLAP.Grid;

Pivot := OLAP.Pivot;

Dim := Pivot.TopHeader.Dim(0);

Calcs := Pivot.Evaluator.DimCalculates;

Calc := Calcs.FindByDimKey(Dim.Key);

List := Calc.FindByDimElement(0);

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

Debug.WriteLine(Calc.CalculatedName(List.Item(i)));

End For;

End Sub Button1OnClick;

After executing this example, clicking the button initiates a search of calculated factors that were created relatively to the first element of a dimension, arranged in columns in a report. Names of the found calculated factors are displayed in a development environment console.