Define Multi Dimensional Calculations form in the Maintain module to define calculations and data transfers.

Warning: Whenever you run the Calculation Multi process, it'll always clear out the target DataView, Scenario, Entity, and Date. It is recommended to create a DataView member called ValueCalc to hold the target of the Calculation Multi. Set the DataViewType property of the member to Value to ensure that no source data is overwritten.

Access the form

To access the form:

  1. Select the Maintain module.
  2. Select Multi Dimensional Calculations from the Calculation section. 

Use the form

These columns for the Multi Dimensional Calculation form are available:

ColumnValue
DetailsSelect the link to the calculation details.
Calculation NameSpecify name of the name of the calculation.
ModelSelect name of the model where the calculation will be applied to
Calculation Order

Enter the number specifying the order the calculation runs in. 

It must be an integer value and allows you to order calculations in case of any dependencies.

Store Target

It's whether the target of the calculation will be stored or not.

  • True: Calculation result is stored in the database.
  • False: Data is calculated but not stored in the database. This can be used if the result of a calculation will be used for another calculation, but it doesn't need to be stored.
Sort OrderEnter a value for the order, the rules will appear in the form.

Once you select a calculation, you can set the calculation details: 

FieldDefinition
Rule Number

Enter the number of the rule. You can create multiple lines for the same rule number

This field isn't currently used in the calculation.

Source Target

Select value from the dropdown to specify whether the defined intersection is a source or a target of the calculation

You can have multiple sources but should only have one Target in a Multi Dimensional calculation.

Step

Specify the step number. If you are using only additions (+) and/or subtractions (-) in your Calculation Multi rule, all steps should be set to 0. 

If you are introducing any multiplication (*) or Divisions (/) in your rule, you need to change the step number to control the calculation order: Brackets, Exponents, Multiplication, Division, Addition, and Subtraction (BEMDAS). 

For example, if you want to include a multiplication, change the step order to 1. To further include another calculation in order, change the step to 2, and so on.

Local CurrencySelect True or False to specify if the calculations step works in local currency.
Operator

Select the operator to be used, such as +, -, /, *, ~ (Inverse). 

Currently % isn't supported.

<Dimensions>

A column for each dimension in the tenant is displayed. 

The Target or the DataView dimension should be a specific DataView used for calculation multi. It's suggested to create a DataView called ValueCalc to hold the target of the Calculation Multi and set the DataView Type property of the member to Value. 

If you specify the Source as a parent and leave the target blank for that same dimension, all leaf levels under that parent will be copied to the same target leaf's.

Warning: Whenever you run the Calculation Multi process, it'll always clear out the target Dataview, Scenario, Entity, and Date. This is why we recommend specifying the valuecalc dataview as the target to not clear any source data.

Sort OrderSpecify a numeric value to set order for the rules to appear in the form.