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.
Interesting findings in rules
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Interesting findings in rules
Although the official document is saying,
- Elessar
- Community Contributor
- Posts: 346
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Interesting findings in rules
(Was long ago in 9.5.2)
This broke my brain, when I tried to analyze a rule with 3 (!) SKIPCHECKS
The rule begins to be evaluated from the last SKIPCHECK statement
This broke my brain, when I tried to analyze a rule with 3 (!) SKIPCHECKS
The rule begins to be evaluated from the last SKIPCHECK statement
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Interesting findings in rules
haha, good one.
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Interesting findings in rules
I went to a customer in the south of England who were using this feature of the rule parser to write extensive well formatted documentation of their rules. Couldn't believe it then went back to read the parser code and, lo and behold, it was confirmed. However it looked as if it was completely accidental. I suppose only Manny could tell for sure.
- PavoGa
- MVP
- Posts: 618
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: Interesting findings in rules
This race of beings of which you speak, of what heretofore unknown lands in the south of England whence they came?
Ty
Cleveland, TN
Cleveland, TN