How To Fix DMCLG150 - Split and aggregation are not possible in the same structure

DMCLG150 - Overview

• Message type: E = Error

• Message class: DMCLG - DMC Tool Development

• Message number: 150

• Message text: Split and aggregation are not possible in the same structure

What causes this issue?

Certain restrictions have been determined in DMC development. It does
not make sense to use split and aggregation together, so this is not
permitted.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

DMCLG150 - Details

• The SAP error message DMCLG150, which states "Split and aggregation are not possible in the same structure," typically occurs in the context of data modeling or data processing within SAP BW (Business Warehouse) or SAP HANA environments. This error indicates that there is a conflict in the data processing logic where both splitting and aggregation operations are being attempted on the same data structure, which is not allowed.
  
  Cause:
  
  
  Data Model Configuration: The error often arises when a data model is configured to perform both split and aggregation operations on the same data structure. For example, if you are trying to aggregate data while simultaneously trying to split it into different segments or categories, the system cannot process both actions at the same time.
  
  
  Transformation Logic: In the transformation rules, if you have defined a logic that attempts to aggregate data while also trying to split it into different dimensions or hierarchies, this