Run the Multi Dimensional Calculation by making it part of the Run All process. You can also do it by itself through its own workflow process.

Turn on Multi Dimensional Calculations in the Run All

To turn on the Multi Dimensional Calculations as part of the Run All:

  1. Select the Maintain module.
    Select Consolidation if prompted for a rule set.
  2. Select Run All Procedures in the General Setup section to open the Run All Procedures editor.
  3. Change the Calculation Multi rule to Active and save your changes.

Key points to keep for consideration:

  • The Delete and Type parameters aren't available when running the Multi Dimensional Calculation via the Run All. If you need to use these parameters, a standalone workflow must be created. See the Create a Standalone Workflow seciton below.
  • The Multi Dimensional Calculation always runs at the end of the Run All as the last step.

Create a standalone workflow

To turn create a standalone workflow to run the Multi Dimensional Calculations, it needs to run the fl.CalculationMulti stored procedure with these parameters:

ParameterValue
Anaplan1
UserSpecify the user name.
ModelSpecify name of the model.
ScenarioSpecify the Scenario name.
DateSpecify the Date.
EntitySpecify the Entity name.
CalcNameThis value is optional. You can provide a specific calculation name to run. Otherwise, it'll run all Multi Dimensional calculations defined in the system.
TypeThis value is optional. You can provide a Calculation Type and only Multi Dimensional Calculations defined as that type will run. Otherwise, it'll run all Multi Dimensional calculations defined in the system.
Delete

This value is optional. It defines if the target Dataview, Scenario, and Date will be cleared before the calculation is run. If this parameter isn't defined, it'll default to True.

Boolean (1 or 0)

  • 1 = TRUE. It'll clear the Target Dataview, Scenario, and Date.
  • 0 = FALSE. It'll not clear the target data.