ICalculatedCubeInstance.FindCoordEntries

Syntax

FindCoordEntries(Coord: ICalculatedCubeInstanceCoord): ICalculatedCubeIterator;

Parameters

Coord - coordinate, which must be found in calculated cube formulas.

Description

The FindCoordEntries method searches for the occurrences of the specified coordinate 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. The source cube has two dimensions that are not fixed.

Sub Main;

Var

Mb: IMetabase;

Cube: ICalculatedCubeInstance;

Coo: ICalculatedCubeInstanceCoord;

Ite: ICalculatedCubeIterator;

Begin

Mb := MetabaseClass.Active;

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

Coo := Cube.CreateSourceCoord(Cube.Sources.Item(0));

Coo.MatrixCoord.Item(0) := 0;

Coo.MatrixCoord.Item(1) := 0;

Ite := Cube.FindCoordEntries(Coo);

While Not Ite.Eof Do

Debug.WriteLine(Ite.Coord.AsString);

Ite.Next;

End While;

End Sub Main;

After executing the example the coordinate in the first source cube is collected and this coordinate is searched in calculated cube formulas. In case of successful search symbolic signs of the calculated cube coordinates, which formulas have required coordinate, are displayed.