cancel
Showing results for 
Search instead for 
Did you mean: 

Allocation of data from one to many profit centers

former_member212236
Active Participant
0 Kudos

Hello All,

Could you please provide some insights on the below issue.

BPC Version - 10.1

BPC Cons Model - MGMT IFRS

Requirement:

To Allocate Fixed expenses account (MPLFE) from one common Profit Center (Z1999) to several other individual profit centers. The percentage allocation need to be calculated based on the Net Sales account (MPL9400) value of the individual profit centers and their totals.

Formula:

Allocation = Net Sales value of a individual Profit Center / TOTAL (Net Sales) of all Profit Centers * Fixed Expense of Common Profit Center

Code:

*XDIM_MEMBERSET ACCOUNT = MPL9400,MPLFE

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET CATEGORY = %CATEGORY%

*XDIM_MEMBERSET PROFITCENTER = BAS(SALONTOT_REGION)

//ZALLOC is dummy dimension member create to hold the total value of Net Sales

*WHEN ACCOUNT

*IS BAS(MPL9400)

*REC(FACTOR = 1, ACCOUNT = ZALLOC)

*ENDWHEN

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM ACCOUNT WHAT = BAS(MPLFE); WHERE = <<<; USING = ZALLOC; TOTAL = <<<

*DIM PROFITCENTER WHAT = Z1999; WHERE = BAS(SALONTOT_REGION); USING = <<<; TOTAL = <<<

*ENDALLOCATION

//Clear the value stored in ZALLOC to avoid data duplication

*WHEN ACCOUNT

*IS ZALLOC

*REC(FACTOR=0)

*ENDWHEN

Questions:

1. How will the data reside into ZALLOC? Will it get Overwritten or Aggregated?

2. How to avoid the probable error as we have different number of members in USING as in WHERE: which might not let the system with information on where to allocate.

Referred Links:

https://help.sap.com/viewer/a2049170bfeb4178ace32222842c3ec1/10.1/en-US/59f145f708724b9c86d8a65dd57d...

https://answers.sap.com/questions/8768336/allocation-from-a-parent-account.html

Regards,

Vinoth

former_member186338
Active Contributor
0 Kudos

Data samples not provided!

former_member212236
Active Participant
0 Kudos

Hello Vadim,

Here is the sample.

View Entire Topic
former_member212236
Active Participant
0 Kudos

Hello Vadim,

Thank You for your response.

I had tried the corrections and the logic is working fine and populates the values in ZALLOC.

I want to allocate the values of BAS(MPLFE) from Z1999 profit center to the other profit centers under SALONTOT_REGION but only for the accounts with values.

This is not happening. Instead, the value is being allocated to all the base level members of MPLFE using the Total value of MPLFE in Z1999 Profit Center.

I have tried to use FOR and WHEN statements but ended with no luck.

Could you please suggest.

Below are the screen captures.

Code:

*XDIM_MEMBERSET ACCOUNT = BAS(MPL9400)

*XDIM_MEMBERSET TIME = 2012.P01

*XDIM_MEMBERSET CATEGORY = BUDGET

*XDIM_MEMBERSET PROFITCENTER = BAS(SALONTOT_REGION)

*WHEN ACCOUNT

*IS *

*REC(FACTOR = 1, ACCOUNT = ZALLOC)

*ENDWHEN

*XDIM_MEMBERSET ACCOUNT = BAS(MPLFE)

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM ACCOUNT WHAT = BAS(MPLFE); WHERE = <<<; USING = ZALLOC; TOTAL = <<<

*DIM PROFITCENTER WHAT = Z1999; WHERE = BAS(SALONTOT_REGION); USING = <<<; TOTAL = <<<

*ENDALLOCATION