Essbase

Get Involved. Join the Conversation.

Topic

    JackM
    How to use CONCATENATE Function
    Topic posted October 11, 2019 by JackMRed Ribbon: 250+ Points, tagged Essbase 
    12 Views, 1 Comment
    Title:
    How to use CONCATENATE Function
    Summary:
    How to use CONCATENATE Function
    Content:

    I am trying to push a value of 200 into all my level zero accounts that have a naming convention of Parent name "A12345" plus suffix "X", that is to say A12345X.

     

    FIX(@MEMBER(@CONCATENATE(@NAME(@PARENT(@CURRMBR("Accounts"))),"X")))

    "Final" = 200;

    ENDFIX

     

    The above syntax  does not seem to work. Can any suggest?

     

    Comment