AutoTrend(Input: ITimeSeries; Period: IMsPeriod): Variant;
Input. The variable, which optimal trend must be autoselected.
Period. The period, at which optimal trend is autoselected.
The AutoTrend method selects optimal trend for the variable in the specified period.
If the Period parameter is set to Null, the method is calculated at the entire time period.
Executing the example requires that the repository contains a modeling container with the MS identifier. This container includes a model with the MODEL identifier that is calculated by the determinate equation method and contains at least one input variable.
Add links to the Metabase and Ms system assemblies.
Sub UserProc;
Var
Mb: IMetabase;
ModelSpace, ModelObj: IMetabaseObject;
Transf: IMsFormulaTransform;
Formula: IMsFormula;
Model: IMsModel;
Determ: IMsDeterministicTransform;
TransVar: IMsFormulaTransformVariable;
Slice: IMsFormulaTransformSlice;
TermInfo: IMsFormulaTermInfo;
Expr: IExpression;
Begin
Mb := MetabaseClass.Active;
ModelSpace := Mb.ItemById("MS").Bind;
ModelObj := Mb.ItemByIdNamespace("MODEL", ModelSpace.Key).Edit;
Model := ModelObj As IMsModel;
Transf := Model.Transform;
Formula := Transf.FormulaItem(0);
Determ := Formula.Method As IMsDeterministicTransform;
TransVar := Transf.Inputs.Item(0);
Slice := TransVar.Slices.Item(0);
TermInfo := Transf.CreateTermInfo;
TermInfo.Slice := Slice;
Expr := Determ.Expression;
Expr.References := "Ms;Stat";
Expr.AsString := "AutoTrend(" + TermInfo.TermInnerText + ",SetPeriod(" + """" + "01.01.2003" + """" + "," + """" + "01.01.2006" + """" + "))";
If Expr.Valid
Then ModelObj.Save;
Else Debug.WriteLine(Model is not saved: error in formula);
End If;
End Sub UserProc;
After executing the example optimal trend is selected for the input variable at the period from 2003 to 2006.
Expression 1:
AutoTrend({Brazil|BCA}, SetPeriod("2006A", "2009A"))
Result: optimal trend is selected for the Brazil|BCA series at the period from 2006 to 2009.
Use: it can be used in formulas of cross functional expression editor in any platform tool where it is available.
Expression 2:
AutoTrend(X1,SetPeriod("2006A", "2009A"))
Result: optimal trend is selected for the X1 factor at the period from 2006 to 2009.
Use: it can be used in model formulas of modeling container.
See also:
IModelling | Time Series Database: Calculator | Modeling Container: Editing Regressor or Formula