sql server data warehouse: hi all, i was finally excited when i got to process the whole cube without
the errors.

but now im facing another catastrophe!!

when i try to browse the processed cube, dragged the gross revenue measure
and the hierarchy on the rows, i get repeated values on the measures !

pls check out image below:

Sounds like same problem I just answered another post with:

Sounds like you need to adjust your Dimension Usage tab in SSAS. If you
don't create the correct relationship - you will get funny results - such as
the same value in your counts all the way down as you browse the cube. When
I recently implemented a many to many cube this was a real challenge for
me - but I got it.

Concentrate on one dimension at a time - like just get the Gross Revenue one
working first.

In my many to many cube I use mostly the "Many to Many", and "Regular"
relationship types.

I've yet to come across some good articles on the Dimension Usage tab for
SSAS - so if anyone knows of any blogs, books, or graffiti - I would like to
hear.

[quoted text, click to view]