Using proportions and maintaining exceptions with?

[Former Member]

We are planning on using proportions generated based on past history to be the basis for disaggregation and aggregation for our key figures. My question is if we have exception to this where for certain periods of time we need to manually maintain proportions where is the best place to maintain this?

For example product A can be produced in plant M or N. For a certain customer ship to US it is made in plant M. But for capacity reasons during the months of July through September we would like the product to be made in plant N. What is the best way to maintain these types of conditional rules? Is it using a combination of proportions and Product/Location Split or do we need to use proportions and some manual maintenance of Macros?

Regards

Jeff

[Former Member · Accepted solution]

Hi Jeff,

Typically, in such situations, you can have a different key figure, where you copy the system generated proportions one time. you can change the diaggregation proportions in this key figure and then base your disaggregation on this new key figure. In every new planning cycle, you can copy the last month factor to the rolled in month

Regards,

Kedar

[Former Member]

The Proportional Factors KF, APODPDANT is usually used as the basis for the disaggregation (but you can choose any other too). Add this to the Planning book and data view you use for adjusting the proportions

you can make this KF as editable and chage the proportions to make the KF dependedent on the proportional factors also change. Please note this will mean redisaggregation if there are already existing proportional factors

what you described in the example sounded more like sourcing rules in SNP rather than DP proportions. This is maintained by Transportation lanes between source and destination locations (plant and DC) and you can change the validity date or use the block indicator to manage this.