Key Figure Disaggregation:
When the values are set, a time based disaggregation is performed first followed by a structural disaggregation if the values are set in a broader time grid than the one in which these are saved (for example, if data is set monthly, but saved in a weekly/monthly grid).Rounding effects during the time based and structural disaggregation may cause an un expected result.
The system saves the data in technical periods. In a week containing a transition from one month to the next, there are two technical periods. In this way, the system distinguishes between the data belonging to one month and the next.
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 2000 is saved in the following storage buckets:
Example of Storage Buckets
Dates
Days
Storage bucket
June 1-4
Thursday through Sunday
4 days
June 5-11
Monday through Sunday
7 days
June 12-18
Monday through Sunday
7 days
June 19-25
Monday through Sunday
7 days
June 26-30
Monday through Friday
5 days
July 1-2
Saturday and Sunday
2 days
July 3-9
Monday through Sunday
7 days
July 10-16
Monday through Sunday
7 days
July 17-23
Monday through Sunday
7 days
July 24-30
Monday through Sunday
7 days
July 31
Monday
1 day
You choose from the following time-based aggregation types:
P - Proportional distribution
Data is distributed in time so that each key figure value in the smallest storage bucket represents the same proportion of the value in the aggregate bucket as before.
If the key figure values prior to distribution were zero, 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.
E - Equal distribution
Data is distributed equally to each storage bucket.
This option is available only for key figures that were not defined as fixable in the Admin Workbench.
N - No disaggregation in time
The value in the planning bucket is copied to the storage buckets; 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, June 26-30. If you display the planning value for June at run time, the system shows the average value of the storage buckets.
This option is available only for key figures that were not defined as fixable in the Admin Workbench.
K- Based on another key figure
This option is basically the same as calculation type P.
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 'K, you must also specify on this screen the key figure on which disaggregation is based. Do this in the adjacent field "Disaggregation key figure".
We recommend that if you use option 'K' for time-based aggregation, you also use calculation type 'P'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.