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

      Hi,

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

      this is what I'm trying to do :

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

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

      thx
    Login Status
  • You are not logged in
    • Login
      Password
       

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


      Create Account
    Your Name
    Message Title
    Message Text
    Options