Disaggregation of Key Figures in DP

53 Views

Hello Experts,

I have the following scenario:

My MPOS contains Product/Location/Customer.

I have two key figures: System Forecast and Sales input.

System forecast is calculated by the system at product/location level and disaggregated to the customer level. Also it is non-editable.

Sales input key figure is editable and he can input anything only on Product/Customer level.

When it disaggregates, it has to disaggregate based on system forecast. If there is no forecast available, it should default to 0 at lower levels.

Example: I have 2 CVCs

PROD1/LOC1/CUST1 and PROD1/LOC2/CUST1.

Let me say that System forcast is 0 on PROD1/LOC1 and PROD/LOC2. So the system forecast at PROD1/LOC1/CUST1 and PROD1/LOC2/CUST1 are 0.

If a sales person keys in 50 at the PROD1/CUST1, then I would like to see the result as PROD1/LOC1/CUST1 = 0 and PROD1/LOC2/CUST1 = 0.

Is this possible? Because the key figure disaggregation method P/I/S does not allow this.

Thanks and Best Regards,
Suresh