How To Fix R7719 - &1: Non-cumulatives and key figures with aggregation <> SUM not allowed

R7719 - Overview

• Message type: E = Error

• Message class: R7 - BW: Data basis

• Message number: 719

• Message text: &1: Non-cumulatives and key figures with aggregation <> SUM not allowed

What causes this issue?

The given key figure is a non-cumulative key figure or has an
aggregation <(><<)>> SUM.
This type of key figure is not allowed for InfoCubes that belong to a
HybridProvider or to a semantically partitioned object.

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?

Remove the key figure from the InfoCube.
Note: You may include the key figure exclusively in the DataStore object
of the HybridProvider.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

R7719 - Details

• The SAP error message R7719 indicates that there is an issue with the use of non-cumulative key figures in a query or report where the aggregation method is not set to SUM. This typically occurs in SAP BW (Business Warehouse) or SAP HANA environments when you are trying to aggregate data in a way that is not compatible with the characteristics of the key figures involved.
  
  Cause:
  
  Non-Cumulative Key Figures: Non-cumulative key figures are those that do not accumulate over time, such as stock levels or balances. They are typically used for reporting on snapshots rather than totals over a period.
  Aggregation Method: The error arises when you attempt to aggregate non-cumulative key figures using an aggregation method other than SUM (e.g., AVERAGE, MAX, MIN). Since non-cumulative key figures do not support these types of aggregations, the system throws this error.
  
  
  Solution:
  To resolve the error, you can take the following steps:
  
  
  Check Key Figure Settings: