Using STET and CONTINUE in TM1 Rules

Often we want to tell TM1 to ignore this cell and move onto the next cell if a certain condition is met (or not met).  To do this we would typically create a rule with the syntax of if x is true, then continue processing, otherwise ignore this cell. Stet and Continue allow us to have this flexibility.

Example of Stet and Continue in a TM1 Rule

[ ] = N: IF ( ELISANC ( ‘Planning Cost Centre’, ‘BMFA’, !PlanningCostCentre ) = 1, CONTINUE, STET );

This use of STET and CONTINUE is saying that if the current cost centre is a child of the element ‘BMFA’, then Continue to process rules and if not, then Stet (skip) this intersection.

Why would we use it?

One of the primary uses of this function is to determine if the Rules are to be applied or not.  So, if for example you have multiple scenarios but only want rules to be applied to ‘Current Forecast’ and ‘Current Budget’, then a rule like:

[] = IF (!p_Scenario @= ‘Current Forecast’ % !p_Scenario @= ‘Current Budget’ , CONTINUE, STET);

would allow us to achieve that result, thus limiting the code that needs to be entered against every subsequent rule.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

This entry was posted in Rule Functions. Bookmark the permalink.

One Response to "Using STET and CONTINUE in TM1 Rules"

Log in to post a comment.