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,