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

Grouping attribute member in Dimension

Hi,

I have a Dimension with this structure:

ServiceID

ServiceType

ServiceTypeDesc

These are the sample of their members:

Service ID Service Type ServiceType Desc

1 Walk-In Walk-In

2 Contract Contract

3 HomeService Home Service

4 HomeService2 Home Service

5 Contract2 Contract

6 WalkIn2 Walk-In

7 Contract3 Contract

I assigned the ServiceTypeDesc in Service ID's (this serves as the key column) name column. When I drag it to filter, I could see 7 items, instead of grouping them into 3 (Walk-In, Contract, Home Service).

Is it possible to group them into 3 instead of giving me all the members?

cherriesh

You would want to create at least 2 attributes in your dimension. One based on Service ID which would be the key attribute, which you would use to join to the fact table(s) and another based on ServiceTypeDesc. In your example the ServiceTypeDesc attribute would want to have ServiceTypeDesc used as the key and name.

You get a distinct member in your attribute for each distinct value in the key column.