ICalculatedCubeInstance.FindDimensionEntries

Syntax

FindDimensionEntries(Dimension: IDimensionModel): ICalculatedCubeIterator;

Parameters

Dimension - dictionary, which must be found in calculated cube formulas.

Description

The FindDimensionEntries method searches for the occurrences of the specified dictionary 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: IDimensionModel;

Ite: ICalculatedCubeIterator;

Begin

Mb := MetabaseClass.Active;

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

Dim := Mb.ItemById("Dim_1").Bind As IDimensionModel;

Ite := Cube.FindDimensionEntries(Dim);

While Not Ite.Eof Do

Debug.WriteLine(Ite.Coord.AsString);

Ite.Next;

End While;

End Sub Main;

After executing the example the occurrence of the Dim_1 dictionary into calculated cube formulas is searched. In case of successful search symbolic signs of the calculated cube coordinates, which formulas contain links to required dictionary, are displayed.