KPI Calculations for Cash Flow Cube


Return to Cash Flow Model Overview

The KPI calculation defines calculations for some elements of a dimension. The calculation is defined through an expression stored in an attribute of the calculated element. The KPI calculation for the Cash Flow cube is defined in the CF Account dimension.

The calculations for elements of the CF Account dimension are defined in the Calculation attribute.

The calculation can be defined as an expression in the Jedox rule syntax. This expression must not contain the target nor the equal sign. It may contain an optional cell-type restriction (B: or C:) followed by any valid rule expression.

For each element of the CF Account dimension having a calculation, a rule instance will be created. This is managed by a rule template.

The creation of rule instances can be restricted by additional dependencies. The dependencies for elements of the CF Account dimension are defined in the CalculationDependencies attribute.

If the calculation dependency is the text Cube: followed by a cube name, the calculation will only be valid if the referred cube exists in the database. Otherwise, the rule instance will not be created by the rule template. If the calculation dependency is empty or the attribute is missing, the calculation is always valid.

The target area of the calculation is the element from the CF Account dimension.

Note: After changing the calculation schemas or the calculations, the rule templates handling the KPI calculations in the fact cubes need to be updated.