IMDCalculation.TimeDependent

If the property is set to True, the formula actual period can be specified by selected coordinates. It is relevant if the TimeDependencyEnabled property returns True.

Example

Executing the example requires that the repository contains a database with the MDBD identifier and two standard cubes CUBE_INPUT and CUBE_OUTPUT. These cubes are based on the tables stored in this database.

Sub UserProc;
Var
    MB: IMetabase;
    CrInfo: IMetabaseObjectCreateInfo;
    MDCalc: IMDCalculation;
    Cube: ICubeModel;
    FormulasTable: IMDCalculationFormulasTable;
    TableForFormulas: ITable;
Begin
    MB := MetabaseClass.Active;
    CrInfo := MB.CreateCreateInfo;
    CrInfo.ClassID := MetabaseObjectClass.KE_CLASS_MDCALCULATION;
    CrInfo.Id := MB.GenerateId("MDCALC_1");
    CrInfo.Name := "Multidimensional calculation on server";
    CrInfo.Parent := MB.Root;
    MDCalc := MB.CreateObject(CrInfo).Edit As IMDCalculation;
    // Add a database
    MDCalc.Database := MB.ItemById("MDDB").Bind As IDatabase;
    // Specify source cube
    Cube := MB.ItemById("CUBE_INPUT").Bind As ICubeModel;
    MDCalc.Sources.AddCube(Cube);
    // Specify destination cube
    MDCalc.Destination.SetCube(MB.ItemById("CUBE_OUTPUT").Bind As ICubeModel);
    // Create a new formulas table
    If MDCalc.TimeDependencyEnabled Then
        MDCalc.TimeDependent := True;
    End If;
    FormulasTable := MDCalc.FormulasTable;
    TableForFormulas := FormulasTable.Create;
    FormulasTable.Attach(TableForFormulas);
    (MDCalc As IMetabaseObject).Save;
End Sub UserProc;

After executing the example the Multidimensional Calculation on Database Server object is created in the repository root. One source cube and one destination cube are set, a new formulas table is created. If the destination cube has calendar dimension, there is a possibility to specify formula actual period.

IMDCalculation.TimeDependent

Syntax

Description

Comments

Example