Purpose
Hello SAP Community Colleagues,
With SAP Analytics Cloud QRC2 2026 edition, you can unlock powerful insights into your data exports with the introduction of the Data Export API and Delta Calculation jobs in Job Monitor.
Read on to learn more about this new monitoring capability, along with our additional SAP Business Data Cloud modeling highlights!!
Overview
Here is a short overview of each feature:
Data Integration Topics
- Introduction of Data Export API & Delta Calculations into Job Monitor – The monitoring of Data Extraction & Delta Calculation jobs is now possible within Job Monitor of SAP Analytics Cloud.
- Data Import API – Import of Fact Data into Private Versions in Seamless Planning Models – Data Import API has been extended to allow for the import of fact data to existing private versions on a Seamless Planning model.
- Data Import API – Import of Master Data into Seamless Planning Public Dimensions – Data Import API has been extended to allow for the import of master data into Public Dimensions that resides in a SAP Datasphere space.
Calculations Topics
- Enhancements to Average and Count Exception Aggregation Formulas – The Average and Count exception aggregation formulas now appear as Average incl. 0, NULL and Count incl. 0, NULL in model calculations.
- Introduction of Member Selector Dialog for Unit artifacts in Modeling – A new Member Selector dialog replaces the existing value help on base measures, calculated measures and dimension properties of type “unit”.
- Enhancements to Data Entry on Inverse Formulas – Data entry is now possible on inverse formulas where the non-target operand contains also contains a formula.
Let’s look at the Data Integration Topics in further detail:
- Introduction of Data Export API, Data Import API & Delta Calculations into Job Monitor
The Data Export and Import APIs within SAP Analytics Cloud facilities the bi-directional workflow of data to and from other SAP Products and 3rd party tools. Until now, visibility of the status of API running jobs was available within the API Client only, and not from within SAP Analytics Cloud.
With the introduction of the Data Export API – Data Extraction & Delta Calculation jobs into Job Monitor, customers are provided with enhanced observability and self-monitoring capabilities of their API jobs.
Learn more about this feature with our SAP Business Data Cloud video:
- Data Export API in Job Monitor
Data Extraction and API Subscription jobs that are part of the Data Export API can now be monitored within Job Monitor of SAP Analytics Cloud.
Authorized users can now gain insights into the status of their jobs within a centralized location of SAP Analytics Cloud. Useful information such as API running times, job status, number of extracted records & job settings are readily available within this easy to navigate interface.
Data extraction jobs include Master Data, Fact Data, Public Dimension Data, Audit, Currency & Unit.
A new Source Object column under the Data Export API tab lists the object from where the data is being extracted from. Objects are hyperlinked to provide navigation back to the source. Use the filter and search options in Job Monitor to locate a specific job.
Select an individual job to gain further insights, such as the number of records that have been exported, the job duration and API configuration details used as part of the OData extraction criteria.
Users with the Job Monitor Administration role can monitor all jobs running within Job Monitor, including Data Export & Delta Calculation jobs.
Users with read access to an artifact, including a Standard or Seamless Planning model, public dimension, currency rate table, standard unit table or unit description table can view all extraction jobs for that specific object inside Job Monitor.
The retention period for Data Extraction jobs is 7 days.
- Delta Calculations in Job Monitor
As part of Data Export API, model fact data delta changes that are pulled to a target system, such as SAP S/4 HANA, are performed using Delta Calculations jobs.
Delta Calculation jobs are created when delta subscriptions are activated on a model. These jobs are automatically generated to capture fact data delta changes. During the busy planning cycle, they can be numerous and long running. Until now, there was no visibility of the status of these jobs.
With the introduction of Delta Calculation jobs in Job Monitor of SAP Analytics Cloud, customers benefit from better job visibility & transparency of these types of jobs.
Authorized users can select Delta Calculations within the Data Export API tab to observe the status of these jobs.
Each job includes useful information such as status, duration, owner, provider name & ID information. Jobs can be filtered by status, or on any of the alternative column headings, to help narrow the volume of logs being displayed. Individual jobs can be selected to display more detailed information on running times and status. The lazy-loading capabilities of Job Monitor handles the display of multiple jobs.
The retention period for Delta Calculation jobs is 24 hours.
Check out the SAP Analytics Cloud REST API Guide for further information on how to leverage the power of Data Export and Data Import API to meet your data integration needs for SAP Analytics Cloud within Business Data Cloud.
2. Data Import API – Import into Models Containing Single Column Dimensions
What are single column dimensions? – In a model, single-column dimensions denote dimensions without an associated storage table or master data.
What’s new with Single Column Dimensions? – The Data Import API has been extended to allow for the retrieval of metadata and the running of a fact data import job into an SAC standard model containing single column dimensions.
Existing endpoints can be used for these scenarios:
- {BaseURL}/providers/{NamespaceID}/{ProviderID}/$metadata
- {BaseURL}/providers/{NamespaceID}/{ProviderID}/FactData
This import type is supported using a 2-legged, machine-to-machine connection, & 3-legged, user-authenticated connection. The Data Import API now supports imports into SAC Standard Models and Seamless Planning models with dimension tables that include master data, as well as single-column dimensions without master data, delivering further feature parity with this feature.
3. Data Import API – Import of Fact Data into Private Versions in Seamless Planning Models
The Data Import API has been extended to allow for the import of fact data coming from external sources to an existing private version on a Seamless Planning model. This aligns with how the Data Import API imports fact data to private versions on SAC standard models. The existing endpoint can be used for this import scenario:
- {BaseURL}/providers/{NamespaceID}/{ProviderID}/FactData
It is supported using a 3-legged connection only, as private versions as specific to individual users. Imports using JSON and CSV formats are also supported. Checks are in place to ensure users have access to a Datasphere space and that the space is not locked.
4. Data Import API – Import of Master Data into Seamless Planning Public Dimensions
The Data Import API has been extended to allow for the import of master data into Public Dimensions that resides in a Datasphere space. This aligns with how the Data Import API imports master data into public dimensions residing in SAP Analytics Cloud standalone tenants. The existing endpoint can be used for this import scenario:
- {BaseURL}/providers/{NamespaceID}/{ProviderID}/MasterData
It is supported using 2-legged (machine to machine) and 3-legged (user authenticated) connections. Imports using JSON and CSV formats are also supported. Checks are in place to ensure users have access to a Datasphere space and that the space is not locked.
Let’s look at the Model Calculation Topics in further detail:
- Enhancements to Average and Count Exception Aggregation
The Average and Count exception aggregation formulas now appear as Average incl. 0, NULL and Count incl. 0, NULL within the SAP Analytics Cloud model. Formulas that use an exception aggregation of AVERAGE or COUNT on base measures and base accounts have been enhanced to display AVERAGE incl. 0, NULL and COUNT incl. 0, NULL, respectively.
This provides clearer visibility of what data is included within formulas using these exception aggregation functions. It is recommended to avoid selecting AVERAGE incl. 0, NULL as the default average exception aggregation value, as results can be impacted by other measures, which can sometimes be misleading. Further details are available in SAP Note 3695342 Understanding Exception Aggregation Average incl. 0, NULL in SAP Analytics Cloud
In addition, it is now possible to create an AVERAGENULL, AVERAGENULLZERO, COUNTNULL & COUNTNULLZERO on base accounts without the need for a formula. The below restriction has been removed.
See also the following blog Understanding Average Exception Aggregation in SAP Analytics Cloud by Alecsandra Dimofte explaining average exception aggregation behaviours.
2. Introduction of Member Selector Dialog for Calculations and Unit in Modeling
The member selector dialog is now available for base measures, calculated measures, conversion measures, account members and public dimensions of type unit.
With this enhancement, modelers can now reference unit types listed within the standard unit table without leaving their model.
3. Data entry on inverse formulas improvements
The Inverse formula has been enhanced to support data entry on calculations where the non-target operand contains a formula. For example, in the below calculation, input enablement is allowed on base measures or accounts.
A = B * C | Inverse( B := A / C )
If the calculation is changed to include a calculated measure or account, for example A = B * D | Inverse( B := A / D ), where D consists of a formula, input enablement is now also permitted. Note that there are some limitations to this. For example, if ‘D’ consists of an exception aggregation, a nested formula, a compounded formula, data entry will not be available.
Conclusion
This upcoming QRC2 2026 edition of SAP Analytics Cloud contains an action packed list of features for Modeling Integration & Calculations !!
- Introduction of Data Export API & Delta Calculations into Job Monitor
- Data Import API – Import of Fact Data into Private Versions in Seamless Planning Models
- Data Import API – Import of Master Data into Seamless Planning Public Dimensions
- Enhancements to Average and Count Exception Aggregation
- Introduction of Member Selector Dialog for Calculations and Unit in Modeling
- Enhancements to Data Entry on Inverse Formulas
A comprehensive list of SAC features for each QRC release can be found in our What's New – 2026 Releases Guide.
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.
Check out our SAP Road Map Explorer to see more upcoming features of SAP Analytics Cloud.
Until next time, thanks a lot for reading!
