ICalculatedCube.ExternalFactDimension

Syntax

ExternalFactDimension: Boolean;

Description

The ExternalFactDimension property determines whether the local fact dimension is used for a calculated cube.

Comments

If the ExternalFactDimension property is set to True (default value), local fact dimension is not used in the cube. In this case, source cube fact dimensions are used.

If the ExternalFactDimension property is set to False, the cube uses a local fact dimension. The local fact dimension is based on the built dictionary that is created automatically as a cube's hidden child object. To set up a built dictionary and create an element tree, use the InternalFactDimension property.

Example

Executing the example requires that the repository contains a calculated cube with the Calc_Cube identifier.

Sub UserProc;
Var
    MB: IMetabase;
    Cube: ICalculatedCube;
    Facts: ICustomDimTree;
    v: Variant;
Begin
    MB := MetabaseClass.Active;
    Cube := MB.ItemById("Calc_Cube").Edit As ICalculatedCube;
    Cube.ExternalFactDimension := False;
    Facts := Cube.InternalFactDimension.Tree;
    v := Facts.Add(Null);
    Facts.Name(v) := "Parameter 1";
    v := Facts.Add(Null);
    Facts.Name(v) := "Parameter 2";
    (Cube As IMetabaseObject).Save;
End Sub UserProc;

After executing the example the calculated cube uses a local fact dimension, two elements are created in the dimension.