MS SSAS Source MEMBER_KEY, MEMBER_VALUE, MEMBER_NAME

[dbahiker]

Is it possible to get the MEMBER_VALUE in the publish SSAS package like a PowerCube long/short name?
I can see the values are appended to the MS Cude in MDX as MEMBER_VALUE. But how can I get those published in the package?

[bdbits]

Not 100% sure, but you may be looking for rolevalue().

[dbahiker]

Maybe.
When I create the query calculation roleValue('_memberUniqueName',[Cash]). I see the member value from the SSAS Cube at the end of the string. Will work on a function to strip it out.