How to use concatenate in member formula with @currmbr
Hi
Cube is as follows:
Period - Jan-Dec
Year - 2013-2020
Status - Jan-13, Jan-14,....Nov-20,Dec-20
I'm trying to create a member formula in scenario dimension. We expect that it will derive status from current period and year members.
Example - When period is Jun, Year is 2015, then status should be Jun-15
@PRIOR("Forecast", 1, "Jan-13":@member(@CONCATENATE(@Name(@Currmbr("Period")),@SUBSTRING(@Name(@Currmbr("Year")),3))));
This formula validates successfully but we get the following error while trying to retrieve data
'Error executing formula for [FC 1 Month Out] (line 1): invalid argument in function [@TO]'
When formula is replaced as @PRIOR("Forecast"
1