Essbase discussion board
is provided as a free service and dedicated to all the Essbase professionals out there!
Respond to this message
Return to Index
MDX : substring to member name
Posted May 24, 2012 11:38 AM
In Essbase MDX (220.127.116.11) is it possible to convert a substring string to a member name?
this is what I'm trying to do :
[LOC] * ([TX.CHGE.REA],[LOC],[MTD],[pgen],StrToMbr(Substring([MOIS].CurrentMember.Member_Name, 1, 3), [MOIS], MEMBER_NAMEONLY)),
if indicator has CONV uda then multiply LOC member with cross dim (or whatever) else return LOC member
You are not logged in
Provides additional benefits such as notifications, signatures, and user authentication.