How To Fix RSPLS720 - Excluded hierarchy nodes are not supported -> node will be omitted

SAP Error Message - Details

• Message type: E = Error

• Message class: RSPLS - General Messages

• Message number: 720

• Message text: Excluded hierarchy nodes are not supported -> node will be omitted

What causes this issue?

The filter contains at least one excluded hierarchy node.

System Response

This kind of filter is not supported in transaction RSPLAN for the
manual input template. This special filter is left out.

How to fix this error?

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

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 RSPLS720 - Excluded hierarchy nodes are not supported -> node will be omitted ?

  The SAP error message RSPLS720 indicates that there are excluded hierarchy nodes in a query or report that are not supported, leading to the omission of those nodes from the output. This typically occurs in the context of SAP BW (Business Warehouse) when working with hierarchies in queries or reports.
  Cause:
  
  Hierarchy Configuration: The hierarchy being used in the query may have nodes that are marked as excluded. This can happen if certain nodes are set to be excluded from the hierarchy for reporting purposes.
  Query Design: The query might be designed in a way that it attempts to display or process these excluded nodes, which is not allowed.
  Data Model Issues: There may be inconsistencies or misconfigurations in the underlying data model or InfoObjects that define the hierarchy.
  
  Solution:
  
  
  Check Hierarchy Settings: Review the hierarchy settings in the SAP BW system. Ensure that the nodes you want to include in your report are not marked as excluded. You can do this by navigating to the hierarchy in the SAP BW modeling tools and checking the properties of the nodes.
  
  
  Modify the Query: If the query is trying to access excluded nodes, you may need to adjust the query design. This can involve:
  
  Removing filters or conditions that reference the excluded nodes.
  Adjusting the structure of the query to avoid including those nodes.
  
  
  
  Update the Data Model: If the issue is related to the data model, consider updating the InfoObjects or the hierarchy definition to ensure that the necessary nodes are included and properly configured.
  
  
  Consult Documentation: Refer to SAP documentation or help resources for specific guidance on handling hierarchies and excluded nodes in your version of SAP BW.
  
  
  Testing: After making changes, test the query or report again to ensure that the error is resolved and that the desired data is being displayed correctly.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Training and Documentation: Consider reviewing training materials or documentation related to SAP BW query design and hierarchy management for a deeper understanding of best practices.
  
  By following these steps, you should be able to resolve the RSPLS720 error and successfully work with your hierarchies in SAP BW.