You have to use FOR/NEXT:
*FOR %T% =%TIME_SET% *RUNALLOCATION *FACTOR=USING/TOTAL *DIM ACCOUNT WHAT=130000;WHERE=BAS(INVENTORY_FIFO);USING=<<<;TOTAL=<<< *DIM AUDIT_ID WHAT=ENTRY; WHERE=IC_ALLOC_CALC; USING=BAS(TOTALAUDIT);TOTAL=<<< *DIM INTERCO WHAT=I_NONE; WHERE=BAS(I_ALL); USING=<<<;TOTAL=<<< *DIM VERSION WHAT=%VERSION_SET%; WHERE=<<<; USING=ACTUAL;TOTAL=<<< *DIM TIME WHAT=%T%; WHERE=<<<; USING= TMVL(-12,%T%) , ;TOTAL=<<< *ENDALLOCATION *NEXT
For TMVL to work correctly please check TIMEID property in TIME dimension.
First please show screenshot of your TIME dimension. With not calendar fiscal year there are usially a lot of mistakes.
Second: in UJKT execute just 1 line:
*XDIM_MEMBERSET TIME = TMVL(-12,2017.02)
Post the result!
BELOW IS RESULT WHEN I VALIDATE ALLOCATION LOGIC - for time i selected - 2017.01,2017.02.....2017.12 *XDIM_MEMBERSET TIME = %TIME_SET% *XDIM_MEMBERSET VERSION = %VERSION_SET% *RUNALLOCATION *FACTOR=USING/TOTAL *DIM ACCOUNT WHAT=130000;WHERE=BAS(INVENTORY_FIFO);USING=<<<;TOTAL=<<< *DIM AUDIT_ID WHAT=ENTRY; WHERE=IC_ALLOC_CALC; USING=BAS(TOTALAUDIT);TOTAL=<<< *DIM INTERCO WHAT=I_NONE; WHERE=BAS(I_ALL); USING=<<<;TOTAL=<<< *DIM VERSION WHAT=%VERSION_SET%; WHERE=<<<; USING=ACTUAL;TOTAL=<<< *DIM TIME WHAT=%TIME_SET%; WHERE=<<<; USING= 2016.12 , ;TOTAL=<<< *ENDALLOCATION
Add comment