SAP Knowledge Base Article - Public

3323927 - Unable to fetch Metadata in OData Service of Analytics Designer

Symptom

You have a hosted ABAP Odata Service in BW, which is accessible and responding as expected. 
In Odata Service of  Application Designer ,you try to fetch metadata to access the entityset but it doesn't respond.

Environment

SAP Analytics Cloud 1.0

Reproducing the Issue

Create a new Application designer and add service to it

  1. Log into SAC URL  and create a new Application Designer.
  2. Add ODataservice.
  3. Select the BW system.
  4. Pass URL and click on "Refresh" button to access metadata.
  5. F12 Console throws error as "401" error.
  6. The service call doesn't happen and no metadata is refreshed.

Cause

For Odata service to work correctly with AD, CORS connection needs to be configured correctly. Otherwise, it would not work.

Resolution

The configuration is explained in the online help. Please check the following parts : 

Use an OData Service in Analytic Applications
Live Data Connections to SAP S/4HANA
Live Data Connection to SAP S/4HANA On-Premise Using a Direct CORS Connection via Unified Connectivity

Please note that:

  • The service path you configure should correspond to the end-point URL of the OData service.
  • In addition to the service path listed in the documentation, you need to add another service path /sap/opu/odata4/
  • The connection should also support if-match as allowed header.

The following blog is also recommended : https://blogs.sap.com/2020/11/09/how-to-use-an-s4-hana-odata-service-in-analytics-designer/.

Keywords

KBA , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud all versions