Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
String functions in Essbase — Cloud Customer Connect
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

String functions in Essbase

Received Response
20
Views
8
Comments
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!