ICalculatedCubeInstance.FindElementEntries

Syntax

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

Parameters

Dimension. Dictionary data, which contains the required element.

El. Dictionary element index.

Description

The FindElementEntries method searches for the occurrences of the specified dictionary element 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 Calc_Cube identifier and a dictionary with the Dim_1 identifier.

Sub UserProc;
Var
    Mb: IMetabase;
    CubeInst: ICalculatedCubeInstance;
    Dim: IDimInstance;
    Iter: ICalculatedCubeIterator;
Begin
    Mb := MetabaseClass.Active;
    CubeInst := Mb.ItemById("Calc_Cube").Open(Null) As ICalculatedCubeInstance;
    Dim := Mb.ItemById("Dim_1").Open(Null) As IDimInstance;
    Iter := CubeInst.FindElementEntries(Dim, 0);
    While Not Iter.Eof Do
        Debug.WriteLine(Iter.Coord.AsString);
        Iter.Next;
    End While;
End Sub UserProc;

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