IMDCalculation.TimeDependent

Syntax

TimeDependent: Boolean;

Description

The TimeDependent property determines time dependency of formulas.

Comments

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 Main;

Var

MB: IMetabase;

CrInfo: IMetabaseObjectCreateInfo;

MObj: IMetabaseObject;

MDCalc: IMDCalculation;

Cube: ICubeModel;

Source: IMDCalculationSource;

Destination: IMDCalculationDestination;

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 := Null;

MObj := MB.CreateObject(CrInfo).Edit;

MDCalc := MObj As IMDCalculation;

//Add DB

MDCalc.Database := MB.ItemById("MDBD").Bind As IDatabase;

//Indicate source cube

Cube := MB.ItemById("CUBE_INPUT").Bind As ICubeModel;

Source := MDCalc.Sources.AddCube(Cube);

//Indicate destination cube

Destination := MDCalc.Destination;

Destination.SetCube(MB.ItemById("CUBE_OUTPUT").Bind As ICubeModel);

//Create new formula table

If MDCalc.TimeDependencyEnabled Then

MDCalc.TimeDependent := True;

End If;

FormulasTable := MDCalc.FormulasTable;

TableForFormulas := FormulasTable.Create;

FormulasTable.Attach(TableForFormulas);

MObj.Save;

End Sub Main;

After executing the example the Multidimensional Calculation on DB 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.