aggregation and dis aggregation types 2

[Former Member]

can any one explain mee about aggregation and dis aggregation types

[srinivas_krishnamoorthy · Accepted solution]

Did you seach this forum for Aggregation and Disaggregation?

The help document is as below

Calculation Type for a Key Figure

Specifies whether and how this key figure is aggregated and disaggregated. This setting is valid for all of the planning books in which the key figure is used. You choose from the following options:

S - Pro rata

Pro rata disaggregation works in two ways, depending on whether you are creating or changing the demand plan:

If you create data on an aggregate level, the data is distributed to the lowest level of detail in equal proportions.

If you change data on an aggregate level, the values at the detailed level change so that each one represents the same proportion of the aggregate values as before.

P - Based on another key figure

The data is distributed to the lowest level of detail in the same proportions as those that can be derived from the values of another key figure. For example, you can apply the proportional distribution of the key figure "Baseline/statistical forecast" to the key figure "Manual adjustment". Note, however, that if no values exist for the key figure "Baseline/statistical forecast", no disaggregation takes place.

If you enter 'P', you must also specify on this screen the key figure on which disaggregation is based. Do this in the field Disaggregation key figure.

If you wish the data to be distributed to the lowest level of detail in accordance with the constant proportional factors, select option 'P' and choose the key figure Proportional factor APODPDANT in the field Disaggregation key figure. You generate the constant proportional factors as part of the master data before you start to plan.

Note: This is only possible for time series key figures and key figures from an InfoCube. Both the key figure and the key figure upon which the disaggregation is based must be time series key figures or originate from the same InfoCube.

A - Average of key figures

The average of the key figure values on the next lower aggregation level is displayed at runtime. Use this option for key figures that represent percentages (for example, the percentage difference between this year's and last year's forecast) or sales prices (for example, sales price per unit). If you enter a value on a high level, the system disaggregates it by copying the value to the details on the lowest level.

D- Average at the lowest level of detail

In contrast to calculation type A, the system uses the values at the most detailed level, that is the level for which each characteristic has a single value assigned, to form the average. This can result in different numerical values in comparison to type A.. For more information, see the SAP Library documentation Aggregation and Disaggregation under Creation of the Demand Forecast.

N - No disaggregation

Disaggregation costs performance, so set this option for text rows, auxiliary rows, and other rows that do not need disaggregating.

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

If you create data on an aggregate level, the data is distributed to the lowest level of detail in the same proportions as those that can be derived from the values of another key figure. For example, you can apply the proportional distribution of the key figure "Baseline/statistical forecast" to the key figure "Manual adjustment". Note, however, that if no values exist for the key figure "Baseline/statistical forecast", no disaggregation takes place.

If you enter 'I', you must also specify on this screen the key figure on which disaggregation is based. Do this in the field "Disaggregation key figure".

If you change data on an aggregate level, the values at the detailed level change so that each one represents the same proportion of the aggregate values as before.