How To Fix RSDD814 - Unneeded check aggregates will be deleted

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 814

• Message text: Unneeded check aggregates will be deleted

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDD814 - Unneeded check aggregates will be deleted ?

  The SAP error message RSDD814, which states "Unneeded check aggregates will be deleted," typically occurs in the context of SAP BW (Business Warehouse) when dealing with aggregates in InfoCubes. This message indicates that there are aggregates in the system that are no longer necessary and will be removed by the system.
  Cause:
  
  Redundant Aggregates: The system has identified that certain aggregates are not being used or are redundant due to changes in the data model or the way data is being queried.
  Changes in InfoObjects: If InfoObjects or the structure of the InfoCube have changed, it may render some aggregates obsolete.
  Performance Optimization: SAP BW may automatically clean up unneeded aggregates to optimize performance and storage.
  
  Solution:
  
  Review Aggregates: Check the aggregates in the InfoCube to understand which ones are being flagged as unneeded. You can do this through the Data Warehousing Workbench (transaction RSA1).
  Delete Unused Aggregates: If you confirm that the aggregates are indeed unneeded, you can allow the system to delete them. This is usually done automatically, but you can also manually delete them if necessary.
  Rebuild Aggregates: If you need certain aggregates for performance reasons, consider rebuilding them after ensuring that the underlying data model is stable and that they are necessary for your reporting needs.
  Monitor Performance: After the deletion of aggregates, monitor the performance of your queries to ensure that the system is still performing optimally without the deleted aggregates.
  
  Related Information:
  
  Transaction Codes: Use transaction codes like RSA1 (Data Warehousing Workbench) to manage InfoCubes and aggregates.
  Documentation: Refer to SAP Help documentation for more details on aggregates and performance optimization in SAP BW.
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or solutions related to this error message.
  System Maintenance: Regularly perform system maintenance and monitoring to ensure that aggregates and other objects are optimized for performance.
  
  By addressing the cause of the error and following the suggested solutions, you can effectively manage aggregates in your SAP BW environment and maintain optimal performance.