Entering content frame

Function documentation Generation of Proportional Factors Locate the document in its SAP Library structure

Use

Proportional factors are one of the ways you can disaggregate data from an aggregate level to a detailed one. They are used in two calculation types:

·        P - Based on another key figure

·        I - Pro rata, except for the initial disaggregation, which is based on another key figure.

In both cases, you must enter APODPDANT as the disaggregation key figure in planning area maintenance. 

With this function, you can derive the proportional factors from historical data or, occasionally, from past planning data.

Integration

The calculation type that you set for each key figure in Customizing when you create a planning area determines how disaggregation is performed.

For more information, see the input help for these fields or Structure linkAggregation and Disaggregation.

Prerequisites

...

·        You have created characteristic value combinations for the master planning object structure. See also Generating Master Data for DP.

·        The source of the proportional factors (planning area or InfoCube) should exist and contain the same characteristics and characteristic value combinations as the target planning area.

·        There should be data for at least some characteristic value combinations in the source.

Features

You have the following options for generating proportional factors:

Calculate fixed proportions in entire horizon

In this case, the resulting proportional factors for a characteristic values combination are the same for all time buckets within the specified horizon.

This is how the system calculates the proportional factors:

       1.      For each characteristic values combination, the system sums the key figure values of all periods in the specified horizon. The result of this step is a key figure value aggregated over time for each characteristic values combination.

       2.      The system sums the key figure values for all the characteristic values combinations in the entire horizon.

       3.      The system divides the key figure value of each characteristic values combination by the total calculated in step (2), thus obtaining the proportional factors.

Result: The same proportional factors are derived for all the periods in the horizon that was specified in the Create proportions in horizon field. The system stores the proportional factors internally. You can display them in the special data view for the proportional factors (see Manual Modification of the Proportional Factors). Alternatively, for small selections, you can view the log.

The log is only available in the following cases:

·        The basis for the calculation is an InfoCube or a different planning area to the planning area for which the factors are to be calculated.

·        The basis for the calculation is the same planning area as that to which the factors are to be written. The system is to calculate fixed factors. You do not use a parallel processing profile.

Calculate detailed proportions for all periods

In this case, the resulting proportional factors for a characteristic values combination are time-dependent. The system calculates them for each time bucket within the horizon.

This is how the system calculates the proportional factors:

...

       1.      In each time bucket, the system sums the key figure values of all the characteristic values combinations. The time bucket has been specified by the user.

       2.      In each time bucket, the system divides the key figure value of each characteristic values combination by the total obtained in step (1), thus obtaining a proportional factor for each time bucket.

Result: Different proportional factors are derived for each time bucket in the horizon specified under Create proportions in horizon. The system stores the proportional factors internally. You can display them in the special data view for the proportional factors (see Manual Modification of the Proportional Factors). The special feature of this function is that it allows you to obtain period-dependent proportions within one time horizon.

In both cases, the system normalizes the factors before saving them in the key figure so that the total for all characteristics values combinations in the smallest period specified in the storage buckets profile for the planning area is 1. This result is then multiplied by 10000 to avoid rounding problems with small factors, since liveCache only saves three decimal places. You can change this parameter if necessary. To do so, use SAP Note 425741.

If you still want to change the calculated proportional factors before the data is stored in liveCache, use the Business Add-In (BAdI)/SAPAPO/ SDP_CALC_PRP.

Overwriting Data when Calculating Detailed Proportional Factors

If the basic key figure contains data, the system overwrites the available proportional factors with the new factors that it has calculated for the characteristic values combinations. If the basic key figure does not contain any data, the system overwrites the available proportional factors with zero. However, the system does not overwrite available proportional factors with zero if the following conditions are fulfilled:

·        The basic key figure does not contain any data

·        Source and target planning area for the calculation are identical

·        You have set the Ignore Zero Values indicator on the Other Settings tab page.

If you want to make sure that no incorrect values exist before the calculation of the proportional factors, first perform a job with a macro that sets all values of the key figure APODPANT to zero before proportional factors are generated.

More Functions in the Calculation of Detailed Proportions

...

·        You can restrict the range of the characteristic values combinations for which the proportional factors are generated by entering an existing selection on the Other Settings tab page.

Note

Using this option can lead to unexpected results. For instance, if a characteristic values combination is contained in two or more selections and proportional factors are generated for all these selections, the factor for characteristic values combination is calculated several times. Since the basis is different, a new factor results each time.

·        When working in one planning area, you can use parallel processing to improve performance. You enter a parallel processing profile on the Other Settings tab page. For more information, see Structure linkParallel Processing of Background Jobs.

Activities

Calculating Fixed Proportions in the Entire Horizon

·        You make entries in all the fields under Basis for proportion calculation.

The source key figure does not have to be in the target planning area for it to be used for the proportional factor calculation.

·        You enter the version into which the results are to be written under Calc. proportions for. 

·        You enter a From date and a To date under Create proportions in horizon.

·        You select Fixed proportions under Proportion calc. type.

·        You can make additional settings on the Other Settings tab page. Possible entries are:

¡        A selection

¡        A parallel processing profile

¡        The indicator for the log

For more information, see the input help.

·        You execute the report either online or as a background job.

Calculating time-dependent detailed proportions

·        Under Basis for proportion calculation, you make entries in the Planning version, Key figure and From date fields.

The system calculates the To date internally by determining the number of periods from the other entries and adding this horizon to the From date.

·        You enter the version into which the results are to be written under Calc. proportions for. 

·        You enter either a From date and a To date, or a From date and a No. of periods, under Create proportions in horizon.

·        You select Detailed proportions and the Periodicity under Proportion calc. type.

·        You can make additional settings on the Other Settings tab page. Possible entries are:

¡        A selection

¡        A parallel processing profile

For more information, see the input help.

·        You execute the report either online or as a background job.

Result

The results of this calculation are stored in the Proportional factor APODPDANT key figure. In this documentation, they are called the constant proportional factors. The key figure APODPDANT is automatically added to your planning area when you create the planning area. You do not have to add this key figure yourself.

To find out how to modify the results manually, see Manual Modification of the Proportional Factors.

Example

Example of proportional calculation: The results are displayed in blue

This graphic is explained in the accompanying text

 

 

Leaving content frame