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
  • Chop characters from end of Member name?
    • Mac5814
      Posted Jan 11, 2012 8:33 AM

      Is there a way to remove the last n characters from a member name? I have two dimensions, A and B, that are essentially mirrors of each other except the B members have 4 extra characters on the end ("_XXX"). In a business rule I want to strip off the last 4 characters from the B member so that I end up with A member name. The problem is that the A members have different number of characters so I don't have a consistent starting point to be able to use the @SUBSTRING function.
    Login Status
  • You are not logged in
    • Login
      Password
       

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


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



    RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.