"Total" and "GRAND TOTAL" are incorrect

Hi all,

When browsing my cube i get the correct data per enitity, but incorrect data in the "total" and "grand total". what happens acutally is that i'm getting the same value of the "all" member in the totals of all the levels of the hierarchy that i'm slicing the cube with.

For example, if the hierarchy is as follows: A-->B-->C, then i'm getting the below:

A B C

a1

b1 10

b2 20

total 800

Grand total 800

i suspect that it is related to the attribute relationships which i have defined, where the aggregation of the data is being performed on

mmmh ...

yes I'm quite sure there's a problem with your attribute relationships.

Try to check all the relationship in your hierarchy.

|||How are your attributes related? It should be something like C has a relationship to B, and B has a relationship to A.|||

Hi,

Are the attribute-key relationships correct?

or

Do you got some NULL-key-columns in your fact-table !?
the grand total maybe sums up also the Unknown data ?

Kind regards