How these rules work ?
Posted: Sat May 09, 2015 4:52 am
Hello,
Suppose we have 5 entities from E1 to E5, and 3 layers from L1 to L3. In Cube1 we have this rule:
1. Does TM1 check ['Entity':{'E4'},'Layer':{'L1'}], although we haven't any rules on it ? How about the code below ?
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
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);Code: Select all
If (['Entity']@=('E1','E2','E3')&['Entity']@=['L1'], STET, CONTINUE);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