[Bug in 10.1] Analysis Studio incorrect sum at root level - DMR model

[siyad]

Hi All,

I have a DMR modelled package and when It has got 3 different dimensions All Accounts, Cash Accounts and PL accounts. These are created from the same dimension table by grouping differently based on a filter on a coulumn. I have applied the filter on the dimensional layer ( Business Layer) for each of these dimensions. Please note that the jon is applied in the Database layer of the FM model

Now I have an issue when I have added these 3 dimensions in Analysis  studio with the time dimension and a measure. Even though the the childs of the top level for these 3 have different numbers , it is displaying same total for all three dimension when I create the attached Analysis studio report. i.e:- if the Dev cost is 100 for the P&L and Development cost is 300 for the Cash accounts, but the Cognos displays 300 as the total in both cases. Anyone knows a fix for this ? or this looks like a limitation of Cognos to differentiate between these 3 dimensions when created from the same source. Any help/suggestions are welcome (I have created different reports in Report studio with these 3 dimensions and the results are fine)

Thanks in advance

[siyad]

Apparently IBM said that this is a bug in 10.1.1 and kindly suggested to upgrade to 10.2

Marked as a Bug in 10.1

Thansk