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 database server with the MDCalc_1 identifier.
Sub UserProc;
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 UserProc;
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: