SAP Knowledge Base Article - Public

3069449 - Unable to access custom reports with the error " Failed to resolve navigation target "#AnalyticQuery-analyze?bsa_query=2CYY1_xxxxxxxx" "

Symptom

When accessing any custom reports based on custom analytical queries, there are errors "  Failed to resolve navigation target "#AnalyticQuery-analyze?bsa_query=2CYY1_xxxxxxxx" " and "500 internal Server Error"

Environment

SAP S/4HANA Cloud

Reproducing the Issue

1. Access any report based on the custom analytical queries

2. Got an error:"Failed to resolve navigation target "#AnalyticQuery-analyze?bsa_query=2CYY1_xxxxxxxx" "

Cause

In order to open a custom analytical query, the business catalog SAP_CA_BC_ANA_AQD_PC needs to be included in any of the business roles assigned to the user.

Resolution

  1. Access the app Maintain Bussiness Roles to add the catalog SAP_CA_BC_ANA_AQD_PC  to a role
  2. Access the app Manage Business User to assign the role to the end user

Keywords

Failed to resolve navigation target, AnalyticQuery-analyze,500 internal Server Error, CX_RS_NOT_AUTHORIZED , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud all versions