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
Highlights of this release:
- Intelligent Enterprise: Time series chart for live SAP BW
- Intelligent Enterprise: HTTP/2 support for SAP BW
- Mobile: Mobile SDK update
- Mobile: Switch server
- Mobile: Jump-to navigation in Digital Boardroom presentations
- Data Visualizations: Custom sort of dimension members in tables
- Data Visualizations: Display images from live HANA 2.0
- Data Visualizations: Exposing model prompts in the story filter bar
- Data Visualizations: Delay cascading filters
- Data Visualizations: Waterfall charts – Show totals before or after children
- Data Visualizations: Waterfall charts – Show/hide root node of a hierarchy
- Data Visualizations: Waterfall charts – Show breakdown values as delta/actual
- Data Visualizations: Add table show/hide menu items to Explorer
- Data Visualizations: Convert measures into dimensions and vice versa
- Data Visualizations: Convert numeric and string dimensions
- Data Visualizations: Additional exception aggregations in stories
- Smart Assist: Forecast improvements
- Administration and Infrastructure: Assign users to teams based on SAML attributes
Learn with our latest video tutorials
- Create a model from SuccessFactors Workforce Analytics
- Apply filters to a chart in a story
- Apply filters to a geo map in a story
- Full tutorial playlist >
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 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!
The latest SAP Analytics Cloud iOS SDK now requires Xcode 10.x to open and compile the application.
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.
Please note that Jump-to navigation from pages aren’t yet supported.
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.
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.
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.
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.
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.
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.
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.
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 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.
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.
You can enable Exception Aggregations available in Modeler within your story.
- Count Excluding Null
- Count Excluding 0 and Null
- Average Excluding Null
- Average Excluding 0 and Null
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
You can now automatically assign users to teams based on SAML attributes.
- Video tutorials
- Guided learning
- Events and recordings
- SAP Analytics Cloud help resources
- Official roadmap contains more info on future plans, subject to change.
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.