3298660 - How does the SAP Analytics Cloud (SAC) data export service (DES) API work with larger volumes of data?

You would like to know how the SAP Analytics Cloud (SAC) data export service (DES) API service works.

SAP Analytics Cloud (Enterprise)

• The new Data Export Service API offers the support for a "pagesize" parameter as mentioned here: https://api.sap.com/api/DataExport_API/resource
  Users can specify the  pagesize parameter and the number of rows on the page will be less than or equal to that number.
• In detail, if the data from the model cannot be sent in one single page to the customer, Data Export Service will append at the end of the response a next page link that users must follow to extract the next page of data. This next link will be present until the end (last page won't have any next link).
• Let's clarify now the number of rows for each page.
• The number of rows in one single page, is limited by two different factors: the first one is pagezise parameter and the second is more technical which is the response memory.
• Since SAC interacts with PublicAPI, the maximum page size (response to the customer) cannot be more than 30MB (compressed).
• Example 1:
  • Customer is specifying pagesize = 10M rows
  • 30 MB (compressed) are enough to export 1M rows
  • The Data expert service will enforce pagination for each million rows.
• Example 2 with planning model with only 1000 rows:
  • Customers can specify a pagesize = 1M rows but anyway the page will only contain 1K rows since that's the total number of rows.
  • If you see memory issues in the DP agent, please try with different pagesizes and see the memory usage.
• Based on your agent, you will be able to identify the best pagesize for your model.

• https://api.sap.com/api/DataExport_API/resource
• api/v1/dataexport https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/14cac91febef464dbb1efce20e3f1613/db62fd76514b48f8b71d695360320f4a.html
• https://blogs.sap.com/2022/05/30/leverage-the-sap-analytics-cloud-data-export-service-to-extract-your-planning-data-to-sap-hana-sap-business-warehouse-and-sap-s-4hana/
• Data Integration section in What’s New in SAP Analytics Cloud Release 2023.01
• 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 Google or Bing:
  • 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!

export from SAC to BW, DWC, S/4HANA, DTP, exporting, 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, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence,  , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , How To