Image for

This blog covers some of the latest new features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2019.14. Please note that the Analytics Cloud Help documentation is updated at the same time as the upgrade to this release, so the links here may not yet reflect what is described below until after the upgrade is complete.
Upgrade your SAP Analytics Cloud agent to the latest agent version 1.0.235 to take advantage of all the data acquisition types!
If you haven’t upgraded yet, here are the data acquisition minimum requirements:

  • Version 1.0.233 for SAP Business Warehouse (BW)
  • Version 1.0.99 for SAP ERP / SQL databases
  • Version 1.0.91 for SAP Universe (UNX)
  • Version 1.0.75 for all other data source types

For more information, see System Requirements and Technical Prerequisites.

Highlights of this release:

Learn with our latest video tutorials

General Updates

Multilingual content support


You can now translate user-defined fields for a given story, with appropriate permissions. Make sure to first enable translation from your System configuration as an Administrator, then you can assign translation roles to any users in your organization. From here, these users can mark stories for translation, ensuring that they appear in the new Translation tab within the Browse menu. This Translation tab will hold all the XLF files for the marked stories, which can then be translated using third party translators to help speed up the process! There is also a new manual translation interface for small changes and edits after you’ve translated the XLF file. Now, users from across the world will be able to share and consume stories with ease!


Quartile exception aggregation type support

As with models based on acquired data, you can now define additional exception aggregations types based on SAP HANA Live models down to a T(-stat). These include First Quartile, Median and Third Quartile. This should help to normalize your distribution of time when working with SAP Analytics Cloud.


Dynamically select leaves for a hierarchy

For all non-account dimensions, you can now dynamically select to display only the leaves for the selected hierarchy.

Data locking task in Calendar mode

The Calendar mode will now enable the creation of a Data Locking Task to trigger an assignee to complete Data Locking. I was going to make a joke but there’s nothing funny about data privacy.

Generate tasks or processes with the Calendar wizard

Yer a wizard Harry! You can now generate calendar tasks and processes along a driving dimension using a wizard. This should help save lots of time when creating batches of events, allowing you to go back to creating potions or playing Quidditch.

Parameters for data actions and advanced formulas

When you’re creating a data action, you can now create parameters and add them to any of the steps of your data action. You can use parameters to create prompts for users in stories or to quickly update a fixed member value or number in several different places throughout the data action.

Once you’ve created a parameter in a data action, you can call the parameter in an advanced formula action. This works with creation via script and with the visual tool, increasing your speed and efficiency through automation.

Attribute function

In advanced formulas you can now get the values of a numerical dimension attribute using the Attribute function and use it in a mathematical calculation. So, when you start getting a bunch of new information, you can attribute it to this new update 😉.

Performance enhancements in advanced formulas

Advanced formulas need advanced performance, and that’s why we’ve optimized their overall response time by 46% on average. Are you getting tired of me telling you how much time you’re going to save? Good.

Visual Formula enhancements

In Advanced Formulas created using Visual Formulas, you can now choose to copy or read data from other models besides the default model of the Data Action. On top of that, in Advanced Formulas created using the Visual Formula editor, you can now add a “Delete” component to clear data facts within a defined data scope. Huzzah!

Intelligent Enterprise

Enable currency conversions using SAP BW remote connections

You can now convert currencies using SAP BW remote connections, with the conversion types and rates defined in BW available in the SAP Analytics Cloud User Interface. That’s a feature I could go Won and Won about…

Hierarchy geo map visualizations for SAP BW

The choropleth layer in geo maps can be used to visualize data as a hierarchy of geographical shapes with SAP BW. Lovers of drilling down rejoice!

When dynamic filters are created by a variable submission for a specific dataset, they will automatically be applied on all layers.

Tuple filters for charts and tables when drilling down

You can now use tuple filters for charts and tables when drilling down on dimensions ordered in hierarchies. Tuple filters can also be combined with linked analysis between different tables or charts, giving you more flexibility in how you want to view your data.

Data Visualizations

Dynamic text for any dimension

This will give you the ability to create dynamic text from a Dimension rather than a single filter or input control. Dynamic text will also include the dimension member(s) selected when using linked analysis. For example, when applying a single member page filter in your story, you can build a report style dashboard that dynamically changes your text based on what’s being filtered and shown on screen.

Stacked bar chart without dimension axis

No, the bar chart hasn’t started weightlifting, but it has given you the ability to show multiple measures all stacked without needing a dimension. That’s a measurable improvement!

Input controls for multiple cross calculations for tables

The new cross calculation input control supports single and multiple member selection in tables, giving you more precision to accurately view your data. This will create so many formulas we might be able to solve the remaining Millennium Prize Problems!

Explorer in Embedded mode

Viewers can now access explorer mode in embedded view as long as the story designer enables the feature. This will make it easier for viewers to investigate data beyond existing charts.

Performance improvement for clustered geo maps

Unnecessary legend information in clustered geo maps will no longer be displayed, allowing for load times faster than a race between two Concordes.

New default for Story & Page time range filters

To save you time, dynamic time is the new default option for Story & Page time range filters.


Support for featured content

Featured stories and presentation can now be accessed from mobile, as well as being able to set featured content as a default filter when logging into the app. You won’t ever have to worry about missing critical information from your business again!

Analytics Designer

Set widget size and position according to application logic and canvas size

As an application designer, you’ll be able to allow application users to dynamically set a widget’s size and position according to application logic and canvas size using the layout-related APIs. Alternatively, users can change the widget width, height, and position statically using the Styling Panel. If only I could set my height this easily…

Define theme

Application designers can now define, load, or edit a theme at application design time, as well as store all the widget settings in a theme. The theme will be stored in the file repository and can be reused in any other analytical application, though owner permissions will be required to make any changes.

Panel widget

This update also brings panels to Analytics Designer, enabling you to create a container for grouping widgets together. This will help move multiple widgets around easier, instead of having to move them all individually. You can think of it like the Avengers, they’re good individually, but when you hear “Avengers assemble!” you know it’s about to get even better!

Data analyzer

The data analyzer is a predefined ready-to-run service for SAP BW queries. You can use the Builder panel and the Available Items area to navigate and analyze your data by adding and removing dimensions from the table, filtering for items, and changing its display and sort order.

Data Integration

Import data from Amazon S3, Egnyte, Dropbox, NetSuite, Microsoft Dynamics and OneDrive via Open Connectors

This update brings access to 6 new sources which can be set up with SAP Cloud Platform’s Open Connector service found in the SAP Store. The SAP Analytics Cloud administrator will also have a global pause button available to manage usage. Let the information flow begin!

Replicating data from SAP HANA

You can now import data via the new SAP HANA driver, giving you more flexibility with SAP HANA sources so you can choose whether to import or use a live connection.

Key details:

  • Data can be acquired from:
    • All view types via the Query Builder
    • All tables and procedures via Freehand SQL
  • Supports single or multi-container
  • Requires setup of SAP Cloud Agent and SCC

Import data file size improvements

We now support CSV files up to 2GB and Excel files up to 200MB, giving you double the data import capability. Because when it comes to data and analytics, bigger is always better!


Data export improvements

With this feature, you’re getting two great updates for the price of one. Not only can you export up to 6 million rows of fact data, but the speed for exporting is even faster than when you could only export 1 million rows. You can also choose whether to export facts, calculations, or both, but calculations are still limited to 1 million. This almost sounds too good to be true!

Administration & Infrastructure

Users’ API Provisioning enhancements

You can now add filters to user GET requests made through the User and Team Provisioning API. This will support the Username and Email attributes.

Two-legged OAuth Support

Two-legged OAuth integration support for SAP Analytics Cloud instances running on non-SAP datacenters has been added, allowing seamless integration with S/4HANA and Intelligent Asset Management. And as Porky used to say, “Th-Th-The, Th-Th-The, Th-Th… That’s all, folks!”

**Legal disclaimer
SAP has no obligation to pursue any course of business outlined in this blog or any related presentation, or to develop or release any functionality mentioned therein. This blog, or any related presentation and SAP’s possible future developments, products and or platforms directions and functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in this blog is not a commitment, promise or legal obligation to deliver any material, code, or functionality. This blog is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. This blog is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP’s willful misconduct or gross negligence.

All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements and should not be relied upon in making purchasing decisions.


Still have questions?

We’re always happy to help with any questions you may have.

Contact Support