How To Fix RSMSS_ANALYZER_MSG012 - Uncompressed fact tables (SQL Server decimal compression)

SAP Error Message - Details

• Message type: E = Error

• Message class: RSMSS_ANALYZER_MSG - Messages for RSMSS_ANALYZER

• Message number: 012

• Message text: Uncompressed fact tables (SQL Server decimal compression)

Check description
This check can only be displayed and executed in SAP systems running on
SQL Server 2005. Systems running on SQL Server 2008 and higher use newer
compression features of SQL Server.
Running the check returns a list of infocube F-Fact tables that are not
enabled for decimal compression. Decimal compression stores decimal data
types in a variable length.
Repair description
The repair option enables decimal compression for the selected tables.
Additionally, the SAP database (<SID>) is enabled for decimal
compression.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSMSS_ANALYZER_MSG012 - Uncompressed fact tables (SQL Server decimal compression) ?

  The SAP error message RSMSS_ANALYZER_MSG012 typically relates to issues with uncompressed fact tables in the context of SQL Server and its handling of decimal compression. This error can arise in SAP BW (Business Warehouse) environments when working with SQL Server as the database backend.
  Cause:
  The error message indicates that there are uncompressed fact tables in your SAP BW system. This can happen due to several reasons:
  
  Data Model Configuration: The data model may not be configured to use compression for fact tables, leading to inefficient storage and performance issues.
  Data Load Issues: During data loading processes, if the data is not properly compressed, it can lead to this error.
  Database Settings: SQL Server settings or configurations may not be optimized for handling decimal compression, which can lead to uncompressed data being stored.
  Version Compatibility: There may be compatibility issues between the version of SAP BW and SQL Server being used, affecting how data is compressed.
  
  Solution:
  To resolve the RSMSS_ANALYZER_MSG012 error, consider the following steps:
  
  
  Check Data Model Settings:
  
  Review the settings of your InfoCubes or DataStore Objects (DSOs) to ensure that they are configured to allow for compression.
  Ensure that the relevant settings for decimal compression are enabled.
  
  
  
  Perform Data Compression:
  
  Use the transaction code RSA1 to access the Data Warehousing Workbench.
  Navigate to the InfoCube or DSO in question and perform a manual compression of the data.
  You can also use the transaction RSCONN01 to check and manage connections and settings related to data compression.
  
  
  
  Review SQL Server Configuration:
  
  Check the SQL Server settings to ensure that they are optimized for handling decimal compression.
  Ensure that the database is set up correctly to support the features required by SAP BW.
  
  
  
  Update SAP BW and SQL Server:
  
  Ensure that you are using compatible versions of SAP BW and SQL Server. Check for any available patches or updates that may address known issues with compression.
  
  
  
  Monitor Data Loads:
  
  Monitor the data loading processes to ensure that they are completing successfully and that data is being compressed as expected.
  
  
  
  Consult SAP Notes:
  
  Look for relevant SAP Notes that may provide additional guidance or fixes related to this error. SAP Notes often contain specific instructions or patches that can resolve known issues.
  
  
  
  Related Information:
  
  SAP BW Documentation: Review the official SAP BW documentation for best practices on data modeling and compression.
  SQL Server Documentation: Familiarize yourself with SQL Server's handling of data types and compression techniques.
  Performance Monitoring: Regularly monitor the performance of your SAP BW system to identify any potential issues with data storage and retrieval.
  
  If the issue persists after following these steps, consider reaching out to SAP support for further assistance, as they can provide more tailored guidance based on your specific system configuration and version.