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

Drill on Roll Ups!

Started by Mpotla, 16 Oct 2007 11:52:53 AM

Previous topic - Next topic

Mpotla

Hi ,
I hav a cube contains 13 weeks rollup special category.wen the user selects this category its showing
w1  w2  w3  w4  w5  w6  w7  w8  w9  w10  w11  w12  w13  13week rollup
a     b    c    d    e    f     g    h     j     k      m     n      p     (sum of all the week measures).

when we are drillto the detail report , the report is showing only 'a' number of records. The report is taking values to the parameter ?week? in the report as the value of the first weekin the rollup.

My users requirement is, wen they drill from special category like this(13 weeks rollup). the want to see the all weeks record count in the drill report.

I tried this by changing the filter expression for the prompt to  'in(?week?)' But its not working.

Please advice me ,in solving this issue.

Thanks
Mohan

a027309

More info is needed: what product are you drilling from, what product are you drilling to? Screenshots would be helpful...