Cognos TM1 Rules is very powerful but not always the best way to calculate results. For example, although it is possible to write rule logic to calculate consolidations within dimensions, dimension calculations work automatically and are therefore always faster than a rule. The subject of performance is a topic that is beyond this chapter but should not be overlooked.
There are some important points about behaviors of Rules:
Cognos TM1 Rules takes precedence over dimension consolidations but keep in mind that if a rule refers to cells in the cube that are the result of a consolidation calculation, the calculation is performed first, then the rule is calculated based upon that result. Going the other way, if a consolidation calculation is based upon cells that are the result of a rule, the rule will execute first and then the consolidation.
You have no control over the order in which Cognos TM1 performs dimension consolidations. So, do not...