This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
Respond to this messageReturn to Index
Original Message
  • MDX : substring to member name
    • sroux
      Posted May 24, 2012 11:38 AM


      In Essbase MDX ( is it possible to convert a substring string to a member name?

      this is what I'm trying to do :

      IsUDA([INDICATEURS].CurrentMember, "CONV"),
      [LOC] * ([TX.CHGE.REA],[LOC],[MTD],[pgen],StrToMbr(Substring([MOIS].CurrentMember.Member_Name, 1, 3), [MOIS], MEMBER_NAMEONLY)),

      comment :
      if indicator has CONV uda then multiply LOC member with cross dim (or whatever) else return LOC member

    Login Status
  • You are not logged in
    • Login

      Provides additional benefits such as notifications, signatures, and user authentication.

      Create Account
    Your Name
    Your Email
    Message Title
    Message Text
    Options Also send responses to my email address

    RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.