IBM Cognos TM1 Developer's Certification Guide

Conditional drill rules

At some point you may want to add some additional logic to your drill process rule. You can use any valid TM1 Rules function to do this in your rule.

Some simple examples of this might be as follows:

# Sample drill number 1
#- Define the area- in this case the model dimension is used and the
#- area is defined as 'Standard #- Model'. If the standard model in the #- surfboard Meta cube is X then execute the drill process
#- named launch_standard_model
['Standard Model']=s:IF(DB('Surfboard Meta',!subclass, !version, 'Standard Model')@='X','launch_Standard_Model','');

and

# Sample drill number 2 #- Define the area- in this case the model dimension is used and the #- area is defined as 'Long #- Board Model'. If the long board ...