SAP Knowledge Base Article - Public

3008366 - OData based Model imports only first 1000 rows in SAP Analytics Cloud (SAC)

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • OData based Import Data Connection retrieves only the first 1000  (one thousand) rows

Environment

  • SAP Analytics Cloud (Enterprise) 2021.2.0
  • OData 4.0 with @odata.nextlink functionality

Reproducing the Issue

  1. Create an Import Data Connection - OData, based on  https://services.odata.org/Experimental/Northwind/Northwind.svc/
  2. Select the Query named: Order_Details_Extendeds  (this query returns 1480 rows and has @odata.nextlink functionality)
  3. Run the import, only 1000 rows are imported

Cause

This issue is currently under investigation by development.

Resolution

  • This issue is currently under investigation by development.

  • Workaround: in the Import Settings, set Incremental Load:
    - Import Method: Append
    - Incremental Load: use a field that can determine an incremental load, in this example OrderId - Since last Import

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