Distribution by Reference Data 

Use

You use the Distribution by Reference Data function type to generate combinations of characteristics that correspond to the reference data. The system distributes data in accordance with these combinations. The key figure values are distributed by percentage in accordance with the reference data.

You use the table for key figure selection to select the key figures that you want to distribute.

The system provides two parameters for the Selection of Reference Data.

Parameter	Description
Reference Key Figure (optional)	You determine a key figure that is to be used in the reference data to calculate the distribution key. ●     When you have chosen this key figure, the system distributes all of the key figures to be distributed according to this key, that is, according to this reference key figure. ●     If no reference key figure is selected, the system calculates a key individually for each of the key figures to be distributed. The same key figure is used in the reference data that is distributed.
Reference Values on Any Block Characteristics	You set a reference value for one or more block characteristics. While reading the reference data for each block, the system overwrites the characteristic value of the block in the characteristic with this reference value. An InfoProvider provides data for the years 2005 and 2006. You want to change transaction data for the year 2006. Thus the data from the year 2006 is selected in the filter that is transferred to the planning function. Therefore all the blocks have year 2006. However, if the reference value is 2005, you can ensure that the keys are calculated according to the data from 2005.

The distribution process can be controlled in different ways:

●     Distribution with a top-down variant

○     Distribute All: The entire block is totaled.

○     Only Distribute Not Assigned: Values are only distributed if they have the characteristic value Not Assigned [#]  in the current block for all of the characteristics to be changed.

●     Distribution using manually created entries in the From and To Values for Distribution table.

You can create one or more distribute operations by manually entering the characteristic restrictions for the characteristics that are to be changed.

The system continually totals the values of the key figures on the From side over all the records in the block that correspond to the characteristic restriction, and distributes this total to the To values.

The system distributes data to precisely those characteristic combinations that exist in the reference data and fit the characteristic restrictions in the To values.

The percentage distribution corresponds to the percentage distribution in the reference data.

In top-down distribution, the system distributes to all characteristic combinations that exist in the reference data. Data records are excluded that have the value Not Assigned [#] for all characteristic values.

If there is no reference data for a subprocess, the key figure values for this subprocess are not distributed; the system produces a warning.

The order in which the system executes the distribute function is the same as the order in which the Distribution by Key function is executed. The same rules apply. For more information, see Distribution by Key.