I'm pretty new at Mdx , so bare with me. I want to make a calculated member called Occupant Fatalities.
The occupant fatalities looks like this right now:
( [Measures].[Fatalities] , [Crash Person].[Person Type].&[Driver])
Now the question is , How do i add another person type to this calculated member. It wont work when i do this.
( [Measures].[Fatalities] , [Crash Person].[Person Type].&[Driver].&[Passenger])
whats the code for having more then one member from a hierachy? or having 2 members from different hierarchies?
any help is appreciated.
Well, one of my co-workers helped with this one. It was right there, and i didnt even know.
I guess you have to put each individual attribute with the measure. Looks like this.
([Crash Person].[Person Type].&[Driver], [Measures].[Fatalities])
+ ([Crash Person].[Person Type].&[Passenger],[Measures].[Fatalities] )
No comments:
Post a Comment