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
More info is needed: what product are you drilling from, what product are you drilling to? Screenshots would be helpful...