3423607 - Bad performance for specific Odata query import job

• Bad performance for specific Odata query import job

• SAP Analytics Cloud (Enterprise)

1. Create an import job based on a Odata query and set the batch size to be max value 50000.
2. Run the import job and it takes very long time (20 mins) to finish.
3. Try to run the same query in postman, it takes much less time (around 1 mins) to get data.

 The client side(SAC) pagination (batch size = 50k) is being overwritten by the OData service. There is server side pagination implemented in the OData service. 

Modify the Odata service side pagination limit setting to allow larger size, eg:50k.

• 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 a case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
  • https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
  • https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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

Odata batch , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem