Setting 'Always Disaggregate to All Valid Combinations' explained

Chris

Written By: Chris - 31 January, 2020

BW version 7.5 provides a new setting "Always disaggregate to all valid combinations". In this post, I'll explain what it's all about.

You will find this setting in the Planning section of BW Modeling Tools. When activated, the disaggregation is always applied to all occurrences of the respective characteristics which are valid according to the characteristic relationships.

Always disaggregate to all valid combinations

This setting enables disaggregation without data, even if the input-ready cells are still empty in the planning process. A typical use case for this is a query in cost center planning, which is aggreagated to one time characteristic.

 


Planning Tools compared - SAP BW IP vs. BPC vs. SAC

Neuer Call-to-Action


 

If you activate this setting, the access type for result values settings for every characteristic is overwritten. This means that all valid combinations (in accordance with characteristic relationships) are created for every disaggregation and then disaggregated on these combinations. This also applies if the query only displays posted data.

Access Type for Result Values setting is overwritten

Therefore, if you use this setting, you should make sure that the number of combinations created remains within manageable limits. Please restrict the filter of the query accordingly.

To illustrate how this setting works, let me use the following example. The sales for company code 1000 are planned in the query. Besides, it is possible to enter the quantity. We've turned on the Disaggregate to all valid combinations setting and specify the amount on the totals row to break them down.

Planning on total

Although initially only company code 1000 is visible, the entered value is broken down to all valid company codes. As shown in the following screenshot.

Disaggregation to all company codes

Learn all about SAP BPC

Photo by Italo Melo from Pexels

Topics: SAP BW/4HANA, SAP Planning

Share article