Difference in Crosstab without union and running difference

Hey guys,

I’m looking for a solution in order to display the annual revenue (years = column and revenue = index) for every product (products = row) and the difference of the annual revenue to the previous year (can be column or row) in a crosstab. I would like to avoid generating further queries which I union or using the function running difference. The reason for this is, that I want to use an easy solution in a demo for a customer which can be applied without having a deeper knowledge of Cognos BI Report Studio. If there is no solution, except for the two mentioned, please let me know, that I stopp looking for it.

I’m using a relational database (GO Sales query package from IBM examples) and Cognos 10.1.1.

Thank you very much in advance!

Arne

I’m not a report design expert so maybe others might have a better answer, but try these:
http://www-01.ibm.com/support/docview.wss?uid=swg21342234

http://www-01.ibm.com/support/docview.wss?uid=swg21339373

Thanks for the answer Grim, but I’m looking for a way to do it without these functions…like a drag n’ drop functionality. For instance, with a dimensional model you could drag the years 2010 and 2011 and say generate a new element with the content of 2011 - 2010.

Ah, ok. This can be done in Transformer for sure using Relative Time Categories for “Previous/Prior Peroid” type stuff.
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cogtr.8.4.0.doc/ug_cogtr_id18081RelativeTimeSettings.html

I can only assume that DMR can do the same.

Thanks for your replay. I will try this now.

Hi Gurus, any idea why my RUNNING-DIFFERENCE summary function failed in validation. Attached is the picture for reference. thanks.

Gurus, attached is additional picture. Thanks.