Interesting findings in rules
Posted: Wed Apr 04, 2018 4:52 am
Although the official document is saying,
But if you put any text without hash in the front before SKIPCHECK statment, TM1 won't give you any error and rule is still valid if you save it. I don't know if it is bug or not. This has been verified in 10.2.2 FP4 and PA2 environments. I assume the rule just begin to be evaluated from SKIPCHECK statement anyway. Anything before that will be ignored.When consolidating data in cubes that have rules defined, TM1 turns off this sparse consolidation algorithm because one or more empty cells may in fact be calculated by a rule. (Skipping rules-calculated cells will cause consolidated totals to be incorrect). When the sparse consolidation algorithm is turned off, every cell is checked for a value during consolidation. This can slow down calculations in cubes that are very large and sparse.
SKIPCHECK;copy to clipboard
If your rule uses a FEEDSTRINGS statement, the SKIPCHECK statement should be the second statement in your rule. If your rule does not use a FEEDSTRINGS statement, the SKIPCHECK statement should be the first statement in your rule.
When you use SKIPCHECK to restore sparse consolidation, you must also ensure that your rule includes a FEEDERS declaration and that all rules-derived cells are identified by feeder statements.