SAP Knowledge Base Article - Public

2933053 - OData Query returns empty result set in SAP Analytics Cloud (SAC)

Symptom

When connecting SAC to an oData datasource the following error is displayed on trying to import the data

  • Failed Upload : The dataquery returns empty result set.

 

Environment

  • SAP Analytics Cloud (Enterprise) 2020.12.20

Cause

Looking at the $metadata for the query it returns a property:

sap:pageable="false"

Looking through the SAC help documentation (https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/5c10ca68809c413087c39e9a6af39e24.html) it lists specifics for paging capabilities being returned by the oData service:

  • Support paging based on $top and $skip.
  • Should have the ability to return 1000 data rows per request, but if it doesn't, it must implement the “nextLink” function.
  • The order of the data rows in the data source needs to be fixed during data acquisition (for example, by sorting on a column). Otherwise, when paging is done, there could be data correctness issues. For example, the same data row could appear more than once in different pages.
  • The order of data rows should be guaranteed on data source during paging by $skip and $top.

Resolution

  • As this oData service does not support paging it will not be supported in SAC. 
  • Talk to the administrators of the oData service to see if the underlying data structure allows this property to be set to true.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, 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, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0