Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: dbahiker on 10 Oct 2016 12:43:47 PM

Title: MS SSAS Source MEMBER_KEY, MEMBER_VALUE, MEMBER_NAME
Post by: dbahiker on 10 Oct 2016 12:43:47 PM
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?
Title: Re: MS SSAS Source MEMBER_KEY, MEMBER_VALUE, MEMBER_NAME
Post by: bdbits on 10 Oct 2016 04:03:03 PM
Not 100% sure, but you may be looking for rolevalue().
Title: Re: MS SSAS Source MEMBER_KEY, MEMBER_VALUE, MEMBER_NAME
Post by: dbahiker on 11 Oct 2016 08:32:20 AM
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.
Text only | Text with Images