3555341 - Failed to create model on Odata connection to SAP Datasphere with /Set Navigation Property in SAP Analytics Cloud (SAC)

The following error occurs while creating model on Odata connection to SAP Datasphere in SAC:

• Query has failed to upload because of an error in the plugin service. Details: query instance name not entity set or function import

• SAP Analytics Cloud (Enterprise)
• SAP Datasphere (DSP)

1. Logon to SAC and create a new Odata connection to SAP Datashpere.
2. Open the metadata of this Odata API, see there's NavigationProperty Name="Set" in this Entity like following:
   <NavigationPropertyBinding Path="Set/Parameters" Target="EntitySetName"/> 
3. Create a new model via Freehand query, confirms the same query is possible to run in browser(this URL includes /set parameter).
4. Model creation failed with error:
   Query has failed to upload because of an error in the plugin service. Details: query instance name not entity set or function import

Currently Odata query with /Set navagation property is not supported in SAP Analytics Cloud

Workaround:

1. Confirm Odata connection Data Service URL in following format:
   https://<TenantURL>.cloud.sap/api/v1/dwc/consumption/relational/<SpaceID>/<View> 
2. Open the metadata URL in browser:
   https://<TenantURL>.cloud.sap/api/v1/dwc/consumption/relational/<SpaceID>/<View>/$metadata
   
   • Find a list of all Property Names under: <EntityType Name="EntitySetNameType"> 
     Object1, Object2, Object3 ...
   • Find a list of all Input Parameters under: <EntityType Name="EntitySetNameParameters"> 
     Par1, Par2 ...
3. Logon to SAP Datasphere, set default value for all above input parameters.
4. Create a new model in SAC via the Odata connection.
5. Choose Freehand query and make it in the following format:
   EntitySetName?$select=Object1,Object2,Object3&$filter=Object1 eq 'XXX'
   
   

3563695 - How to create Odata connection to SAP Datasphere in SAP Analytics Cloud (SAC)

SAP Cloud, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem