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_member186338
Active Contributor
0 Kudos

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

Data will be aggregated for BAS(MPL9400). Each script run will overwrite previous aggregated result

But the scope in the script is incorrect!

*XDIM_MEMBERSET ACCOUNT = MPL9400,MPLFE // incorrect!
*XDIM_MEMBERSET ACCOUNT = BAS(MPL9400) //correct
...
*WHEN ACCOUNT 
*IS BAS(MPL9400) //IS BAS() - not required
*IS * //BAS members already scoped

"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." - not clear, what do you mean!

former_member212236
Active Participant
0 Kudos

I am unable to add points under comments hence placed under Answer.