ICalculatedCubeInstance.FindCubeEntries

Syntax

FindCubeEntries(Cube: ICubeModel): ICalculatedCubeIterator;

Parameters

Cube. The cube that must be found in calculated cube formulas.

Description

The FindCubeEntries method searches for the occurrences of the specified cube 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 and a cube with the Cube_1 identifier.

Sub UserProc;
Var
    Mb: IMetabase;
    CubeInst: ICalculatedCubeInstance;
    FindCube: ICubeModel;
    Iter: ICalculatedCubeIterator;
Begin
    Mb := MetabaseClass.Active;
    CubeInst := Mb.ItemById("Calc_Cube").Open(Null) As ICalculatedCubeInstance;
    FindCube := Mb.ItemById("Cube_1").Bind As ICubeModel;
    Iter := CubeInst.FindCubeEntries(FindCube);
    While Not Iter.Eof Do
        Debug.WriteLine(Iter.Coord.AsString);
        Iter.Next;
    End While;
End Sub UserProc;

After executing the example occurrences of the specified cube in calculated cube formulas are searched. In case of successful search symbolic signs of the calculated cube coordinates, which formulas have a reference to the required cube, are displayed.