Skip to Content
Product Information
Author's profile photo Maximilian Paul Gander

News about the SAP Analytics Cloud Data Export Service (+ an exciting announcement)

Introduction

The Data Export Service surely was a highlight on the 2022 SAP Analytics Cloud roadmap. It enables countless new use cases given its flexibility and speed. Bi-directional data transfer for planning with SAP Data Warehouse Cloud, insight to action with LOB applications, and enhanced on premise integration are just few examples for that. Make sure to review all the great blog posts that have been published until now: Data Export Service blog posts

In this blog post, I want to give you an update on new features coming your way with QRC1.2023. I recommend reading it all the way to the end if you do not want to miss out on an exciting announcement 😉

Delta export – monitoring and configuration UI

In Q4 2022, the delta export capability was introduced to the Data Export Service. The delta functionality allows you extract any data changes such as insertions, deletions and updates, in a planning model. This simplifies and reduces the time of your export operations as it avoids full data extraction to retrieve the latest data from the planning model. If you store planning analytics or forecasting data in an external system for example, there’s no longer need to truncate the table and run a full export. Instead, export the delta and adjust the target table performing upsert and/or delete based on the delta.

The delta functionality works along with a subscription concept, introduced by the Cloud Data Integration specification (CDI). You need to create a subscription on a given planning model to extract the delta data from that model. This allows you to retrieve the differences in data over a specified period. These subscriptions track the changes made to a particular model, over a specified time period.

With QRC1.2023, we are adding a UI inside the Data Management space of the SAC model itself to help you manage these delta subscriptions. It provides you with detailed views of subscription chains. You can create, delete, and examine subscriptions for a model with selections and filters, and view recent subscription activity in chronological order through the access timeline.

Subscription%20creation

Subscription creation

Subscription%20details

Subscription details

Subscription%20overview

Subscription overview

Streamlining of export job configuration

As you can see above, the Data Management space is currently being redesigned to offer a visual interface to manage the Data Export Service subscriptions directly within SAP Analytics Cloud. To prepare for these changes, we’ve changed the way the way to push data to SAP S4/HANA, SAP Business Integrated Planning, SAP BW and SAP BW4/HANA using OData services. By default, only the file and the SAP BPC options are now available. To be able to push data to other applications, you can now enable the Enable Legacy Export option first. Please note that as a best practice, we recommend using the Data Export Service whenever possible to export data.

Enable%20legacy%20export

Enable legacy export

What will be next?

In the area of the Data Export Service API, we plan to enable the export of currency rate tables in Q2 2023.

And most importantly, we add a new member to our API family! Please, stay tuned for our Data Import API that is planned to be available on the SAP API Business Hub in in Q2 2023! Once more, this is a generic API – this time to push data into both fact tables (public versions) and local dimension master data (public dimensions to be added asap).  It shall allow data workflows to go all the way to the model, for example, using Data Intelligence or SAP Cloud Integration Suite.

So, that’s it… but just for now 😉 Our data integration team will continue to ship exciting innovation to you. So much is for sure.

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kinson Koo
      Kinson Koo

      Thank You so much for the sharing, Maximilian!

      Few questions would like to ask:

      1. Is there any plan to remove the Legacy Export option in future? According to note "2590508 - Import or Export Data from/to SAP S/4HANA to/from SAP Analytics Cloud",  The S/4HANA export option has been deprecated. So just wondering are we required to move to API export to S/4HANA some time in future. Interestingly, in the SAP Help page for SAC, the suggested option to export data to S/4HANA is still using the "S/4HANA export" option instead of API.
      2. Will there be any standard content/ best practice released for the integration with S/4HANA on-premise (e.g. sending financial data back to ACDOCP)? Currently the legacy export configuration is straight forward and intuitive. But if we change to use the API for the export to S/4HANA ACDOCP, extra effort and resources are needed to do the customised development in S/4HANA side to get the data (which also include extra technical setup and testing effort).

      Thank You

      Kinson

      Author's profile photo Maximilian Paul Gander
      Maximilian Paul Gander
      Blog Post Author

      Hi Kinson,

      Thanks for your comment.

      1. There is no timeline yet to deprecate the legacy export options.
        Can you share the help page that you are referring to ("the suggested option to export data to S/4HANA is still using the "S/4HANA export" option instead of API")?
      2. Yes, we are working on that but I cannot share a timeline yet.
        As of now, I can recommend you this blog post: https://blogs.sap.com/2022/10/25/using-sap-analytics-cloud-api-data-export-service-from-sap-s-4-hana/

      BR
      Max

      Author's profile photo Kinson Koo
      Kinson Koo

      Hi Max,

      Thanks for the reply.

      Please check below for the latest help document for exporting data from SAC to S/4HANA and S/4HANA Cloud:

      S/4HANA: Exporting Plan Data to SAP S/4HANA or SAP S/4HANA Cloud | SAP Help Portal

      S/4HANA Cloud: Exporting Plan Data to SAP S/4HANA or SAP S/4HANA Cloud | SAP Help Portal

      Both guidelines are the latest one for data export from SAC to S/4 and are actually the same. They mentioned "In the Export Jobs area, choose the Export button and select Export Data to SAP S/4HANA."

       

      Also great to know that SAP is working on the standard content/ best practice for the integration with S/4HANA on-premise. As it helps a lot if we need to change the legacy option to API to export the data back to S/4 some day in future.

      Thanks!

      Regards,

      Kinson

      Author's profile photo Anthony Sciascia
      Anthony Sciascia

      Hello

      is the import data API already available ?

      best regards

      mat

      Author's profile photo nirav shah
      nirav shah

      Hi Maximilian Paul Gander

      is there any table, where we can export data back from SAC to S4? i.e. ACDOCA, ACDOCP for Planned data etc

      This will be bit helpful and cant see it in another set of threads. I am also looking at possiiblity of SFQM_FLOW.

       

      Regards

      Nirav

      Author's profile photo Hugh Gledhill
      Hugh Gledhill

      Hi Maximilian Paul Gander ,

      Currently it is possible to export fact data and master data using the Export Data API. Is there any plan to allow hierarchies to be exported as well?

      Thanks,

      Hugh

      Author's profile photo Maximilian Paul Gander
      Maximilian Paul Gander
      Blog Post Author

      Hi Hugh Gledhill

      Yes, this is planned and we should get it in 2024. No quarter that I can share yet.

      BR
      Max