Hi,

When I use only 2 dimensions linked with my fact and process the cube I
get the correct results for my measure (I have checked this will all
possible combinations of the 2 dimensions)....


However when I add more dimensions, link them with the fact, process the
cube, and check the same results I get totally different totals for my
measure???

I realize that ideally I should post the DDLs for all dimensions etc.
but to start with can anyone think of what could be causing this.

I'll appreciate your help.

Thanks.
P.S
Exhausted

I don't know the exact data structure you are using. One
of the scenarios when problem occurs when one of the
dimensions has more than one level and the data is for
the higher level but not for the lower level. You will
find that the data is not correct. This situation can be
fixed by a combination of choosing correct properties
when you create the dimensions and/or creating correct
rollups.

If this is not the scenario in your case, post some more
details and I might be able to help.

Abhinav Kumar
akumar (AT) itmag (DOT) com.au

Abhinav,

Thanks for the reply. Took me a while but with help from so many I was
able to solve the problem; in summary the problem was due to the
underlying joins that I was using.

Regards.