How To Fix RSMSS_ANALYZER_MSG003 - InfoCube tables without index statistics

SAP Error Message - Details

• Message type: E = Error

• Message class: RSMSS_ANALYZER_MSG - Messages for RSMSS_ANALYZER

• Message number: 003

• Message text: InfoCube tables without index statistics

Check description
This check identifies infocube tables including dimension tables and SID
tables without index statistics. For the check, the tables found contain
at least one data row.
Repair description
The repair option creates table statistics for the selected tables. The
execution of UPDATE STATISTICS is triggered with the FULLSCAN option to
force the creation of the SQL Server statistics for tables with less
than 500 data rows.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSMSS_ANALYZER_MSG003 - InfoCube tables without index statistics ?

  The SAP error message RSMSS_ANALYZER_MSG003 indicates that there are InfoCube tables in your SAP system that do not have index statistics. This can lead to performance issues when querying the InfoCubes, as the database optimizer relies on index statistics to determine the most efficient way to execute queries.
  
  Cause:
  The absence of index statistics for InfoCube tables can occur due to several reasons:
  
  Database Maintenance: Index statistics may not have been updated after data loads or changes in the InfoCube.
  Initial Setup: The statistics may not have been generated during the initial setup of the InfoCube.
  Database Configuration: Certain database configurations or settings may prevent automatic updates of statistics.
  
  
  Solution:
  To resolve this issue, you need to generate or update the index statistics for the affected InfoCube tables. Here are the steps to do this:
  
  
  Use Transaction RSMO:
  
  Go to transaction RSMO (Data Warehousing Workbench).
  Select the InfoCube that is causing the issue.
  Execute the "Analyze" function to check for missing