You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • String functions in Essbase

    edited Aug 2, 2018 2:36AM in Essbase 8 comments

    Summary

    String functions in Essbase

    Content

    Hi Gurus,

    I have dynamic calculated "year to date" members in Period dimension as YTDJan,YTDFeb,YTDApr etc. and in the FIX I have Jan,Feb,Apr etc.

    The calculation Total New Depreciation" = "New Depreciation" -> "YTDJan" ; works fine but the below one doesn't though validation is successful and there is no error while execution.

    "Total New Depreciation" = "New Depreciation" -> @MEMBER(@NAME(@CONCATENATE("YTD",@NAME(@CURRMBR("Period"))))) ;

    Also if there is any other data already, it wipes out that data. I guess I have written the syntax correct, Please let me know what am I doing wrong here.

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!