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

Pivoting Functionlity in Cognos View (Report Studio Report)

Started by gauravd20, 29 Jan 2009 12:58:35 AM

Previous topic - Next topic

gauravd20

I need pivoting functionality in report studio report in Cognos viewer. Similar functionality is there in Query and Analysis studios but not in Report studio reports.

lebronjames

I hate to tell you this but I don't think thats possible.

Report Studio was meant to be a tool to create static reports that are professional in appearance. Drilling through to another report is usually the biggest user interactivity that you can build.

But please...if you do figure out a way to do this...share it. It would be really cool to have.

Thanks

JGirl

The closest you could get to pivoting functionality is to have some dynamic data items controlled through prompts.

Eg. Have a prompt called ?Rows? with some static choices like 'Product', 'Employee', 'Year' etc, then have a data item called [Rows].  In the data item, derive the value as

CASE ?Rows?
WHEN 'Product' THEN [Sales].[Product].[Product Name]
WHEN 'Year' THEN [Sales].[Time].[Year Name]

Then do the same thing for your columns.

If you want advanced nesting though it might get ugly.