What is Skipcheck in TM1?

Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. So if you had 30 days in a month and data in only 9 of them, only 9 cells would be aggregated to get the total for the month. With the the skipping of blank cells disabled, all 30 cells would be checked to get the month total – three times more inefficient.

Skipcheck is part of the Sparse Consolidation engine that makes TM1 so extraordinarily fast.

Why is Skipcheck used?

A TM1 cube is constructed by putting a set of dimensions together. Dimensions usually contain rollups of elements. Information is entered at the base level and consolidate upwards through the rollup. For example, value might be entered at the day level and rolled up to Months and then to an element called “All Months”.

Once created, a TM1 cube automatically skips the calculation of empty cells. That is until a rule is added. Rules allow us to do calculations more complicated than simple rollups. For example we could have a rule that says Sales = Units x Average Selling Price –  clearly not a rollup. This addition of a rule turns off the automatic skipping of empty cells and thus diminishes the performance of the TM1 engine.

Where is Skipcheck used?

Skipcheck is almost always placed as the first item in a Rule sheet, thereby instructing TM1 to skip blank cells for the cube concerned.

Use with Feeders

Skipcheck is used in conjunction with Feeders to force TM1 to open intersections that would have otherwise been not used for a calculation. The Feeder “feeds” the otherwise empty cells, opening them for calculation and thus making them not skipped.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.
This entry was posted in Feeders, Rule Functions and tagged skipcheck. Bookmark the permalink.

One Response to "What is Skipcheck in TM1?"

Log in to post a comment.