IMDCalculationSource.IncludeInPointset

Syntax

IncludeInPointset: Boolean;

Description

The IncludeInPointset property determines whether this data source is included into initial set of data sources, by which a list of calculation points is created.

Comments

The list of calculation points is created on the basis of all elements contained in fixed dimensions of initial set data sources.

Example

Executing the example requires a database with the MDBD identifier and also three standard cubes: CUBE_INPUT1, CUBE_INPUT2 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;

//Specify the first source cube

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

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

Source.IncludeInPointset := True;

//Specify the second source cube

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

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

Source.IncludeInPointset := True;

//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 a calendar dimension, a formula actual period can be specified.