SAP Knowledge Base Article - Public

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

Symptom

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

Environment

SAP Analytics Cloud (Enterprise)

Resolution

  • 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.

See Also

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

Keywords

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.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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 , How To

Product

SAP Analytics Cloud 1.0