Recursion: TriState;
The Recursion property determines whether formulas interdependency is taken into account on calculation. It is relevant if the RecursionEnabled property returns TriState.OnOption.
Executing the example requires that the repository contains multidimensional calculation on DB server with the MDCalc_1 identifier.
Sub Main;
Var
MB: IMetabase;
MDInst: IMDCalculationInstance;
Args: IMDCalculationCalculateArgs;
Begin
MB := MetabaseClass.Active;
MDInst := MB.ItemById("MDCalc_1").Open(Null) As IMDCalculationInstance;
Args := MDInst.CreateCalculateArgs;
Args.CleanType := MDCalculateArgsCleanType.All;
If Args.RecursionEnabled = TriState.OnOption Then
Args.Recursion := TriState.OffOption;
End If;
MDInst.Calculate(Args);
End Sub Main;
After executing the example multidimensional calculation is executed on DB server. The data consumer is cleared before calculation. If creation of recursive formulas is available in the multidimensional calculation during formula creation, formulas interdependency is disabled on calculation.
See also: