S — Pro rata

Pro rata disaggregation works in two ways, depending on whether you are creating or changing key figure values:

P — Based on another key figure

The key figure values are distributed to the detail level 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", equal distribution occurs.

If you choose the calculation type P, you must also specify in the Disaggregation Key Figure field, which key figure disaggregation is based on.

A — Average of key figures

At runtime, the average of the key figure values on detail level is shown as the result on aggregate level. You use this calculation type 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). When you enter a value on aggregate level, the system disaggregates the value according to pro rata disaggregation.

Aggregation with calculation type A:

E — Average of all details that do not equal zero

The aggregation of this calculation type is basically the same as the aggregation of calculation type A, but in this case does not consider the initial detail values. If you enter a value on aggregate level, the system disaggregates it by copying the value to each detail on detail level.

The following graphic shows aggregation with calculation type E:

D — Average on lowest level of detail

As opposed to calculation type A, the system uses the values on the lowest detail level to calculate the average. This can result in different numerical values in comparison to calculation type A.

Disaggregation of calculation type D is exactly the same as that of calculation type A.

The following graphic shows aggregation with calculation type D:

Since the calculation types A, D, and E, used for averages, are generally used for descriptive purposes, for example, the price per unit, you use them mainly in conjunction with the time-based aggregation type N (see below).

F — Average of lowest detail level not equal to 0; disaggregation pro rata

The aggregation of this calculation type is basically the same as the aggregation of calculation type D, but in this case does not consider the initial detail values.

When you enter a value on aggregate level, the system disaggregates the value according to pro rata disaggregation.

The following graphic shows aggregation with calculation type F:

N — No disaggregation

As disaggregation for this calculation type costs performance, use this calculation type for key figures that do not have to be disaggregated (for example, text rows and help rows).

I — Pro rata; if initial: based on a different key figure

If you create key figure values on aggregate level, the values are distributed on detail level 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". If there is no value for the basis key figure, the values are disaggregated evenly.

If you change key figure values on aggregate level, the values on detail level change so that each one represents the same proportion of the aggregate value as before.

If you choose the calculation type I, you must also specify in the Disaggregation Key Figure field which key figure the disaggregation is to be based on when the value is initial.

Time-Based Disaggregation Types

The time-based disaggregation type defines how planning data is disaggregated in time. The time buckets in which data is saved are given by the storage buckets profile. For example, if you select months and weeks in the storage buckets profile, data for June and July is saved in the following storage buckets:

The available time-based disaggregation types are as follows:

P — Proportional distribution

The key figure values are distributed in the storage buckets in such a way that subsequently each value of a storage bucket shows the same percentage proportion for the time-based aggregated value as before.

If the key figure values prior to distribution were initial, and if a time stream ID forms part of the storage buckets profile definition, the system checks to see if time-based weighting factors exist for this time stream. If so, the data is distributed according to the time-based weighting factors of the time stream. If no factors exist, the data is distributed equally to each storage bucket.

I — Proportional distribution; in the case of initial disaggregation, according to another key figure

This time-based disaggregation type is basically the same as the disaggregation type P. However, if a time bucket does not contain a value, the data is distributed based on another key figure.

If you choose the time-based disaggregation type I, you must also specify in the Disaggregation Key Figure field which key figure disaggregation is based on when a time bucket does not contain a value.

E — Equal distribution

Key figure values are distributed equally to each storage bucket.

This time-based disaggregation type is only available for key figures that you have defined as not fixed.

N — No disaggregation in time

The value in the planning bucket is copied to each storage bucket, for example, a planning value of 100 for the month of June is copied to each of the storage buckets June 1-2, June 5-9, June 12-16, June 19-23, and June 26-30. If you show the planned value for June at runtime, the system outputs the average value of all storage buckets.

This time-based disaggregation type is only available for key figures that have been defined as not fixed.

K — Based on another key figure

The key figure values are distributed in the storage buckets 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" in the corresponding storage bucket to the key figure "Manual adjustment". Note, however, that as with time-based disaggregation type P, if no values exist for the key figure "Baseline/statistical forecast", distribution based on the time-based weighting factor or an equal distribution is used.

If you choose the time-based disaggregation type K, you must also specify in the Disaggregation Key Figure field, which key figure disaggregation is based on.

R - Read: values from last period; write: no allocation

This time-based disaggregation type is intended for time series in Supply Network Planning (SNP).

When you aggregate from shorter storage buckets to larger ones, for instance, from weeks to months, the system takes the value from the last period and copies it to the larger time buckets. In the reverse case, the value is written to all the smaller time buckets.