Question Allocation Cost Center between other Cost Center

[former_member182305]

Hi Experts,

I am on BPC 10.1 BW 7.5.

I have the next dimensions in my model:

COST CEENTER, CUSTOMER, ACCT, COMPANY CODE, DATA SOURCE, PRODUCTS, TIME AND VERSION.

Each Cost Center Represents an Area but there is Central Areas that prorate his cost between other areas. The Areas that prorate their cost have property V_ACCT whitthe specific account to prorate. Only that account needs to be prorated for each Cost Center.

I am facing an issue when running the allocation: I do a *for, for each Cost Center, but I don´t find a way to target the specific combination of Cost Center and account contained in the Cost Center property V_ACCT.

The cost is with no Cust level and not prod level and needs to be prorated at that level, that is why I am trying to use an allocation.

I have the next Script. But as I said, I can't achieve a way to scope the specific combination of Cost Center and account.

*SELECT (%CCS%, ID, CECO, V_ACCT<>' ' AND ID<>'NA_CC)

*XDIM_MEMBERSET COST_CENTER= %CECOS%
*XDIM_MEMBERSET CUSTOMER= NA_CUST
//*XDIM_MEMBERSET ACCT= BAS(V_ACCT)
//*XDIM_MEMBERSET COMPANY_CODE= A
*XDIM_MEMBERSET DATA SOURCE= REAL_AJ
*XDIM_MEMBERSET PRODUCT= NA_PROD
*XDIM_MEMBERSET TIME= 2019.02
*XDIM_MEMBERSET VERSION= REAL

*FOR %CC%= %CC%

 *RUNALLOCATION
 *FACTOR= USING/TOTAL

 *DIM CECO               WHAT= %CC%;               WHERE= <<<;                        USING=<<<;                  TOTAL=<<<;
 *DIM CUSTOMER           WHAT= NA_CUST;            WHERE= BAS(TOT_CUST);              USING=<<<;                  TOTAL=NA_CUST;
 //*DIM ACCT             WHAT= %ACCT%;             WHERE= AMOUNT;                     USING=<<<;                  TOTAL= CUENTA;
 *DIM DATA_SOURCE        WHAT= REAL_AJ;            WHERE= REAL_AJ;                    USING= HISTORIC_UPLOAD;     TOTAL= HISTORIC_UPLOAD;        
 *DIM PRODUCTS           WHAT= NA_PROD;            WHERE= BAS(TOTAL_PROD);            USING=<<<;                  TOTAL=NA_PROD;
 *DIM TIME               WHAT= 2019.02;            WHERE= <<<;                        USING= 2019.02;             TOTAL=2019.02;
 *DIM VERSION            WHAT= REAL;               WHERE= <<<;                        USING=<<<;                  TOTAL=<<<;


 *ENDALLOCATION
*NEXT

Do you think is possible or I will have to use a *when?

Thanks in advance for your comments.

best Regards.

[former_member186338 · Accepted solution]

Try:

*SELECT (%CCS%, ID, CECO, V_ACCT<>'' AND ID<>NA_CC)
*SELECT (%ACS%, V_ACCT, CECO, V_ACCT<>'' AND ID<>NA_CC)
...
*FOR %CC%=%CCS% AND %AC%=%ACS%
...

[former_member182305 · Accepted solution]

Thank you very much Vadim, It totally worked!!!

Thanks.

Regards.