Monday, March 26, 2012

Grouping in Cube's dataset, Please Help

have a measure called [Person COUNT] and an Attribute called [Injury Class]

Injury Class has four members [Injury A] [Injury B] [Injury c] [Injury d]
I want to get the Person count for each one individually, in seperate
columns. So it would look like this

[Person Count A] [Person Count b] [Person Count C] [Person Count d]
125 254 4 1245
441 11 21 24
454 57 12 42

I want this all in One single Dataset. So that when i put it into a table, i dont get errors about being outside the scope, also everything will be lined
up correctly. Please keep in mind, im new to mdx, i tried some code, but the
stuff i tried didnt work. Is there a way to do this as a calculated member?
how so? Anywa help will be gratelly appriciated. Thanks!You cant do this

No comments:

Post a Comment