O'Reilly logo

IBM Cognos TM1 Developer's Certification Guide by James D. Miller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Rule feeders

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.

Note

The Cognos exam requires full understanding of SKIPCHECK!

The FEEDERS declaration indicates that you have provided feeder statements which will ensure that the correct cells are not skipped during consolidations. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required