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