How To Fix RSDD747 - Options "Display SQL Statement" and "Display Execution Plan" not possible

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD - Message class for data manager

• Message number: 747

• Message text: Options "Display SQL Statement" and "Display Execution Plan" not possible

What causes this issue?

The options "Display SQL Statement" and "Display Execution Plan" are
only possible if the aggregate has already been activated (but not
necessarily filled).

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?

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 RSDD747 - Options "Display SQL Statement" and "Display Execution Plan" not possible ?

  The SAP error message RSDD747, which states that the options "Display SQL Statement" and "Display Execution Plan" are not possible, typically occurs in the context of SAP BW (Business Warehouse) when trying to analyze the performance of a query or data extraction process. This error can arise due to several reasons, and here are some common causes, solutions, and related information:
  Causes:
  
  
  Query Execution Context: The query might not have been executed in a way that allows for SQL statement or execution plan analysis. For example, if the query is executed in a mode that does not generate an SQL statement (like a BEx Analyzer or a web application), these options may not be available.
  
  
  Missing Authorizations: The user may not have the necessary authorizations to view the SQL statement or execution plan. This can happen if the user lacks the required roles or permissions in SAP BW.
  
  
  Technical Settings: The InfoProvider or query