2540886 - How to export data from models in SAP Analytics Cloud?

How to export data from models in SAP Analytics Cloud (SAC)?

SAP Analytics Cloud (Enterprise)

• Legacy export sources (See SAC Help Guide: Export Models and Data for further information and pre-requisites):
  Note: The BW and BW/4HANA (via an OData service), SAP S/4HANA, and SAP Integrated Business Planning (IBP) options are not visible unless you enable the legacy export option. 
  For further information, see 3302366 - How to Enable the Legacy Export option in SAP Analytics Cloud?.
• To a file (CSV); if encountering any issue with this option, please create a case to LOD-ANA-AQU.
• SAP Business Planning and Consolidation (BPC):
  3011069 - Checkpoints: Export Job and Import Job between BPC Model and SAP Analytics Cloud,
• BW and BW/4HANA (via an OData service) :
  2920775 - Export of SAP Analytics Cloud (SAC) transaction data to SAP BW/4HANA 2.0 SP4 or SAP BW 750 SP18,
• SAP S/4HANA:
  2998919 - Tips and Tricks of Analyzing S/4HANA Data Integration with SAC Issues,
• SAP Integrated Business Planning (IBP):
  2721602 - Connection to IBP with SAP Analytics Cloud.

• 🆕 Data Export Service Open (DES) API:
• Export Data with the Data Export Service Open API
• Leverage the SAP Analytics Cloud Data Export Service to extract your planning data to SAP HANA, SAP Business Warehouse / BW/4HANA and SAP S/4HANA
• Data Export Service on the SAP API Business Hub
• SAP Analytics Cloud Export Data API Sample Scripts

        Note: As a best practice, it is recommended to utilize the Data Export Service API whenever possible to export data due to superior performance and delta support.

• KBA: 2920775 - Export of SAP Analytics Cloud (SAC) planning/analytical model data to SAP BW/4HANA 2.0 SP4 system using OData
• kBA: 2998919 - Tips and Tricks of Analyzing S/4HANA Data Integration with SAC Issues
• KBA: 2590508 - Import or Export Data from/to SAP S/4HANA to/from SAP Analytics Cloud
• KBA: 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA: 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• KBA: 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 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!

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

Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, export, excel, csv, xls, MS, NW, Retraction function to SAP S/4  -Failing to load some data in ACDOCP, 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, standard SAP Analytics Cloud export functionality, export service, Data Export Service Test, DPServer SAP Integrated Business Planning push Push Export, WriteBack from SAC to S4 table ACDOCP by using API API_FINANCIALPLANDATA_SRV ODATA EXPORT fails to load the Data in BW Retraction problem from SAC to BW, Write Back of FIX/VAR data from SAC to S4 by using the API API_FINANCIALPLANDATA_SRV, Issue with Data Volume Push from SAC to IBP via ODATA Import Connection, SAC Export failing to BW4HANA-Odata service with 503 error sub account, LOD-ANA-PL export via OData does not work, SAC Export Jobs Failing Frequently, Writeback SAC to BW - ODATA, SAC=>S/4HANA , KBA , sac planning model to s4/hana , export data to s4 sac kba , sac planning connection to s4/hana , write back data from a sac planning mode , export problems , odata connection to bw issue , sac export data connection intermittantl , sac export to excel , sac error in rectraction of planning dat , data to s4 hana cloud , retraction , retract retracting , sac data export api: how to enable data , error writing back to sap bw4hana from s , issue with transport - package creation , how to enable data export service in sac , export service in sac? data exprting exp , exporting exported custom , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , LOD-ANA-ADM , SAC Administration , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , How To