ICalculatedCubeInstance.FindCoordEntries

Syntax

FindCoordEntries(Coord: ICalculatedCubeInstanceCoord): ICalculatedCubeIterator;

Parameters

Coord. The coordinate that should be found in calculated cube formulas.

Description

The FindCoordEntries method searches for the occurrences of the specified coordinate in calculated cube formulas.

Comments

In case of successful search the method returns iterator by formulas satisfying 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 UserProc;
Var
    Mb: IMetabase;
    CubeInst: ICalculatedCubeInstance;
    Coord: ICalculatedCubeInstanceCoord;
    Iter: ICalculatedCubeIterator;
Begin
    Mb := MetabaseClass.Active;
    CubeInst := Mb.ItemById("Calc_Cube").Open(Null) As ICalculatedCubeInstance;
    Coord := CubeInst.CreateSourceCoord(CubeInst.Sources.Item(0));
    Coord.MatrixCoord.Item(0) := 0;
    Coord.MatrixCoord.Item(1) := 0;
    Iter := CubeInst.FindCoordEntries(Coord);
    While Not Iter.Eof Do
        Debug.WriteLine(Iter.Coord.AsString);
        Iter.Next;
    End While;
End Sub UserProc;

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.

See also:

ICalculatedCubeInstance