How To Fix RSMSS_ANALYZER_MSG004 - Inconsistently compressed Basis InfoCube requests

SAP Error Message - Details

• Message type: E = Error

• Message class: RSMSS_ANALYZER_MSG - Messages for RSMSS_ANALYZER

• Message number: 004

• Message text: Inconsistently compressed Basis InfoCube requests

Check description
This check looks for basis cubes containing compressed requests that are
inconsistent. The check identifies infocubes with:
Missing initial records (DIMID = 0 and 0REQUID = 0) in the package
dimension table
More than one package dimension record with DIMID = 0
Compressed requests for which the package dimension entry was not
deleted and package dimension column in the E-Fact table was not set to
0
This check applies to cumulative cubes only.
Repair description (available on MSSQL based systems only)
The repair for the findings is as follows:
Create the initial package dimension entry
Delete the superfluous record
Delete the package dimension and set the package dimension column of the
compressed request in the E-Fact to 0.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSMSS_ANALYZER_MSG004 - Inconsistently compressed Basis InfoCube requests ?

  The SAP error message RSMSS_ANALYZER_MSG004 indicates that there are inconsistencies in the compression of requests for a Basis InfoCube. This typically occurs when the data in the InfoCube is not properly compressed, which can lead to issues in reporting and data integrity.
  Cause:
  
  Inconsistent Data: The data in the InfoCube may have been modified or deleted in a way that does not align with the compressed data.
  Failed Compression: The compression process may have failed due to system errors, interruptions, or other issues during the data loading process.
  Data Load Issues: If there were issues during the data load process (e.g., errors in the data source, incorrect transformations), it could lead to inconsistencies.
  Manual Changes: Manual changes to the data or structure of the InfoCube can also lead to inconsistencies.
  
  Solution:
  To resolve the issue, you can follow these steps:
  
  
  Check Compression Status:
  
  Use transaction RSA1 to check the status of the InfoCube and see if there are any inconsistencies reported.
  
  
  
  Recompress the InfoCube:
  
  You can attempt to recompress the InfoCube. This can be done using transaction RSCONN01 or through the InfoCube management in RSA1.
  Navigate to the InfoCube, select the requests, and choose the option to compress.
  
  
  
  Delete Inconsistent Requests:
  
  If certain requests are identified as inconsistent, you may need to delete them. Be cautious with this step, as it may lead to data loss if not handled properly.
  
  
  
  Repair the InfoCube:
  
  If the above steps do not resolve the issue, you may need to repair the InfoCube. This can involve more advanced steps, such as using the Repair InfoCube function in RSA1.
  
  
  
  Check for Data Load Errors:
  
  Review the data load logs to identify any errors that may have occurred during the data loading process. Address any issues found.
  
  
  
  Consult SAP Notes:
  
  Check the SAP Support Portal for any relevant SAP Notes that may provide additional guidance or patches related to this error.
  
  
  
  Related Information:
  
  Transaction Codes: 
  
  RSA1: Data Warehousing Workbench
  RSCONN01: Compression of InfoCubes
  
  
  SAP Notes: Search for specific SAP Notes related to RSMSS_ANALYZER_MSG004 for detailed troubleshooting steps and patches.
  Documentation: Review SAP BW documentation for best practices on data loading and InfoCube management.
  
  Preventive Measures:
  
  Regularly monitor the data loading processes and compression status of InfoCubes.
  Implement error handling and logging mechanisms to catch issues early in the data loading process.
  Schedule regular maintenance tasks to ensure data integrity and consistency.
  
  By following these steps, you should be able to address the inconsistencies in the Basis InfoCube requests and resolve the error message RSMSS_ANALYZER_MSG004.