Hi,
I have a requirement in which the closing balance from previous year 2015.Y of ACC1 and ACC2 should be carried forward to 2016.01.
We pass 2016.01 as parameter in data manager package. I have below code
*SELECT(%YR%,[YEAR],TIME,[ID]=%TIME_SET%)
*XDIM_MEMBERSET TIME AS %VAR% = %YR%.Y
*XDIM_MEMBERSET TIME AS %VAR1% = TMVL(-1,%VAR%)
*XDIM_MEMBERSET TIME = %VAR1%, %TIME_SET%, %YR%.01, %YR%.02
*WHEN TIME
*IS %VAR1%
*WHEN ACC
*IS ACC1, ACC2
*REC(FACTOR =1 ,TIME = %YR%.01, ACC=ACC3)
*COMMIT
*END WHEN
But the above code does not work. it does not pick up value of %VAR1%. Please guide
My time dimension is 2015.01 represents January 2015. and 2015.Y represents dummy node for year 2015 which holds data at year level.
Regards,
Swetha