Allocation - TMVL

[Former Member]

TIME = 2017.01.....2017.12

VERSION = PLAN

2017.01 - i want to allocate based on 2016.01

2017.02 - i want to allocate based on 2016.02

In below logic - USING is always 2016.12

is anything incorrect in TMVL?How to make it dynamic?

it shoud be (what period - 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=TMVL(-12,%TIME_SET%);TOTAL=<<<
*ENDALLOCATION

[former_member186338 · Accepted solution]

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

[Former Member]

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

[former_member186338]

What is it for?

[Former Member]

below is what i found in help: "The first period of the TIME_SET is used as the base period for a negative offset and the last period of the TIME_SET is used as the base period for a positive offset."

[former_member186338]

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!

[Former Member]

below is the result:

*XDIM_MEMBERSET TIME = 2016.02

[former_member186338]

Then everything is correct!

[former_member186338]

For TMVL to work correctly please check TIMEID property in TIME dimension.

[Former Member]

i dont see any issues with Timeid.

we use fiscal year from sep - august