SAP
Image for

This blog covers some of the latest new features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2018.22. 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.209 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.109 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. Also, check out this blog post for updated information on live connections to on-premise data systems (CORS recommended).

Highlights of this release:

Learn with our latest video tutorials

Intelligent Enterprise

Time series chart for live SAP BW

The time series chart is ready for live SAP BW connections!
The different time levels of a level-based hierarchy coming from live SAP BW can now be changed. Users can evaluate the data points on different time granularities, such as day, month, or year.

HTTP/2 support for live SAP BW

HTTP/2 is now supported for SAP BW connections, optimizing network and server resource usage to increase performance. With HTTP/2, a performance improvement of 20-30% can be expected. Woohoo!

Mobile

Mobile SDK update

The latest SAP Analytics Cloud iOS SDK now requires Xcode 10.x to open and compile the application.

Switch tenant

Users that regularly access multiple tenants will appreciate this enhancement! Now, you can easily navigate between different tenants and set a default tenant in the mobile app.

If it’s your first time going to a second tenant, SAP Analytics Cloud will prompt you and ask if you’d like to set the tenant as your default.

Jump-to navigation in Digital Boardroom presentations

Jump-to navigation from tiles with filter context in Digital Boardroom presentations is now supported.

Please note that Jump-to navigation from pages aren’t yet supported.

Data Visualizations

Custom sort of dimension members in tables

Organize your table dimensions just the way you like them. Now, within a story, you can create custom sort for dimension members that can be applied and reused across charts and tables. With hierarchical dimensions, you can only sort amongst siblings.

Please note that live HANA requires minimal versions 2.00.024.05 (EPMMDS 1.00.201815) and 2.00.033.00 (EPMMDS 1.00.201816). Live BW/S4-HANA and live Universes are not yet supported.

Display images from Live HANA 2.0

It’s no secret that a picture can speak a thousand words—It’s why we love visualizations so much! Story designers can now create widgets displaying images stored on HANA 2.0. They can also upload one alternative image to be displayed if the database entry is missing the image for that data point. The data needs to be filtered to only one data point for the image to show.

Exposing model prompts in story filter bar

Easily add prompts to the story filter bar to make them more discoverable!

Please note that to take advantage of this feature, you must be in Edit mode.

Delayed cascading filters

This new feature is a double-whammy. It improves both performance and user experience!

Delayed cascading filters allow filter input controls to now cascade into each other, ensuring that only valid members are shown based on the filter of other input controls. For collapsed story and page input controls, the query for cascaded members will be delayed until you select the input control. This delayed cascading effect allows you to prioritize queries for visible objects such as: charts, tables, or non-collapsed input controls.

For example, when changing a selection of one input control on a story with 12 collapsed input controls and four charts, there will only be four chart queries sent instead of 15 queries.

Waterfall charts: Show totals before or after children

Specify whether totals are shown before or after the children in waterfall charts once you drill or expand! Root nodes will remain in their position and the intermediate sum defined by you will also be flipped.

Waterfall charts: Show/hide root node of hierarchy

Want to hide or show the root node of waterfall charts? You can now enhance your waterfall charts by choosing to exclude or include the root node. For two-dimensional charts, the primary dimension will have the option to hide the root node. In single-measure charts, breakdown dimensions automatically show the delta values.

 

Waterfall charts: Show breakdown values as delta/actual

Building waterfall charts keeps getting easier! You can select if the breakdown values should show actual or delta values in multi-measure charts when root node is hidden.

For multi-measure charts with breakdown values that are already shown as delta, performing another delta would not be desired.

Please note that the dimension in single-measure charts automatically shows delta values.

Add table show/hide menu items to Explorer

You don’t need to stretch to get some added flexibility here! Now, you can access a table’s Show/Hide menu directly within Explorer.

Convert measures into dimensions and vice versa

Convert a measure into a dimension via measure-based calculated dimensions. Scale and decimal places must be defined as part of the calculated dimension beforehand.

Likewise, you can convert a numeric dimension stored as a string into a measure via the Builder Panel or the Calculation Editor. Non-numeric dimension members will return empty values.

Please note that this is currently unique to imported data.

Convert numeric and string dimensions

You are now able to convert a string dimension into a numeric dimension via the ToNumber formula. You can also do the opposite, numeric to string conversion, with the ToText formula.

For example, if you would like to convert a number to a string prior to concatenating with another string, you would follow:

  • CD1: ToNumber(Age_String_Dimension)
  • CD2: ToText(CD1) + “years”

Please note that this is currently unique to imported data.

Additional exception aggregations in stories

You can enable Exception Aggregations available in Modeler within your story.

This includes:

  • First
  • Last
  • Count Excluding Null
  • Count Excluding 0 and Null
  • Average Excluding Null
  • Average Excluding 0 and Null

Smart Assist

Predictive forecast improvements

You can now set up predictive forecasts to return only positive values for measures when being used with a table.

When running a forecast on a table or chart, additional options have been added!

Depending on your chart or table, you can specify either triple exponential smoothing, linear regression algorithms, or automatic forecast. Our pro-tip is to use triple exponential smoothing when there are seasonal trends and patterns. Likewise, Linear Regression is recommended when the data follows one trend. You could also use “Automatic Forecast” or specify a type. The choice is yours!

Administration and Infrastructure

Assign users to teams based on SAML attributes

You can now automatically assign users to teams based on SAML attributes.

Additional resources:

**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