IMsDetermAggregationTransform.AggregationExpression

Syntax

AggregationExpression: String;

Description

The AggregationExpression property determines the expression for setting aggregation. This property is used only for models that are based on attributes.

Example

Executing the example requires a time series database with the OBJ_RUBRICATOR identifier. COUNTRY and INDICATOR are custom database time series attributes that refer to a dictionary. NATIONAL_ACCOUNTS is a group of dictionary elements, to which the INDICATOR attribute refers.

Sub Main;

Var

mb: IMetabase;

CrInf: IMetabaseObjectCreateInfo;

ModelCont: IMetabaseObjectDescriptor;

obj: IMetabaseObject;

Ruby: IRubricator;

Transform: IMsFormulaTransform;

Model: IMsModel;

TransformVar: IMsFormulaTransformVariable;

Coord: IMsFormulaTransformCoord;

DetermAggregation: IMsDetermAggregationTransform;

Slice: IMsFormulaTransformSlice;

Selector: IMsFormulaTransformSelector;

MetaAttrValList: IMsMetaAttributeValueList;

MetaAttr: IMetaAttribute;

MsMetaAttributeValue: IMsMetaAttributeValue;

Formula: IMsFormula;

DimKey: Integer;

Group: IDimElementGroup;

Begin

mb := MetabaseClass.Active;

CrInf := Mb.CreateCreateInfo;

CrInf.ClassId := MetabaseObjectClass.KE_CLASS_MSMODEL;

CrInf.Name := "New_aggregation";

Ruby := mb.ItemById("OBJ_RUBRICATOR").Bind As IRubricator;

ModelCont := Ruby.ModelSpace;

CrInf.Parent := ModelCont;

CrInf.Permanent := True;

Obj := Mb.CreateObject(CrInf).Edit;

Model := Obj As IMsModel;

Transform := Model.Transform;

Transform.Rubricator := Ruby;

TransformVar := Transform.Outputs.Add(Null);

Coord := Transform.CreateCoord(TransformVar);

Slice := TransformVar.Slices.Add(Null);

Slice.MetaAttributeValueList.Clear;

MetaAttrValList := Slice.MetaAttributeValueList;

MetaAttr := Ruby.Facts.Attributes.FindById("COUNTRY");

MsMetaAttributeValue := MetaAttrValList.Add(MetaAttr);

MsMetaAttributeValue.Value := 215;

Selector := Transform.CreateSelector;

Selector.Slice := Slice;

Formula := Transform.Transform(Selector);

Formula.Kind := MsFormulaKind.DetermAggregation;

DetermAggregation := Formula.Method As IMsDetermAggregationTransform;

Formula.Level := DimCalendarLevel.Year;

DetermAggregation.AggregationExpression := "Panama";

DetermAggregation.WeightsExpression := "Albania";

DetermAggregation.CompositionRelevanceExpression := "Belize";

DetermAggregation.Threshold := 56 / 100;

DetermAggregation.Level := True;

DetermAggregation.Rebase := True;

DetermAggregation.LevelRebaseDate := DateTime.ComposeDay(1998, 1, 1);

DetermAggregation.AgregationMethod := MsAgregationMethodType.Sum;

DetermAggregation.MissingData.Method := MissingDataMethod.SpecifiedValue;

DetermAggregation.MissingData.SpecifiedValue := 1;

MetaAttr := Ruby.Facts.Attributes.FindById("INDICATOR");

DimKey := MetaAttr.ValuesObject.Key;

Group := Mb.ItemByIdNamespace("NATIONAL_ACCOUNTS", DimKey).Edit As IDimElementGroup;

DetermAggregation.AggregationGroup := Group;

obj.Save;

End Sub Main;

After executing the example a model is created in the modeling container of the time series database. This model is based on the attributes of time series database and calculates aggregation by the following expression: = Rebase(Level(Sum((Panama) * (Albania)) / Sum(Albania)), 01.01.1998) where Indicators in National Accounts.