String functions in Essbase
SummaryString functions in Essbase
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.