This blog covers some of the latest new features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2019.21. 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.248 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:
- Smart Assist: Smart Insights Enhancements
- Administration & Infrastructure: Assign copy privileges for files and folders
- Administration & Infrastructure: Export and import translated content along with the story
- Data Visualization: Restore Widget or Confirm Deletion
- Data Visualization: Dynamic Time Filter Improvements for Widgets
- Data Visualization: Recommended Comparisons based on Dynamic Time
- Data Visualization: More Readable Charts when No Data is Available
- Data Visualization: Display United Kingdom as a Drillable Hierarchy for Geo Maps
- Data Visualization: Reduce Data Label Collisions for Charts containing Lines
- Digital Boardroom: Reset & Refresh Topics from the Action Bar
- Analytics Designer: Adjust widget size and position within the Canvas page
- Analytics Designer: Iterate over result sets based on input data
- Analytics Designer: Export application to PDF
- Analytics Designer: Align widgets
- Analytics Designer: Custom Widget SDK
- Analytics Designer: Data Analyzer Enhancements
- Planning: Right click for Tables
- Planning: Set minimum node in Value Driver Tree (VDT)
- Planning: Story integration
- Planning: On hold status for tasks and processes
- Planning: New functions in Advanced Formulas
- Modeling: Option to delete dimension members
- Smart Predict: Live Connection to SAP HANA
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 >
This update brings a new UI to the panel which can display up to two types of insights simultaneously along with a brand-new “How has it changed?” insight, showing how the data point varies over time. We’ve also introduced new navigation with an expand or collapse option as well as a back button at the bottom of the panel. So, if you ask, “How has it changed?” with “it” being Smart Insights, the correct answer would be “a lot”!
Administrators can now assign copy privileges for files and folders in order to prevent users from cloning information and creating unauthorized derivative work. Disabling the copy rights will remove the “Save As…” button, as well as the copy feature for files and folders. Just make sure no one tells Darth Vader that he can disable clones now…
When importing and exporting a story from one tenant to another, the translated content will be transferred along with the story. This will make it much faster and easier to work with different teams from around the world, no matter what languages you speak! Ѐ fantastico!
Story designers will now have the ability to restore an accidentally deleted widget. The widget can be restored from a toast that will appear on the bottom of your screen. For more information please see the help section.
The new dynamic time filter UI is now directly available in your builder panel. Moreover, dynamic time offset within widget filters is also available. These offsets are the first steps towards dynamic time travel, which will be coming out in Q2 of 2020; contact your account rep and see how to advance your business forward by 50 years!
When the current period is selected in charts users will have the ability to create Recommended Comparisons based on dynamic time filters. The option to create Comparisons based on version and time will still be available, giving you more flexibility to quickly analyze your data exactly the way you want!
Administrators now have the option to choose from a preset group of specific messages within System Administration, to be displayed whenever no data is returned within a chart. The default messages will remain, unless an administrator makes a change. Moreover, story designers can now style these error messages from the styling panel to give it the look you want!
Heareth ye! heareth ye! the unit’d kingdom hast been add’d as a shapeth to the ch’ropleth lay’r combining the previous shapes of england, scotland, n’rth’rn ireland, and wales. Us’rs can still drill down into regions to showeth the four nations. Longeth liveth the queen!
Reduce data label collisions for charts containing lines
Line-based charts will display more data labels by prioritizing them based on their placement in the builder panel. If there are two dimension members/measures, the first member will be shifted to the left and the second to the right. When there are three members, the first will be centered, the second will be shifted left and the third will be shifted to the right. And if there are four or more members, the largest value will be shown in each of the three positions (ie: measures in rank 1,4,7… will compete for center position, those in rank 2,5,8… will compete for left position, and the measures in rank 3,6,9… will compete for right position).
Boardroom designers will have the option to enable the refresh and reset of topics through the action bar for Boardroom Presentations. This will allow you to quickly update your data and make sure the visualizations are as relevant as possible, as well as reset any filters you’ve created, right from the touch of a button!
Application designers can now set the layout of widgets as dynamic, ensuring that they adapt to different screen sizes and orientations. The position settings for widgets can include pixel-exact values, percentage values, or auto value, allowing you to customize how they are laid out. Several scripting APIs have been added as well, which can be seen below:
The result set APIs allow designers to iterate over a table or chart data-set and retrieve a result set based on the data selection of a table or chart. If the data selection parameter is empty, it will retrieve all the values of the initial data set, alternatively, if specified, it will retrieve the designated subset of the initial data-set. More information will be available in the help section.
Applications can now be exported to PDF. Note: Only visible parts will be exported; R widgets are disabled during export; custom widgets are not supported. In order to enable PDF export, it needs to be defined as a technical component in the application. The corresponding APIs are provided.
“Great [Analytical Applications] are not born great, they grow great…”
Don Corleone (The Godfather)
In Don’s honour, and to improve your work efficiency and design accuracy, you can now align the position of multiple widgets (such as charts, tables, images, text, etc.) when designing an analytic application. This should help ensure that your Analytical Application looks as dapper as Don while functioning as efficiently as Michael.
You can now create your own custom widgets with the SAP Analytics Cloud Custom Widget SDK, which will allow you to extend the predefined set of widgets provided by the Analytics Designer! For more information please visit the help section.
A host of new enhancements have arrived for Data Analyzer, extending its capabilities with a more powerful context menu, a better builder panel with navigation support, currency conversion, export to Excel and information on when the data was last updated. You might as well start singing Hakuna Matata because you’re about to have no worries for the rest of your days!*
*Only applies to days when you’ll be using Data Analyzer. Does not refer to any other worries including, but not limited to, worries caused by dog eating homework, computer deciding to update as soon as you start your online meeting, or your kid crying because you put butter on their toast after they specifically asked for butter on their toast…
The context menu options for tables are now extended by right clicking on a cell. These options include: copy, undo or redo data entry, and open history panel, among others. This should make your workflow feel more familiar and intuitive, making sure you can stay focused on the important tasks!
When you’re using longer node titles in a Value Driver Tree, you can set a minimum node width to ensure that they stay readable. This additional UI control will be accessible both in the VDT designer and the VDT widget, and if you wish to reduce the node width later on, we’ve included a free gym membership for all nodes bundled with your license so they can hit the treadmill!
When you’re working on a story that’s part of a calendar task, you no longer need to switch back and forth between the Calendar and the story. A new status bar has been added to the top of the task-connected story which shows calendar information when hovered over, along with a submit, reject, and more details button.
If the work on a task or process gets blocked, you’ll now be able to change the status to “On Hold”, which will then allow you to resume or discontinue the process. This allows for more accurate descriptions in the calendar, making it easier for planners to see how far along a project is, and whether any specific task might need more support.
This update brings a bunch of new functions for advanced formulas which are described below, however more details are available in the help section.
Day, month & year functions:
This function enables the ability to pick up the day/month/year information from a time period using the Day(), Month() and Year() functions, as well as the ability to calculate the number of days in time period using the DAYSINMONTH() or DAYSINYEAR() functions. These new time functions can be very helpful in breaking down salaries or amortizing costs over certain periods of time.
No, this function isn’t going to predict the percentage of dates you’ll have this year… It will, however, help you indicate the ratio of the start date to end date for a specific action.
This function carries forward account balances to the opening amount of the new periods, then it recalculates the account balances of the new periods based on the new opening amount. This improves on the current use case of FOREACH, bringing the response time up by 97%.
This function can be used to specify the hierarchy of one or more dimensions you will be working on throughout the entire script.
With this update, you’ll now be able to quickly and easily delete all members of an existing dimension in a model. I just want to mention to remember to save for retention the dimension members that you don’t want to dismember or submit to suspension in another dimension… Please don’t mind my incomprehension!
Smart Predict, just got smarter. You can now augment your business intelligence dashboards with Smart Predict insights, created on top of your live SAP HANA data.
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.