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
- Log into SAC URL and create a new Application Designer.
- Add ODataservice.
- Select the BW system.
- Pass URL and click on "Refresh" button to access metadata.
- F12 Console throws error as "401" error.
- 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. To 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
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