3752718 - rsrt query fails with "service cannot be used" and "ddl source not a valid bw query"; ddl shows "empty value in hierarchy binding for type v"

• Running a BW query in RSRT shows:
  • Service cannot be used
    Query 2C<query name> could not be opened.
    Position in code >> Row: 38 Inc: CONSTRUCTOR Prog: CL_RSR_OLAP_VAR
    DDL source <DDL cube name> is not a valid BW query. Check and adjust the DDL source.
• In SE80 tcode, checking the cube fails with error:
  • Empty value in hierarchy binding for type V.
• In some cases, previewing the query in the Custom Analytical Queries app ends with:
  • 500 Internal Server Error: An exception has occurred that was not caught.

• SAP S/4HANA

RSRT, custom analytical query, service cannot be used, metadata not loaded, DDL source not a valid BW query, empty value in hierarchy binding for type V, RSRTS_CDS 039, CL_RSR_OLAP_VAR, constructor, CDS activation, OData service, preview error, 500 internal server error, query could not be opened , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , Problem