cancel
Showing results for 
Search instead for 
Did you mean: 

Allocation Logic doesnt work..

Former Member
0 Kudos

I have a question on Allocation Logic in BPC NW 7.5.

I have the following code. I check the LGX in UJKT and it looks good but it doesnt post any records. I dont know what could the problem be. It valides fine and runs fine too.LGX looks good to me.Just doesnt post records.

*SELECT(%TIMEPROP%,"[YEAR]","CATEGORY","[ID]='FORECAST'")

*SELECT(%TIMEPROP2%,"[YEAR]","CATEGORY","[ID]='BUDGET'")

*SELECT(%MATGRP%,"[ID]","MATERIAL","[PLEVEL]='MATGROUP'")

*XDIM_MEMBERSET RPTCURRENCY=LC

*FOR %MATGROUP% = %MATGRP%

*RUNALLOCATION

*FACTOR =USING

*DIM CATEGORY WHAT=FORECAST; WHERE=TARGET; USING=TARGET;

*DIM CUSTOMER WHAT=[CALC]="N"; WHERE=<<<; USING=NO_CUST;

*DIM DATASRC WHAT=[CALC]="N"; WHERE=INPUT; USING=<<<;

*DIM GP_ACCOUNT WHAT=QTY; WHERE=QTY; USING=ZPCTGROWTH;

*DIM PARTNERFUNC WHAT=[CALC]="N"; WHERE=<<<; USING=NO_PARTNERFUNC;

*DIM MATERIAL WHAT=BAS(%MATGROUP%); WHERE=<<<; USING=INP_%MATGROUP%;

*DIM TIME WHAT=BAS(%TIMEPROP%.TOTAL); WHERE=%TIMEPROP2%.INP; USING=%TIMEPROP2%.INP;

*NEXT

*COMMIT

Thanks,

KK.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

1.Check whether you have data in "WHAT" and "USING" region

2.Run the logic in UJKT, try "EXECUTE" and check the log. (share the log for trouble shooting)

3. Try the logic given below

*SELECT(%TIMEPROP%,"YEAR","CATEGORY","ID='FORECAST'")

*SELECT(%TIMEPROP2%,"YEAR","CATEGORY","ID='BUDGET'")

*SELECT(%MATGRP%,"ID","MATERIAL","PLEVEL='MATGROUP'")

*XDIM_MEMBERSET RPTCURRENCY=LC

*FOR %MATGROUP% = %MATGRP%

*RUNALLOCATION

*FACTOR =USING/TOTAL

*DIM CATEGORY WHAT=FORECAST; WHERE=TARGET; USING=TARGET;TOTAL=<<<

*DIM CUSTOMER WHAT=CALC="N"; WHERE=<<<; USING=NO_CUST;TOTAL=<<<

*DIM DATASRC WHAT=CALC="N"; WHERE=INPUT; USING=<<<;TOTAL=<<<

*DIM GP_ACCOUNT WHAT=QTY; WHERE=QTY; USING=ZPCTGROWTH;TOTAL=<<<

*DIM PARTNERFUNC WHAT=CALC="N"; WHERE=<<<; USING=NO_PARTNERFUNC;TOTAL=<<<

*DIM MATERIAL WHAT=BAS(%MATGROUP%); WHERE=<<<; USING=INP_%MATGROUP%;TOTAL=<<<

*DIM TIME WHAT=BAS(%TIMEPROP%.TOTAL); WHERE=%TIMEPROP2%.INP; USING=%TIMEPROP2%.INP;TOTAL=<<<

*NEXT

*COMMIT

Thanks

Former Member
0 Kudos

Hi Rushendra,

Thanks for the reply.

I made sure there is data at the intersection. And i tried using the total like you said, that didnt work either.

Thanks,

KK