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:
- General Updates: Multilingual content support
- Modelling: Quartile exception aggregation type support
- Planning: Dynamically select leaves for a hierarchy
- Planning: Data locking task in Calendar mode
- Planning: Generate tasks or processes with the Calendar wizard
- Planning: Parameters for data actions and advanced formulas
- Planning: Attribute function
- Planning: Performance enhancements in advanced formulas
- Planning: Visual formula enhancements
- Intelligent Enterprise: Enable currency conversions during SAP BW remote connections
- Intelligent Enterprise: Hierarchy geo map visualizations for SAP BW
- Intelligent Enterprise: Tuple filters for charts and tables when drilling down
- Data Visualization: Dynamic text for any dimension
- Data Visualization: Stacked bar chart without dimension axis
- Data Visualization: Input controls for multiple cross calculations for tables
- Data Visualization: Explorer in Embedded mode
- Data Visualization: Performance improvement for clustered geo map
- Data Visualization: New default for story & page time range filters
- Mobile: Support for featured content
- Analytics Designer: Set widget size and position according to application logic and canvas size
- Analytics Designer: Define theme
- Analytics Designer: Panel widget
- Analytics Designer: Data analyzer
- Data Integration: Import data from Egnyte, Amazon S3, Dropbox and OneDrive
- Data Integration: Replicating data from SAP HANA
- Data Integration: Import data file size improvements
- Data Integration: Data export improvements
- Administration & Infrastructure: Users’ API provisioning enhancements
- Administration & Infrastructure: Two-legged OAuth Support
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
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!
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.
For all non-account dimensions, you can now dynamically select to display only the leaves for the selected hierarchy.
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.
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.
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.
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 😉.
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.
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!
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…
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.
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.
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.
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!
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!
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.
Unnecessary legend information in clustered geo maps will no longer be displayed, allowing for load times faster than a race between two Concordes.
To save you time, dynamic time is the new default option for Story & Page time range filters.
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!
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…
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.
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!
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.
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!
- 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
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!
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
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!”
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.