Hello. I am currently trying to replicate a GROUP BY clause in MDX. Basically we have a Many-To-Many Dimension, with Planograms-Items as our hierarchy. When I say:
{ DESCENDANTS( [Planogram].[PLanogram1], [Planogram].[Items]), DESCENDANTS( [Planogram].[PLanogram2], [Planogram].[Items]) }
I get duplicate items since an item is in both planograms, but of course each row has it own sales, units, etc. The problem is, when I submit larger queries I get 30,000 rows, 3,000 of which are unique Item ID's. I've tried a lot, SUM(), using STRTOMEMBER(), etc...but to no avail.
Basically i'm looking to sum the rows in which the Item ID's are equal, and only get 3,000 rows back from the cube, with all the non description columns summed. ANy ideas Thanks a lot.