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

Passing Crosstab Column Data Item in Drill through from Rows

Started by eliza_jane, 04 Nov 2011 01:26:30 PM

Previous topic - Next topic

eliza_jane

Is there a way to pass the Crosstab Column data item from the Rows node member?

We have a cube based report that displays say Year on the columns, Product on the Rows and a Sales measure value. We would like to drill through to another report from both the measures and the rows. On clicking a row the drill through report needs to display Product, the years from the parent report and other measures.

The report also has drills enabled, so when users drill up to quarters and then click on a product row member the drill through report should bring up the product, all quarters displayed on the parent report.

Setting the Year data item as a Property on Crosstab row node member didn't help.

Any suggestions?