ICalculatedCubeInstance.FindElementEntries

Syntax

FindElementEntries(Dimension: IDimInstance; El: Integer): ICalculatedCubeIterator;

Parameters

Dimension - dictionary data, among which the required element is located.

El - index of dictionary element.

Description

The FindElementEntries method searches for the occurrences of the specified dictionary element in calculated cube formulas. In case of successful search the method returns iterator by formulas, which fit search conditions.

Example

Executing the example requires that the repository contains a calculated cube with the Calc_Cube identifier and a dictionary with the Dim_1 identifier.

Sub Main;

Var

Mb: IMetabase;

Cube: ICalculatedCubeInstance;

Dim: IDimInstance;

Ite: ICalculatedCubeIterator;

Begin

Mb := MetabaseClass.Active;

Cube := Mb.ItemById("Calc_Cube").Open(Null) As ICalculatedCubeInstance;

Dim := Mb.ItemById("Dim_1").Open(Null) As IDimInstance;

Ite := Cube.FindElementEntries(Dim, 0);

While Not Ite.Eof Do

Debug.WriteLine(Ite.Coord.AsString);

Ite.Next;

End While;

End Sub Main;

After executing the example the first element of the Dim_1 dictionary in calculated cube formulas is searched. In case of successful search symbolic signs of the calculated cube coordinates, which formulas have the required element, are displayed.