Incorrect Values When drilled down after applying Custom filter

[Naven]

Hi Everyone,

I have a crosstab which contain Bank names in rows and Year data (time dimension) in coulmns, Total Revenue is my measure.

When I apply Custom filter based on the attribute of Bank data, values are displayed fine.

But after using this filter when i drill down on Year data (From 2006 to 2006 Q1) I get same value (i.e 1) in the measure value area for all the banks.

Please help.

Thanks,
Naveen

[CognosPaul]

Is this DMR?

[Naven]

Yes. I am using the package in Analysis Studio

[CognosPaul]

DMR is difficult. The problem has to be in the model, but it may be difficult to pindown.

I would recommend making as simple a crosstab as possible in RS to replicate the problem, then take a look at the SQL it generates. Once you can decipher it, you should be able to identify where the problem is.