Skip to Content
0
Former Member
May 23, 2013 at 06:14 PM

Time-Shift PRIOR Problem

21 Views

Hi Guys,

I am in BPC 10 MS and i am trying to copy from previous month to the month selected by the user. I am using PRIOR function, but it is getting the wrong timeid.

*XDIM_MEMBERSET TEMPO = PRIOR(1, %TEMPO_SET%)

....

*REC(EXPRESSION= %VALUE% , TEMPO = NEXT(1,%TEMPO_SET%) )

I ran the package with 2013.JAN but the script is running with timeid 20201100, the expected was 20121200.

-> 2020 is the last year in my time dimension.

I add the property PRIOR, NEXT and CURRENT in time dimension. Follows the record for 2013.JAN

ID TIMEID PRIOR CURRENT NEXT 2013.JAN 20130100 2012.DEC 2013.JAN 2013.FEB

Could you help me in this issue?

Thanks in advance.

Mauro