on 06-08-2011 12:10 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.