How To Fix R7B634 - Key figure &1: (Exception) aggreg. 'Total' not allowed for data type &2

SAP Error Message - Details

• Message type: E = Error

• Message class: R7B - BW Metadata (InfoCube, InfoObject, InfoObject catalog)

• Message number: 634

• Message text: Key figure &1: (Exception) aggreg. 'Total' not allowed for data type &2

What causes this issue?

The (exception) aggregation sum is not permitted for key figures of type
date or time if their data type is DATS or TIMS. They can not be used if
a DataStore object for delta calculation is used, for example.

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?

Use the data type DEC or change the (exception) aggregation to a value
that is not equal to 'Sum'.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message R7B634 - Key figure &1: (Exception) aggreg. 'Total' not allowed for data type &2 ?

  The SAP error message R7B634 indicates that there is an issue with the aggregation of a key figure in a report or query. Specifically, it states that the aggregation type 'Total' is not allowed for the specified data type of the key figure. This typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when working with queries or data models.
  Cause:
  
  Data Type Mismatch: The key figure you are trying to aggregate with the 'Total' function is of a data type that does not support this type of aggregation. For example, if the key figure is a text or a non-numeric type, it cannot be aggregated as a total.
  Aggregation Settings: The settings for the key figure in the InfoObject or the query definition may not allow for total aggregation due to the nature of the data.
  Incorrect Query Design: The query might be designed in a way that conflicts with the data model or the characteristics of the key figures involved.
  
  Solution:
  
  Check Data Type: Verify the data type of the key figure in the InfoObject definition. Ensure that it is a numeric type (e.g., Integer, Decimal) that can be aggregated.
  Modify Aggregation Settings: If the key figure is correctly defined but still causing issues, check the aggregation settings in the query designer. You may need to change the aggregation type to one that is compatible with the data type.
  Review Query Design: Look at the overall design of the query. Ensure that the key figure is being used in a context that allows for total aggregation. If necessary, redesign the query to avoid using 'Total' for incompatible key figures.
  Consult Documentation: Refer to SAP documentation or help resources for specific guidelines on key figure aggregation and data types.
  
  Related Information:
  
  SAP BW Documentation: Check the official SAP BW documentation for details on key figures, data types, and aggregation methods.
  SAP Community: Engage with the SAP Community forums to see if others have encountered similar issues and what solutions they found effective.
  SAP Notes: Search for relevant SAP Notes that might address this specific error or provide additional troubleshooting steps.
  
  By following these steps, you should be able to identify the root cause of the error and implement a solution to resolve it.