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
Report Studio is primarily a report developers tool. Apart from very basic report layouts, you will need the 'deeper' insight pretty quickly. The alternative would be another studio that mainly supports drag and drop..
You can do Prior Period stuff in Transformer at the model level using Relative Time Categories.
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
Thanks for your answers. I already expected that it won't like in Query Studio for instance. I'll try the relative time categories now.