It has been a very busy year for SAP Analytics Cloud and here we are at the last quarter with plenty of exciting new features. Let’s take a look at all the feature inspired by you, our customers.

Story Design

By far our most popular item in QRC4 2023 with over 600 votes is the support of area enriched dimensions for Geo Maps.

Geomaps – Area Enriched Dimensions 

The optimized design experience now supports the consumption of Area Enriched Dimensions. This is supported for stories created in the optimized story experience and existing classic stories that are converted to the optimized experience.

In terms of model enrichments, with the New Model type we now provide an option to add various Geographical Properties to dimensions (Organization or Generic) which include:

• Country / Region
• Region
• Sub-Region

We limit the creation of each property once per dimension (i.e. Region cannot exist twice for a single dimension). This improvement is specific to the choropleth layer.

Composite widgets as reusable widgets in Optimized Story Experience 

Sticking with Story Design we now give our users the ability to create a composite widget, which is a reusable building block that can be consumed like any other standard widget in stories. Composites are stored in the file repository as an artifact – allowing for filtering and ability to transport it to another tenant. The use of composites will help speed up development time.

A composite has its own authorization, therefore giving flexibility to assign the proper permission to each user.

Additional features delivered from Customer Requests for Story Design and Extensibility for this quarter include:

• Add Cross Calculation in dynamic text
• IBCS chart axes pattern in stacked column chart
• Frame Color for chart objects
• Search not possible on hierarchical filters in optimized view mode with BW live connection
• API for start version Edit mode with restricted scope

Administration & Service Management

An important topic voted for by SAP Analytics Cloud Administrators is the ability Transport of object-level security shared with teams in SAP Analytics Cloud through content network storage. This allows Admins to:

• Define object-level security for teams in SAP Analytics Cloud at the development tenants and transport it to the production tenants
• Avoid repeating object-level security for teams in the production tenant

We have also added a detailed report that shows when the User was created in the Admin Cockpit.

Microsoft Office Integration

We had a lot of great features for our Microsoft Add-in to excel in Q4 2023which closed 6 customer requests and more than 80 votes and one of the most voted for was the addition of support for SAP BW and SAP S/4HANA.

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.

• 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

Next up we have 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.

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.

Selecting data action parameters dynamically in Microsoft Excel workbooks

Another popular enhancement to data actions this quarter 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.

Disable a model for planning

You can now disable a model for planning in a workbook.

You can see and change planning status model’s context menu in the builder panel:

Finally, you can get the full list of all requests for SAP Analytics Cloud in the Customer Influence Portal. Here you can have your say by adding your own ideas and requests for new features in SAP Analytics Cloud.

Our customer requests Open for Voting have now over 3700+ requests so get in raise your requests and cast your votes to have your say.

If there is an area that is of particular interest to you for example Data Exploration, you can narrow your search to just these requests using the filter bar.

We want to continue hearing from you so get voting!