O'Reilly logo

IBM Cognos TM1 Developer's Certification Guide by James D. Miller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required