How To Fix RSDD812 - Aggregate &1: Char./nav. attribute &2 has an incorrect aggregation status

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 812

• Message text: Aggregate &1: Char./nav. attribute &2 has an incorrect aggregation status

What causes this issue?

Problems with activation, transport and content transfer may mean that
characteristics and navigation attributes appear in the modified version
of an aggregate definition (M version) that should not be there. For
example, characteristics from the units and package dimension
(RequestID, ChangeID, ...) and navigation attributes with aggregation
status "%" - these are not automatically included until the aggregate is
activated. They ought to then appear in the A version of the aggregate
(that is, the active version). In aggregate maintenance (transaction
RSDDV), only the M version for an aggregate is displayed.

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

System Response

How to fix this error?

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 RSDD812 - Aggregate &1: Char./nav. attribute &2 has an incorrect aggregation status ?

  The SAP error message RSDD812 indicates that there is an issue with the aggregation status of a characteristic or navigation attribute in an aggregate. This error typically arises in the context of SAP BW (Business Warehouse) when working with aggregates in InfoCubes.
  Cause:
  The error message RSDD812 is triggered when:
  
  Incorrect Aggregation Status: The characteristic or navigation attribute specified in the error message has an aggregation status that is not compatible with the aggregate definition. This can happen if the characteristic is defined in a way that does not allow for proper aggregation (e.g., if it is a non-aggregatable field).
  Changes in Data Model: If there have been recent changes to the data model, such as changes to the InfoObject or the aggregate definition, it may lead to inconsistencies.
  Missing or Incorrect Settings: The characteristic may not be set up correctly in the InfoObject settings, or it may be missing from the aggregate definition.
  
  Solution:
  To resolve the RSDD812 error, you can follow these steps:
  
  
  Check Aggregation Status:
  
  Go to the InfoObject maintenance for the characteristic or navigation attribute mentioned in the error message.
  Verify the aggregation status of the characteristic. It should be set to a valid aggregation type (e.g., "Sum", "Count", etc.) that is compatible with the aggregate.
  
  
  
  Review Aggregate Definition:
  
  Open the aggregate definition in the SAP BW system.
  Ensure that the characteristic or navigation attribute is included in the aggregate and that its aggregation status is correctly defined.
  
  
  
  Rebuild the Aggregate:
  
  If the issue persists, consider rebuilding the aggregate. This can be done by deleting the existing aggregate and creating a new one with the correct settings.
  
  
  
  Check for Changes:
  
  If there have been recent changes to the InfoObject or the aggregate, ensure that all dependencies are correctly updated and that there are no inconsistencies.
  
  
  
  Transport Requests:
  
  If the changes were made in a development environment, ensure that the transport requests are correctly moved to the production environment, and that all objects are in sync.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or notes related to the specific error message for additional guidance and troubleshooting steps.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional context.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  BW Modeling Tools: Familiarize yourself with the BW Modeling Tools in SAP BW/4HANA or SAP BW on HANA, as they provide enhanced capabilities for managing aggregates and InfoObjects.
  
  By following these steps, you should be able to identify and resolve the cause of the RSDD812 error in your SAP BW environment.