Skip to Content
0
Former Member
Nov 26, 2009 at 08:09 AM

*TEST_WHEN cond. with RunAllocation logic

36 Views

Hi Experts,

I wonder if anyone has any idea whether the *TEST_WHEN condition works with *RunAllocation keyword rule.

I have an allocation logic which takes a considerable amount of time to run and I tried to limit the run-time with a Test_when condition, and it seems to me that this does not work. i.e when the condition fails, it doesn't run and also when the condition passes it still doesn't run the RunAllocation.

Could someone please take the time and help...

Please find my syntax below:

*FOR %TEST_ALL%=MATGRP_01,MATGRP_76,MATGRP_32,MATGRP_59,MATGRP_04,InitiatingSystems,Anfex,MATGRP_96,Services,MATGRP_08,MATGRP_75,MATGRP_63,MATGRP_74,MATGRP_68,MATGRP_39,MATGRP_61,MATGRP_03,MATGRP_82,MATGRP_07,BulkSurface,MATGRP_90,Carricks,MATGRP_56,TradedproductsGroup,MATGRP_43,MATGRP_44,MATGRP_05,MATGRP_67,MATGRP_48,MATGRP_66,MATGRP_21,OtherElectronics,MATGRP_41

*TEST_WHEN(GET(PRODUCT="%TEST_ALL%",CUSTOMERS="NO_CUS",AUDITID="REALLOCATE")=0)

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM SalesValues WHAT=Revenue; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM CUSTOMERS WHAT=NO_CUS; WHERE=>>>; USING=>>>; TOTAL=BAS(AR_AEL_Total)

*DIM CATEGORY WHAT=ACTUAL; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM AUDITID WHAT=REALLOCATE; WHERE=ADJUSTMENT; USING=INPUT; TOTAL=<<<

*DIM PLANT WHAT=PLANT_NA; WHERE=<<<; USING=AllPlants; TOTAL=<<<

*DIM PRODUCT WHAT=%TEST_ALL%; WHERE=>>>; USING=BAS(%TEST_ALL%); TOTAL=<<<

*ENDALLOCATION

*NEXT

*COMMIT

regards