Setting Up Calculation Formulas

Calculation formulas determine how data from sources will be transformed before loading to data consumer.

To set up calculation formulas:

After executing the operation the Formula Editor dialog box opens:

To set up a calculation formula:

  1. Create a formula.

  2. Select the calculated dimension element and calendar frequency.

  3. Generate a calculation formula.

  4. Set up advanced parameters for calculation and saving data.

As a result, the calculation formula is set up. If required, similarly set up other formulas.

The formulas will be calculated in the order they follow on the formula bar. To reorder formulas, use the Up and Down buttons or drag formulas.

IMPORTANT. If the same data source is used in formulas as operand, take into account formulas calculation order. Formula A that uses result of Formula B calculation must follow the formula B where resulting data source is calculated. Source data is changed after the first formula calculation and the modified data set is used in the next formulas.

To exclude formulas from calculation, select them, hold down the CTRL or SHIFT key and select the Exclude from Calculation context menu item. If formulas are grouped in the folder, to exclude all formulas in the folder from calculation, select the same item in the folder context menu. To calculate excluded elements, select the Include in Calculation context menu item.

To delete formula:

  1. Select the formula.

  2. Execute one of the operations:

After executing operations the formula will be deleted from the formulas list.

See also:

Inserting and Setting Up Calculation Blocks