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 rules

In Chapter 4,Rules, we discussed the idea that Cognos TM1 rules can be written with conditional evaluation (you can use the IF function to force TM1 to evaluate a rule differently depending on a logic test). This feature can be utilized in our virtual cube example.

Using conditional rules within a virtual cube

Sometimes, it might be more realistic to wait until data is in a complete or approved state before making that data available in the consolidation cube, yet it is not desirable to have to intervene for sending or copying the data. One way to accomplish this might be to use conditional logic to modify your rule slightly:

['Current Forecast','Northern']=N:IF(DB('SysCntrl', 'Northern', 'ForecastStatus')=1,DB('Northern','Actual',!Period,!Region,!Product,'Current ...

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