Order of calculation

Rules take precedence over consolidations within dimensions.

When a cube cell is calculated by a rule and a consolidation, the rules statement is examined first. However, if the rules statement refers to cells that are the result of consolidations, TM1® first performs the required consolidations and then calculates the rules statement using the results.

Conversely, if a cell is defined by consolidation only, TM1 looks at the values needed to perform the consolidation. When some values are the result of rules calculation, TM1 performs the required rules calculation before performing the consolidation.