If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to get column values as rows in a list report

Started by barrysaab, 10 Jan 2012 07:32:39 AM

Previous topic - Next topic

barrysaab

I have two report on a report page summary report and detail report.

Doc have 2 reports, summary and details,,
In summary section country wise,no of issues in different purchase types.

Country Issue id single copy subscription others
Germany Jan-11 15 20 30
Australia Feb-11 20 10 40

I want output like this..

country (Germany,Australia,Newzealand,other),
issue (jan-11,dec-11sep-11,sep-20......etc),
purchase types is one dimension (purchase types are 3like single copy,subscription,others)

in details:

its have 5 dimiensions
order dimension(net sale amount ),
promotion dimension(promotion codes),
Issue( no of issues),
purchase types is one dimension (purchase types are 3like single copy,subscription,others),

And Detail report looks like below:

ex
net sale amt promotion code no of issues single copy sales subscription sales other sales
ZCI ZBI ZS PS CI CS

2000 ABC 30 250 200 300 50 650 550
Please help.Thanks
Boy! Cognos getting on to me!!!