The following behavior occurs in SAP Analytics Cloud (SAC):
- OData based Import Data Connection retrieves only the first 1000 (one thousand) rows
- SAP Analytics Cloud (Enterprise) 2021.2.0
- OData 4.0 with @odata.nextlink functionality
Reproducing the Issue
- Create an Import Data Connection - OData, based on https://services.odata.org/Experimental/Northwind/Northwind.svc/
- Select the Query named: Order_Details_Extendeds (this query returns 1480 rows and has @odata.nextlink functionality)
- Run the import, only 1000 rows are imported
This issue is currently under investigation by development.
- 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
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
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