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
    Message Title
    Message Text

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