ICalculatedCubeDimension.Index

Syntax

Description

The Index property determines index of the connection between source cube and destination cube.

Example

Executing the example requires a calculated cube with the Calc_Cube identifier. A source cube and a destination cube have dimensions Dim_1 and Dim_1_1 that are similar in structure. The Identifier primary index by attribute is created in each dimension.

Sub UserProc;
Var
    MB: IMetabase;
    Cube: ICalculatedCube;
    MObj: IMetabaseObject;
    Dim: ICalculatedCubeDimension;
Begin
    MB := MetabaseClass.Active;
    MObj := Mb.ItemById("Calc_Cube").Edit;
    Cube := MObj As ICalculatedCube;
    Dim := Cube.Sources.Item(0).Dimensions.FindById("Dim_1");
    Dim.Fixed := True;
    Dim.Index := Dim.Dimension.Indexes.PrimaryIndex;
    Dim.Expression(Dim.Dimension.Attributes.Id).AsString := "Dim_1_1.ID";
    MObj.Save;
End Sub UserProc;

After executing the example the Dim_1 source dimension will be fixed. This dimension is absent in the source cube and is bound with the Dim_1_1 by the ID field.