Technology Blog Posts by SAP
cancel
Showing results for 
Search instead for 
Did you mean: 
AmandaJMurphy
Product and Topic Expert
Product and Topic Expert
2,404

AmandaJMurphy_0-1740568740881.png

Purpose

Hello SAP Community Colleagues,

In QRC2 2025, we have an action-packed list of new features that have now been made available in the modeling area of SAP Analytics Cloud !!

Overview

Learn more about these new features here:

  1. User-Managed Unit Conversion
  2. Migration of Currency Rate Tables to the File Repository
  3. Data Import API – Allow Import and API Access Toggle

1.     User-Managed Unit Conversion

The Standard Unit Conversion feature has been enhanced to allow users to create, edit or delete unit and unit groups within the Standard Unit Table.

A new Unit Description table enables units to be displayed in a more meaningful way, when consumed in other areas of SAP Analytics Cloud, such as in charts and tables.  This table also supports unit language translation of up to 40 languages.  See SAP Note 3531711 - Supported languages for Standard Unit Conversion in SAP Analytics Cloud for a list of supported languages.

The Standard Unit and Unit Description tables can be accessed from new tiles in the Conversion tab of the modeler.

This custom unit functionality is supported by the Data Export and Data Import APIs that have been extended to allow for the updating of the unit tables in the backend. 

Custom units can also be maintained by SAC modelers and planners who have Datasphere workspaces.

Check out our new Standard Unit Conversion Tutorial to learn how to create a Unit Conversion Measure in SAP Analytics Cloud.

Unit Conversion TutorialUnit Conversion Tutorial

To learn about the end-to end workflow of setting up and creating unit conversion in SAC, refer to my Working with Unit Conversion in SAP Analytics Cloud blog.

2. Migration of Currency Rate Tables to the File Repository

Currency rate tables have been integrated into the file repository area of SAP Analytics Cloud.

The following sections outline where changes can be seen when using currency rate tables.

Currency & My Files

It is now possible to create and save currency rate tables to file repository folders, which can be seen in My Files.

Here, it is also possible to select, move, change authorizations or delete currency rate tables as needed.

Navigate to Currency Conversion from My FilesNavigate to Currency Conversion from My Files

Existing currency rate tables can be found in Files / My Files / Public / Currency Conversions folder.

Migrated Currency Rate Tables FolderMigrated Currency Rate Tables Folder

Currency & Conversion Tab

In the Conversion tab of the Modeler, the most recently used currency rate tables are listed, along with their folder structure location.

Saving newly created tables offers a navigation panel where you can choose where to save your currency rate table to.

This includes saving to workspaces in Datasphere, for those users with relevant authorizations.

Currency & Importing Data / Scheduling Jobs  

You may still import currency data into rate tables from a file or from a remote data source using the import button. 

AmandaJMurphy_2-1740569079559.png

Import jobs from a remote data source, such as from BPC, Google Drive, HANA or BW can be viewed and scheduled within the Data Management workspace of the currency rate table.

A rate table can be selected from a drop-down menu, which includes its directory structure or Datasphere workspace location.

Choose currency rate table from preferred locationChoose currency rate table from preferred location

Currency and BPC

The workflow with BPC has changed.  The Create Currency Rate Table using BPC tile has been removed.  Users should create and save their currency rate table and then import from BPC using the import button. This is now the same as other currency data source workflows.

Currency in a Model

In the Model Preferences section of a model, selecting a currency rate table in Currency Conversion Settings offers a currency rate table name along with its directory structure location.

The creation of currency conversion measures remains the same.

Choose Currency Rate Table from preferred locationChoose Currency Rate Table from preferred location

Currency and Security

Within Security / Roles, Currency no longer displays a drop-down arrow, listing all currency rate tables.  Read authorization for all rate tables can be assigned via roles. 

Within Security / Teams, new RateRoles have been automatically created as part of the migration process.  Users are automatically included within these roles, according to their existing roles assigned on their tenant.  For example, a user with a BI_Content_Creator role will be automatically assigned to a RateRole_BI_Content_Creator team.  These new RateRole teams can be managed or removed if necessary.   

Further authorizations can be managed for individual rate tables from My Files.

Currency and Transport

Within the Transport section of SAC, currency rate tables are now seen in the Public folder of the Export and Import features.  

Tables can be exported or imported individually, providing additional flexibility for customers.

Performance improvements for Currency Conversion

Performance improvements on the conversion of source to target currency units has also been implemented, with further optimizations planned for 2025.

Currency Rate Tables and Datasphere

We continue our investment into seamless planning integration with Datasphere.  Newly created Currency Rate Tables can be saved to a modeler, or planners preferred folder within a Datasphere workspace.

When an SAC user with Datasphere access experiences a locked workspace on Datasphere, updates to any Currency Rate Table residing within this workspace will be prevented until the workspace is unlocked.

3. Data Import API – Allow Import via API Access

To date, the Data Import API can import data into any model via a 2-legged (machine to machine) or a 3-legged (Authorized User) connection without any restriction.

With the introduction of the Allow Import via Data API Access checkbox in the model, it is now possible to control whether data may be imported to a specific model when using the Data Import API.  This control can also be applied to SAC models stored in a Datasphere workspace environment.

In the Access and Privacy section of model preferences, a new listing is available called Allow Import via Data Import API.

Disable checkbox to prevent import of data via the Data Import APIDisable checkbox to prevent import of data via the Data Import API

When the box is checked, import via the Data Import API is permitted and when unchecked, import is restricted.

If a user attempts to carry out an import action when the API option is unchecked, an information message is returned that the model is restricted for import.

Conclusion:

In summary, the following new features and updates have been introduced to the Modeling Extensions and Integration areas of SAP Analytics Cloud as part of QRC2 2025 release.

  1. With the introduction of User-Managed Unit Conversion customers can manage their own custom unit and unit groups within the Standard Unit and Unit Description tables.  Unit translation of up to 40 languages is supported.  Support for unit handling is also available for customers using Datasphere workspaces.
  2. Customers can manage their prefered location and authorizations of their Currency Rate Tables, including saving to Datasphere workspaces.  Migrated tables are located in /My Files/Public/Currency Conversions.
  3. The import of data via the Data Import API can now be managed on selected models, including those stored in a Datasphere workspace, by choosing the Allow Import via Data API Access option in model preferences.

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. 

To find out more about QRC release dates, see SAP Analytics Cloud tenants on Quarterly Release Cycle (QRC) updates in 2025.

Check out our SAP Road Map Explorer to see more upcoming features of SAP Analytics Cloud.

Thanks for reading!

7 Comments
mdelibasic
Explorer

Hi @AmandaJMurphy,

Related to this point no.3 of being able to write into SAC (e.g. planning) models with Data Import API, am I understanding correctly that the following setup i becoming possible:

  1. You have a SAC planning model being stored in DSP, with this box for API writing ticked;
  2. You calculate some data-set in DSP in some SQL manner calculations, and now would be able to call this API to programmatically write it to the SAC model?
  3. If yes, please shed some light - in which calculation contexts in DSP can this specific API be called?

Thanks in advance 🙂

AmandaJMurphy
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @mdelibasic ,

Thanks for your question! The Data Import API currently supports the import of Master (including local dimensions) and Fact Data on models stored in a Datasphere workspace.  It also supports the import of currency to currency rates tables stored in Datasphere and with the QRC2 release, it will support the import of Units to the Standard Unit and Unit Description tables.  More features will come with the APIs and Datasphere in the future.

Best regards,

Amanda

Emmanuel1
Explorer
0 Kudos

Dear Amanda

I follow new features coming with new releases but did not see at this time if tables cross model calculations will be available one day in optimized stories.
For the moment it possible in chart but not for tables.
Is it planned to be added at tables level ?

kind regards

AmandaJMurphy
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @Emmanuel1 ,

Do you mean Linked Formulas in models or blended calculations in stories?  I would suggest reviewing the Road Map Explorer for this topic.  If it is not there please check Improvement Requests and vote or create a new request.

Kind regards,

Amanda

 

grace_zhang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @AmandaJMurphy 

About "RateRole team" mentioned above, "These new RateRole teams can be managed or removed if necessary."

I would like to know : is there any other usage of the "RateRole teams"? Are they only for migration purpose, and we can delete the teams?

Regards,
Grace

 

AmandaJMurphy
Product and Topic Expert
Product and Topic Expert

Hi @grace_zhang ,

These were created as part of the migration of currency rate tables and are not essential for their management.  Customers can continue using roles or teams, whichever is preferred to manage authorizations on these objects, similar to models.

Best regards,

Amanda

grace_zhang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @AmandaJMurphy ,

Thanks very much for the answer.

Regards,
Grace