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

RSMSS_ANALYZER_MSG012 - Overview

• 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