Issue with Unknown Member - Measures are 'off'

I have a problem with a cube where the some of the measures seems to be ‘off’ when compared against the underlying table. Digging into that I noticed that the measures do not reflect the amounts/numbers tie to the unknown member in of my dimensions (date dimension specifically).

e.g. at the leaf level it looks something like:

01/01/2007 100

02/01/2007 100

Unknown 50

Grand Total 200

If I browsed it at a higher level, let’s say month, then it looks like:

Jan 2007 200

Unknown (yes, empty)

Grand Total 200

The odd thing is that my date dimension is playing 3 roles, and this only happens in 2 of the roles.

I am expecting lot of rows to be tie to the unknown member as the source has referential integrity issues.

Any advice is appreciated

Have you checked your attribute relationships? Incorrectly set attribute relationships can cause this kind of problem.

Chris

|||

Christopher Webb wrote:

Have you checked your attribute relationships? Incorrectly set attribute relationships can cause this kind of problem.

Chris

Thanks Chris for your reply. I will be double cheking that; but I still don't understand why this happens only with 2 of the 3 roles that dimension is playing. Are not the attribute relationships defined in the underlying dimension only? Should not all the roles behave the same?|||

Yes, all the role-playing dimensions should behave the same - but sometimes the behaviour is quite hard to spot, so it could be that all three are producing incorrect values but it's only obvious on two of them.

Chris