What's New in SAP Analytics Cloud Data Integration QRC 3 2023

[AmandaJMurphy]

Purpose

Hello SAP Community colleagues!

This blog introduces two new Data Integration features within SAP Analytics Cloud that will be available as part of the QRC Q3 2023 release.  View the QRC release schedule here.

Overview

The Data Integration team are delighted to announce two further updates to the Data Import Service.

1. Data Import API – Master Data Public Dimensions

The Data Import API has been extended to now support Public Dimensions.

2. Data Import API - Currency

The Data Import API has been extended to support Currency data.  This compliments the Data Export API Currency Support, released recently in the QRC Q2 2023.

Let’s take a closer look at these new features.

1. Data Import API – Master Data Public Dimensions

The Data Import API is an Open HTTP based API allowing for the import of data from external systems into models within SAP Analytics Cloud.  This API was released in QRC Q2 2023 to initially support the import of Fact and Master Data for local dimensions, from external sources into SAP Analytics Cloud models, containing both measures and accounts.  See my previous blog, What’s New in SAP Analytics Cloud Data Integration QRC Q2 2023 Release.

As part of QRC Q3 2023 release, the Data Import API has been extended to also support the import of Public Dimensions data.

Figure 1: Public Dimension Endpoints

Figure 1 illustrates the Data Import API Public Dimensions functionality exposed under the /publicDimensions endpoints.

Figure 2: Post Request Sample Body for Public Dimension

Figure 2 shows the mapping of public dimension data to the target SAP Analytics Cloud public dimension.

Figure 3: Imported Data into SAP Analytics Cloud Public Dimension

Figure 3 illustrates how the mapped public dimension data has been imported into a SAP Analytics Cloud public dimension.

Create and Update of dimension members is supported.

The API also supports JSON file format and OAuth 2-legged (machine to machine) and 3-legged (business user) scenarios.

Note that the import of Data Access Control information and public dimension data containing hierarchies is not supported with this release.

You can find out more about Data Import API, by going to the SAP Business Accelerator Hub and typing Data Import Service in the search bar.  Latest features will be reflected in the API documentation from QRC Q3 2023 release.

 

2. Data Import API - Currency

The Data Import API has been extended to support Currency data.  This compliments the Data Export API Currency Support, released recently in the QRC Q2 2023.

The key feature is that it allows technical users to import currency data from external systems into a SAP Analytics Cloud Currency Rates Table.

Figure 4: Currency Dimension Endpoints

Figure 4 illustrates the Data Import API Currency functionality exposed under the /currencyConversions endpoints.

Figure 5: Post Request Sample Body for Currency Import

These combined Data Export and Data Import APIs provide performance improvements to the newly refactored Currency Rates Table for our Cloud Foundry customers due to delta loading capabilities and server-side sorting and filtering options.

Together, they create powerful bi-directional workflow of Currency data.

For more details on the updates to the Currency Rates Table, check out What’s New in SAP Analytics Cloud Model Calculations QRC Q3 2023

Conclusion

The Data Import Service has been extended to now provide support for Public Dimensions, extending the powerful bi-directional workflow of data to and from SAP Analytics Cloud.

The Data Import Service has also been extended to provide support for Currency data, providing improved performance of the Currency Rates Table for Cloud Foundry customers.

For more information on Data Import Service & Data Export Service see the following documentation SAP Analytics Cloud Rest API, sections Importing Data or Exporting Data.

If you have any questions, feel free to comment below or post a question to our SAP Analytics Cloud Questions & Answers forum.

See this SAP Knowledge Base Article if you’d like to learn more about FastTrack and Quarterly Release Cycle releases.

For further information, visit our SAP Analytics Cloud Community pages to find more product information, best practices, and more. And check out our SAP Road Map Explorer to see more upcoming features of SAP Analytics Cloud.

Thanks for reading!