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
- Access the app Maintain Bussiness Roles to add the catalog SAP_CA_BC_ANA_AQD_PC to a role
- 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