How these rules work ?

[hittony]

Hello,

Suppose we have 5 entities from E1 to E5, and 3 layers from L1 to L3. In Cube1 we have this rule:

Code: Select all

['Entity':{'E1','E2','E3'},'Layer':{'L1'}]=N:if(1@=1, STET, CONTINUE);

1. Does TM1 check ['Entity':{'E4'},'Layer':{'L1'}], although we haven't any rules on it ? How about the code below ?

Code: Select all

If (['Entity']@=('E1','E2','E3')&['Entity']@=['L1'], STET, CONTINUE);

2. The dimension [Decade] isn't in the Cube1, does TM1 check it all the same when the Cube1 is run ?

If all of your answers are yes, I presume that that's why it is better to begin the rules by SKIPCHECK. It is also recommended to order dimensions in a cube by their number of elements or their sparsity in the ascending way, that's because we write rules from the smallest ones. Ex. in a rules file, we often check firstly the years, because there's no need to do calculations for some years, so we should STET them, and the year should be listed on the top of the cube dimensions order list. Is all this logic above right ?

Yours TM1ly
hittony

[David Usherwood]

See my other post - the purpose of Skipcheck is not what you imagine. It is for managing rule calculations so the engine only performs them where there is relevant content. Please read the Rules manual.