Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Allocation engine uses wrong entries for WHERE area

Hi there!

I am using the BPC allocation engine in SAP BPC Version 5.0.502 SP 3, Patch 4 (I'm not sure whether the last patch qualifies as a service pack).

I use the following script:

*RUNALLOCATION

FACTOR=(USING/100)(-1)

*NAME=cat_alloc_usm_j59

*APP WHAT=FINANCE; WHERE=FINANCE; USING=ALLOC

*DIM ACCOUNT WHAT=BAS(TotProdSales); WHERE=BAS(TotProdSales);USING=ACCOUNT.INP

*DIM LABEL WHAT=LABEL.INP; WHERE=LABEL.INP; USING=L_01

*DIM CARRIER WHAT=BAS(ALL_CARRIER); WHERE=BAS(ALL_CARRIER); USING=CARRIER.INP

*DIM PRICE_LEVEL WHAT=BAS(ALL_PRICE_LEVEL); WHERE=BAS(ALL_PRICE_LEVEL); USING=PRICE_LEVEL.INP

*DIM ALLOCATION USING=ALLO_CATALOGUE_01

*ENDALLOCATION

The result is okay except for the entry in the dimension PRICE_LEVEL (which I see in the FACTWB table). It says there: LABEL.INP. Such a price level does not exist. The engine just uses the entry for label.

Another script produces a corresponding error:

*RUNALLOCATION

FACTOR=(USING/100)(-1)

*NAME=cat_alloc_usm_j59

*APP WHAT=FINANCE; WHERE=FINANCE; USING=ALLOC

*DIM ENTITY WHAT=J_59.USM.INP; WHERE=J_59.INP; USING=S_FK

*DIM ACCOUNT WHAT=BAS(TotProdSales); WHERE=BAS(TotProdSales);USING=ACCOUNT.INP

*DIM LABEL WHAT=LABEL.INP; WHERE=LABEL.INP; USING=L_01

*DIM CARRIER WHAT=BAS(ALL_CARRIER); WHERE=BAS(ALL_CARRIER); USING=CARRIER.INP

*DIM PRICE_LEVEL WHAT=BAS(ALL_PRICE_LEVEL); WHERE=BAS(ALL_PRICE_LEVEL); USING=PRICE_LEVEL.INP

*DIM ALLOCATION USING=ALLO_CATALOGUE_01

*ENDALLOCATION

In this case, it writes into the dimension LABEL "J_59.INP" which is an entity, not a label. Again, the engine just uses the entry from another dimension.

I appreciate any ideas and hints where I could have gone wrong with my scripts. I would consider using the tables clcAlloc and clcAllocH, but the system will later be maintained by an administrator who has no access to the server but will have to make changes to the allocations. Thus the allocations must run via the written logic.

Thanks a lot,

Hartmut

Edited by: Hartmut Kesper on Sep 11, 2008 10:04 AM

Edited by: Hartmut Kesper on Sep 11, 2008 3:02 PM

Edited by: Hartmut Kesper on Sep 11, 2008 3:03 PM

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question