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