Disaggregation (Top-Down Distribution)

Disaggregation (also called top-down distribution) helps you to enter data manually in manual planning. It allows you to make manual entries in input-ready queries, also when using aggregated values related to an aggregation level.

Input ready queries are always defined in relation to aggregation levels. Without disaggregation functionality, the following applies: a cell is only input-ready if every characteristic value of all the characteristic values contained in the aggregation level is determined uniquely. This means that cells, which contain aggregated values related to the aggregation level, are not input-ready. This includes totals, subtotals and internal hierarchy nodes.

Disaggregation also allows you to changes values that are aggregated in terms of the aggregation level. To do this, the changed values must be distributed top-down to all data records that contribute to the aggregated values of the cell. We call this top-down distribution disaggregation.

Caution

Please note that disaggregation does not invalidate the current planning modeling: new data records and delta data records are always created based on the aggregation level. Disaggregation only helps with manual data input in input-ready queries.

Disaggregation in input-ready queries can have an effect on the application modeling of the BW planning, especially in the area of characteristic relationships.

Before a changed value of a query cell can be disaggregated, the system must first determine all data records that contribute to the cell value. In order to read this data, the system adds all the characteristics of the involved aggregation levels to the drilldown (in addition to the characteristics already contained in the rows or columns). If there are no such data records available - for example, in an empty row - and the query only uses posted data records, disaggregation cannot be performed. If you want to use disaggregation in the query, you must ensure that data for disaggregation is available or can be generated via the query settings for disaggregation. You can do this, for example, by using the settings for creating combinations in the query (specific to the access type for result values Access Type for Result Values). Please note that the filter of the query is restricted so that the number of generated combinations remains within in an appropriate range.

Note

The disaggregation concept in input-ready queries is not designed for mass data. If you want to process mass data via disaggregation in the query, we recommend that you use the top-down planning function type.

Disaggregation is only available for basic key figures with aggregation type SUM or NO2, but not for calculated key figures, key figures with exception aggregation, local aggregations and time key figures. In the query definition, it is possible to model and parameterize the disaggregation behavior of a specific structure element:

Table 1: Modeling Functionalities for Disaggregation
Option	Basic Key Figures with Aggregation Type SUM	Basic Key Figures with Aggregation Type NO2
No Disaggregation: No disaggregation	x	x
Disaggregate Entered Value: Disaggregate entered value	x	-
Disaggregate Difference to Entered Value: Disaggregate difference	x	-
Disaggregate Copy: Copy the entered value	-	x

Table 2: Type of Distribution
Option	Basic Key Figures with Aggregation Type SUM	Basic Key Figures with Aggregation Type NO2
Equally: Equal distribution	x	-
Same as in reference object (self reference): Analogous distribution (to self)	x	-
Same as in reference object: Analogous distribution (a different structural element)	x	-