Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
meganhoy
Product and Topic Expert
Product and Topic Expert

SAP Analytics Cloud brings together analytics and planning with unique integration to SAP applications and seamless access to heterogenous data sources. It helps everyone in your organization make decisions without doubt with trusted insights and integrated plans.

This blog post introduces the new features and enhancements of the SAP Analytics Cloud Q4 2023 Quarterly Release (QRC).

Join our SAP Product Experts in the video below as they demonstrate some of the features highlighted in Q3 2023.

 



 

System Administration and Technical Requirements


Although not required, you may upgrade to the latest SAP Analytics Cloud agent version 1.0.387 to take advantage of all data acquisition types.

The agent’s minimum version remains at 1.0.75, with the following exceptions:

    • Version 1.0.99 for SAP ERP/SQL Database

 

    • Version 1.0.365 for SAP universe (UNX). The SAP Analytics Cloud agent requires additional setup steps, for more details see SAP Note 3262098

 

    • Version 1.0.353 for SAP Business Warehouse (BW)

 

    • Version 1.0.235 for SAP HANA View

 

    • Version 1.0.248 for File Server



Important: With every quarterly release update, there are required updates for the integration of SAP BW with SAP Analytics Cloud via SNOTES. This will ensure that the SAP BW back and font ends are in sync. To learn which SNOTES are required for implementation, refer to the XML-File attached in SAP Note 2541557.

Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557 for further details.

Regarding supported features and required updates for live universe access through SAP BusinessObjects Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

Please download the latest version of the Simple Deployment Kit from Service Marketplace.

Note: To avoid downloading older versions and potentially exposing users to a vulnerable bundling of the Cloud Connector with SAPJVM, or Apache Tomcat, only the three latest versions of the kits are available to download.

For Cloud agent version change management details, refer to SAP Note 3264839.

 

Release Highlights



 

 

 

 

 

 

 

 

 

 



 

 

Business Content Delivery


 

Business content packages for sustainability, finance, sales and the public sector


Reduce the time spent implementing SAP Analytics Cloud by adopting new, prebuilt data models and stories.

Updated packages for industries and lines of business for Q4 2023 include: (SAP Road Map Explorer)

    • Public sector management KPI reporting for SAP S/4HANA

 

    • API management reporting dashboard

 

    • Rapid financial planning and analysis for SAP S/4HANA (best practices)

 

    • Rapid sales planning and analysis for SAP S/4HANA (best practices)

 

    • Rapid workforce planning and analysis for SAP S/4HANA (best practices)

 

    • Cross-model add-on for integrated financial planning for SAP S/4HANA

 

    • Group financial planning for SAP S/4HANA

 

    • Integrated financial planning for SAP S/4HANA

 

    • Environment, Health, and Safety

 

    • Accessibility templates for SAP Analytics Cloud

 

    • Travel and expense management

 

    • Sales performance capabilities in SAP Customer Relationship Management



Learn more about SAP Analytics Business Content here.

 

Data Center Availability


 

Data center availability in the Asia region for Google Cloud Platform


Customer now have more choices in data center locations and hyperscaler platforms through support for deployment on Google Cloud Platform (GCP) in Asia. (SAP Road Map Explorer)

 

Data center availability in Europe for Google Cloud Platform


Customer now have more choices in data center locations and hyperscaler platforms through support for deployment on Google Cloud Platform (GCP) in Europe. (SAP Road Map Explorer)

 

Microsoft Office Integration


 

Selecting data action parameters dynamically in Microsoft Excel workbooks


We have made an enhancement to data actions which enables users to run a data action dynamically, based on predefined report filters. This means that if a user has a filter on a table, it will take this as a parameter for the data action and will apply this as a filter for the data action as well. (SAP Road Map Explorer)

This feature is available to customers as of October 18, 2023.


 

Member Selector Enhancements


We have made enhancements to the member selector including: (SAP Road Map Explorer)

    • Improved visual adaption for a better user experience and usability

 

    • Copy and paste members from a clipboard

 

    • Change hierarchy selection



This feature is available to customers as of October 18, 2023.


 

Support for “undo” and “redo” functionality in Microsoft Excel


Enable users to undo or redo the last action performed in changing a layout or the last change in the add-in for Microsoft Office for SAP Analytics Cloud. The undo/redo action is not related to planning – it does not undo/redo any planning entries. (SAP Road Map Explorer)

Please note that there are two undo stacks: Microsoft Excel and Add-in for Microsoft Excel. This functionality is only related to actions done in the add-in for Microsoft Excel.

This feature is available to customers as of October 18, 2023.


 

Preventing workbook created as a template from end-user changes


Enable power users to create reports and workbooks in Excel to be used as a template for end-users without any change in the report structure. (SAP Road Map Explorer)

Prevent end-users to be able to:

    • Change the report definition (row or column definition)

 

    • Apply and change filter on predefined dimensions



This feature is planned for release to customers in November or December 2023.



Support for a new cell-based custom formula in Microsoft Excel – SAP.TIMEOFFSET


Enable users to use specific formulas similar to those in Excel as SAP.TIMEOFFSET to retrieve and calculate dynamically a time-dimension member: (SAP Road Map Explorer)

    • Based on a reference date

 

    • Filter the Excel grid on it



This feature will be available to customers on November 15, 2023. The release has been delayed to Novermber 20, 2023.


 

Support for SAP Business Warehouse (SAP BW) and SAP S/4HANA in Microsoft Excel


Provide a unified experience for users of Microsoft Excel with the SAP BW application and SAP S/4HANA application. (SAP Road Map Explorer)

    • Ability to connect to a live source (using Tunnel connection) of SAP BW and create Excel reports in it

 

    • Ability to connect to a live source (using Tunnel connection) of SAP S/4HANA and create Excel reports in it



This feature will be available to customers on November 15, 2023. The release has been delayed to Novermber 20, 2023.


 

Story Design


 

Show or hide totals and to display net totals in stacked bar or column charts


Show or hide totals in stacked bar or column charts, in the following chart types: (SAP Road Map Explorer)

    • Combination stacked bar and line chart

 

    • Stacked bar or column chart

 

    • Marimekko charts



Display net totals in stacked bar or column charts

    • Toggle between grand totals and negative or positive totals separately, in the following chart types:

 

    • Combination stacked bar and line chart

 

    • Stacked bar or column chart



This is limited to Stacked Visualizations and excludes Stacked Bar/Column Charts with Show as 100% enabled. This is available exclusively in the Optimized Story Experience.


 

This blog post only provides a high-level overview of the latest features and enhancements of SAP Analytics Cloud. For more details on these features, please visit the SAP Analytics Cloud Help Portal. You can also visit the SAP Road Map Explorer to see the upcoming features of SAP Analytics Cloud.

Looking to get started with SAP Analytics Cloud? Get free hands on experience by signing up for a free trial today!

1 Comment