TM1 Forum

Hello Everyone,

I like to implement a rule which is generally calculated on all levels (N and C) of the dimension in the same way with the exception that for specific dimensions I like to just sum up the data in the normal way.

Solution for this could be to use CONTINUE to skip the normal calculation for an dimension.
[...,...] =
IF( ELLEV( 'Month', !Month) = 0,
<Calculation>,
CONTINUE);

In this way the calculation applies only on the lowest level (N) for the Month Dimension but consolidates the data in the normal way for the hierarchy.

Other scenario could be that I like to consolidate the data only for a specifc C-element and calculate it for the other elements.
[...,...] =
IF( !Product @= 'total_product,
CONTINUE,
<Calculation>);

Is there better way to let tm1 consolidate the data for special elements/dimensions? CONTINUE forces tm1 to check the whole rule in order to make sure that no other rule applies to the cells. So this has an negative impact on the performance. An statement like "Consolidate" would be nice to prevent to parsing to the end of the rule.

Any ideas?

My guess is you should be using STET instead of CONTINUE. That will cause a consolidated cell to revert to the same behaviour it would have if there was no rule attached.

Lazarus wrote:My guess is you should be using STET instead of CONTINUE. That will cause a consolidated cell to revert to the same behaviour it would have if there was no rule attached.

Your are right. Makes sense. I thought somehow that this will prevent the n-level from beeing calculated. But STET only applies in my case on consolidations! Thanks.

I can also simplify my rule by putting an if statement like the following on the top for a measure. Because I have several rules for one measure to cover all the exception...

[...,...] =
IF( !Product @= 'total_product,
STET,
Continue);

#Exception 1: without if statement for c-elements
#Exception 2: without if statement for c-elements
#Exception 3 without if statement for c-elements
#General rule 1 without if statement for c-elements