Entering content frame

Procedure documentation Copying Pro Rata Disaggregation Factors to Future Time Buckets Locate the document in its SAP Library structure

Use

Use this procedure to copy disaggregation factors expressed as percentages to future time buckets. You can copy the data for a key figure.

You cannot use this procedure to copy data from one key figure to another. To do this, use a macro.

Prerequisites

The key figure concerned must be fixable.

Procedure

  1. Select the data of the aggregated level
  2. Drill down to the level you want to redistribute to
  3. Switch to the percentage view by choosing This graphic is explained in the accompanying text.
  4. Select the cells that contain the proportions to copy and choose This graphic is explained in the accompanying text.
  5. Select the cells into which the new proportions should be copied and choose This graphic is explained in the accompanying text.
  6. Return to the absolute view by choosing This graphic is explained in the accompanying text again.

 

Result

The proportions are copied. When you enter data at the higher level,it is disaggregated according to these proportions.

Note

If you enter data that cannot be divided in these proportions, the system disaggregates the data so that whole numbers result. The prportions in these cells are then changed correspondingly. For example the unit is Pieces and a product is to be disaggregated between three locations in the proportions 25%, 25%, and 50%. At the higher level you enter 26 pieces. The system disaggregates to 7, 6,and 13 pieces and changes the proportions to 26.92%, 23.08%, and 50%. You can influence this disaggregation by fixing individual cells in the percentage view.

 

Leaving content frame