The more rules you implement the more overall cube performance will be impacted. Specifically, the native consolidation ability of TM1 will slow down. To address this performance issue, you must make use of the SKIPCHECK
and FEEDERS
declarations.
Adding rules to a cube will impact TM1's ability to utilize its sparse consolidation algorithm. Fortunately, you can tell TM1 where to look for rules-derived values.
The SKIPCHECK
declaration should be placed in the cube's rule file. This turns on the TM1 sparse consolidation algorithm.
The FEEDERS
declaration indicates that you have provided feeder statements which will ensure that the correct cells are not skipped during consolidations.
Each feeder statement must have a feeder area and a reference to a rules-calculated value.
Whenever a feeder statement identifies a rules-derived value, which is a non-zero value, a placeholder is fed to the cells defined on the right-hand...