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
Is this DMR?
Yes. I am using the package in Analysis Studio
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.