How To Fix RSDD091 - The indices from aggregate &1 must be checked

RSDD091 - Overview

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 091

• Message text: The indices from aggregate &1 must be checked

What causes this issue?

The <LS>High Cardinality</> property has been changed in one dimension
of aggregate &V1&. In some databases, the database index that is used
depends on this property. However, this index has not been modified.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Check the indexes and, if necessary, rebuild them. Go to transaction
RSRV and choose <LS>All Elementary Tests -> Database -> Database Indexes
of an InfoCube and Their Aggregates </>.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDD091 - The indices from aggregate &1 must be checked ?

  The SAP error message RSDD091 indicates that there is an issue with the indices of an aggregate in the SAP BW (Business Warehouse) system. This message typically arises when the system detects inconsistencies or problems with the aggregate's indices, which can affect performance and data retrieval.
  
  Cause:
  The error can be caused by several factors, including:
  
  Data Inconsistencies: Changes in the underlying data or structure of the InfoProvider that the aggregate is based on.
  Incomplete or Failed Aggregation: If the aggregation process did not complete successfully, it may leave the indices in an inconsistent state.
  Database Issues: Problems with the database that prevent the indices from being accessed or updated correctly.
  Changes in the InfoObject: Modifications to the InfoObjects used in the aggregate can lead to inconsistencies.
  
  
  Solution:
  To resolve the RSDD091 error, you can follow these steps:
  
  
  Check the Aggregate:
  
  Use transaction code RSA1 to access the Data Warehousing Workbench.
  Navigate to the InfoProvider and locate the aggregate that is