Congnos Cube Based Report DMR; Request for logic

[Ravisha]

Hello Cognoise,

We are on Cognos 10.1.1 and the request below is in regards to Cube (DMR) based reporting.



Product A
               
                             JAN     FEB     MAR   ....  JUN   ....  DEC
Actuals                    70
Projected                 60
Budget                    50
Total Variance       20


So, per the requirement,  up until the previous month (Jan through May), the calculation of the total variance must be [actuals - budget] and for the current month through the future months ( in this case Jun through December) the calculation must be [projected - budget].

The above mockup is plotted on a cross-tab container. I'd appreciate it if anyone could please assist to achieve the logic mentioned above in the data item "Total Variance"?



Thanks in advance

[New_Guy]

Hi,

I dont think it is possible to switch the scenarios or Data Items that are in rows based on a Time period condition. Using 2 crosstabs is the way to go. And what is the output format for this report. Please let me know if I am wrong and if it can be done in one crosstab.

Good luck
New guy

[bdbits]

Maybe I misunderstand, but could you not create a data item as an expression using IF or CASE that based on the time, creates the appropriate calculations?

[Ravisha]

Since the report is based on a cube package (DMR), I'm not sure how if.. then...else construct would work?  :-\