Skip to Content
0
Former Member
Jul 27, 2016 at 09:10 AM

How to get 2015.y from 2016.01 in script logic

22 Views

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