How To Fix S03536 - Cannot determine preaggregations

S03536 - Overview

• Message type: E = Error

• Message class: S03 - Messages for Enjoy TCC Monitors, July 20, 1999

• Message number: 536

• Message text: Cannot determine preaggregations

What causes this issue?

The system failed to determine the preaggregates for a component.
It is possible that the agent that is responsible for the component is
not available over RFC. Check this using transaction SM59 (<LS>Display
and Maintenance of RFC Destinations</>).

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

System Response

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

S03536 - Details

• The SAP error message S03536, "Cannot determine preaggregations," typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when the system is unable to find the necessary pre-aggregated data for a query or report. This can happen for several reasons, and understanding the cause is crucial for resolving the issue.
  Causes:
  
  Missing Aggregates: The required pre-aggregated data might not have been created or loaded into the system.
  Incorrect Query Design: The query might be designed in a way that does not align with the available aggregates.
  Data Model Changes: Changes in the underlying data model (like changes in InfoObjects, InfoProviders, or transformations) may lead to inconsistencies.
  Inconsistent Data: There may be inconsistencies in the data that prevent the system from determining the correct aggregates.
  Authorization Issues: Lack of proper authorizations can also lead to the inability to access the required aggregates.
  
  Solutions:
  
  Check Aggregates: Verify that the necessary aggregates exist for the InfoProvider being queried.