How To Fix BS_ANLY_LIST020 - Query &1 cannot be displayed in the hierarchical list

SAP Error Message - Details

• Message type: E = Error

• Message class: BS_ANLY_LIST - Analytics: Simple List Reporting

• Message number: 020

• Message text: Query &1 cannot be displayed in the hierarchical list

What causes this issue?

The query cannot be displayed in hierarchical list component (GUIBB
TREE).

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?

The query has to do one of the following:
Display the row characteristics as one single hierarchy (<ZK>universal
display hierarchy</>)
Contain only a single characteristic on the rows and use a hierarchy for
it

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 BS_ANLY_LIST020 - Query &1 cannot be displayed in the hierarchical list ?

  The SAP error message BS_ANLY_LIST020 indicates that a query (in this case, identified by &1) cannot be displayed in the hierarchical list. This error typically arises in the context of SAP Business Warehouse (BW) or SAP Business Explorer (BEx) when trying to display a query that has issues related to its configuration or data.
  Causes:
  
  Query Configuration Issues: The query may not be properly configured in the Query Designer. This could include missing or incorrect settings for characteristics, key figures, or filters.
  Authorization Issues: The user may not have the necessary authorizations to execute or view the query.
  Data Source Problems: The underlying data source for the query may not be available or may have issues, such as being inactive or not properly loaded.
  Hierarchy Issues: If the query is supposed to display hierarchical data, there may be issues with the hierarchy itself, such as missing nodes or incorrect settings.
  Technical Errors: There could be technical issues in the BW system, such as inconsistencies in the InfoProvider or problems with the query execution.
  
  Solutions:
  
  
  Check Query Configuration:
  
  Open the query in the Query Designer and verify that all settings are correct.
  Ensure that all required characteristics and key figures are included and properly configured.
  
  
  
  Verify Authorizations:
  
  Check the user’s authorizations to ensure they have the necessary permissions to access the query and the underlying data.
  
  
  
  Inspect Data Source:
  
  Ensure that the data source (e.g., InfoProvider) is active and that data has been loaded correctly.
  Check for any errors in the data loading process.
  
  
  
  Review Hierarchy Settings:
  
  If the query uses hierarchies, check the hierarchy settings to ensure they are correctly defined and that all necessary nodes are present.
  
  
  
  Technical Checks:
  
  Look for any technical issues in the BW system, such as inconsistencies in the InfoProvider or problems with the query execution.
  You may also want to check the system logs for any related error messages.
  
  
  
  Rebuild the Query:
  
  If the issue persists, consider rebuilding the query from scratch to ensure that all settings are correct.
  
  
  
  Related Information:
  
  Transaction Codes: You may use transaction codes like RSRT (to execute queries) or RSO1 (to manage queries) to troubleshoot and manage queries.
  SAP Notes: Check SAP Notes for any known issues related to this error message. SAP frequently updates its knowledge base with solutions for common problems.
  Documentation: Refer to SAP documentation for detailed information on query design and troubleshooting.
  
  If the problem continues after trying these solutions, it may be beneficial to consult with your SAP Basis or BW team for further investigation.