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

      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.