Manage procedural calculations
Procedural calculations are a type of formula applied to members of the Account dimension.
You use Model Manager's Edit Procedural Calculations dialog to manage, within each rule set, the following:
- the order in which the procedural calculations run
- the data entry triggers and their order
- the execution method (SQL or MDX)
To manage procedural calculations
- In Model Manager, select the model's Account dimension.
-
In the lip click .
Note: This option is disabled if the dimension contains no procedural calculations.
The Edit Procedural Calculations dialog opens.
The drop-down lists all rule sets that contain procedural calculations.
- Select a rule set.
-
Do any of the following:
-
To manually define data entry triggers: Click and in Selector choose which account or accounts prompt the procedural calculation.
-
To automatically generate a list of data entry triggers: Click and click Yes.
-
To set SQL as the execution mode: Turn on Use SQL execution.
Note: By default, all procedural calculations use the MDX engine; the Use SQL execution option is enabled if the calculation's formula respects the following restrictions:
-
uses FP&A syntax only (not MDX)
-
uses account key references
-
uses numeric constants
-
uses the LAG or LEADfunctions
-
uses simple arithmetic operators (such as +,-, *, /, and brackets to control order of operation)
Tip: If the SQL option is disabled, to find out why click .
-
-
To change the order in which the rule set's procedural calculations run: Select a calculation and use the arrow buttons to move it up or down.
-
- Click OK.