Stacking rules

A rules statement can refer to a cube cell that is defined by another rules statement, and so on.

TM1® stacks rules statements until it can obtain a final value, and then works back to return a result. The number of levels of stacking that can be accommodated is limited only by available memory.

If a circular reference occurs within a rules stack, or the maximum level of stacking is exceeded, TM1 returns the error message:

Error Evaluating Rule: Possible Circular Reference

Here is an example of a circular reference:

['Sales'] = ['Units'] * ['Price'] ;

['Price'] = ['Sales'] / ['Units'] ;