How To Fix RSAU235 - Data inconsistency for key figure & (&) - Unit 1: & (&), unit 2: & (&)

SAP Error Message - Details

• Message type: E = Error

• Message class: RSAU - Update rules

• Message number: 235

• Message text: Data inconsistency for key figure & (&) - Unit 1: & (&), unit 2: & (&)

What causes this issue?

A unit InfoObject is referenced to key figures with a unit. Two
different units are referenced to the key figure entered. Unit 1 was
stored as a reference to the key figure InfoObject. However, in the
communication structure unit 2 is stored as a reference to this key
figure.

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?

You have two possibilities of removing this inconsistency.
Change to the reference unit for the key figure InfoObject in the
Business Information Warehouse.
Change to the reference unit for the key figure InfoObject in the OLTP
system.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSAU235 - Data inconsistency for key figure & (&) - Unit 1: & (&), unit 2: & (&) ?

  The SAP error message RSAU235 indicates a data inconsistency related to key figures in the context of SAP BW (Business Warehouse) or SAP BI (Business Intelligence). This error typically arises when there is a mismatch in the units of measure for key figures that are being processed or aggregated.
  Cause:
  
  Unit Mismatch: The error usually occurs when two key figures that are supposed to be aggregated or compared have different units of measure. For example, one key figure might be in kilograms while another is in pounds.
  Data Load Issues: Inconsistencies can also arise during data loading processes, where data from different sources may not be aligned in terms of units.
  Configuration Errors: Incorrect configuration in the InfoObjects or InfoProviders can lead to this inconsistency.
  Transformation Issues: If there are transformations applied to the data that do not account for unit conversions, this can lead to inconsistencies.
  
  Solution:
  
  Check Key Figure Definitions: Review the definitions of the key figures involved in the error. Ensure that they are defined with the same unit of measure.
  Data Source Validation: Validate the data sources to ensure that the data being loaded is consistent in terms of units. If necessary, apply transformations to convert units to a common standard before loading.
  Transformation Rules: If you are using transformations, ensure that they correctly handle unit conversions. You may need to adjust the transformation logic to ensure consistency.
  Data Cleansing: Perform data cleansing to correct any inconsistencies in the data before it is loaded into the InfoProvider.
  Reprocess Data: After making the necessary adjustments, reprocess the data load to see if the error persists.
  Consult Documentation: Refer to SAP documentation or support for specific guidelines related to the key figures and units involved.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  SAP Community: Engage with the SAP Community forums for insights from other users who may have encountered similar issues.
  BW/BI Documentation: Review the SAP BW/BI documentation for best practices on handling key figures and units of measure.
  
  By addressing the root cause of the inconsistency and ensuring that all key figures are aligned in terms of units, you should be able to resolve the RSAU235 error.