This blog covers some of the latest features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2020.23. 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.301 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.99 for SAP ERP / SQL databases
- Version 1.0.235 for SAP HANA view
- Version 1.0.91 for SAP Universe (UNX)
- Version 1.0.248 for SAP Business Warehouse (BW)
- 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: Customize Smart Insights Top Contributor Results
- Smart Assist: Define the Context of Your Business Question in Smart Discovery
- Planning: Support the Conversion of Text Script to Visual Formula
- Add-in for Microsoft Office: Get Help in the SAP Analytics Cloud Ribbon
- Add-in for Microsoft Office: Support for Automatic Mass Data Entry Mode
- Mobile: Android App Now Supports Default Server URL Configuration Pushed through Microsoft InTune
- Data Integration: New Custom Transformations in the Wrangling Expression Language (WEL)
- General: Renaming “External Content” to “Content Link”
This blog provides a high-level overview of the latest features in SAP Analytics Cloud. If you're looking to get more information about these features, please visit the help documentation here.
Gone are the days of sifting through Smart Insights results to find relevant dimensions. Now, through the Smart Insights panel, story designers can customize Smart Insights top contributor results by excluding unwanted dimensions. This way, if a user excludes a dimension, no dimension member for said dimension will be shown as a top contributor, ensuring that results are as relevant as possible to the business context. Excluded dimensions are then hidden from users’ top contributor results for the lifetime of their story or until they wish to undo the action and include them again.
Smart Discovery now helps you explore your data more effectively by letting you clearly define the context of the business question you want to ask. As well as choosing a measure or dimension as a target, you can now also select an entity, which consists of one or more dimensions.
The entity defines the level at which Smart Discovery will aggregate your data so that it can be analyzed in relation to the target. For example, if you want to explore revenue by customer, you can select ‘Revenue’ as the target and ‘customer’ as the entity. In contrast, if you wanted to understand revenue by product, you could select ‘Product’ as the entity instead.
To access a brief summary of the data selected prior to running Smart Discovery, users can open a Preview dialog. Here, you can find enhancements to the content and presentation of the analysis results generated by Smart Discovery through new heuristics that display charts that are more meaningful and easy to consume.
Now, users are empowered to explore their data in relation to a specific context and entity without the need for any additional data preparation. This way, users can analyze the same target in relation to different entities and get different results that reflect the specific question being asked in a way that is easier to digest.
Through Visual Formulas, we aim to make advanced enterprise planning universal. With this new enhancement to our Visual Formulas feature, Planning users can convert text scripts into their visual counterparts within advanced formulas for Data Actions. As a result, users are able to quickly switch editing modes to fine tune calculations and leverage all the benefits from text scripts and visual formulas alike. Please note that some text script syntaxes are not supported by the visual tool and will thereby be displayed as ‘read-only.’ New text script syntaxes have also been introduced for Block comment (/* */) and Visual Formulas Annotation (/*! */).
Within the SAP Analytics Cloud Ribbon in Microsoft Excel, users can benefit from a Help button, providing direct access to our SAP Help Portal. Here, users can find information related to what’s new in SAP Analytics Cloud, how to get started, FAQs related to troubleshooting, and more.
Furthermore, Mass Data Entry Mode is now the default for SAP Analytics Cloud’s Microsoft Office add-in. This mode is Excel-optimized, making for a simpler, more intuitive user experience.
Great news! Our Android app now supports the default server URL configuration to be pushed through Microsoft InTune. This means that Administrators can preconfigure the tenant URL such that users no longer need to manually add it in, allowing for a more simplified user experience. Please note that the app currently only supports Microsoft InTune mobile device management (MDM) and that only single URLs can be preconfigured.
By accessing the WEL through the Custom Expression Editor, you can transform your data with new custom expressions and model your dataset based on your exact needs. The delivery of this new set of custom transformations is geared towards grouping values together and includes the following expressions:
- Filter your values for further analysis using the "startsWith" and "endsWith" expression, which search for values starting or ending with a specific string value.
- Count the number of words within the cells in a given column using "countWords".
- Group the records based on numeric values into bins:
- Use binByBinWidth to group records of a column into bins of equal width.
- Use binByBinCount to specify the number of equal-width bins you need and distribute the data in those bins.
- Use binByTileCount to distribute the data points equally by bins.
- Use binByStandardDeviation to get bins based on standard deviation from the mean.
This means that users who are familiar with the WEL can now segment specific columns regardless of whether variables are numeric or string (containing non-numeric values such as letters and other characters).
The object type “External Content” is used to provide URLs to content located outside of SAP Analytics Cloud. The term has now been renamed “Content Link” to remove the confusion surrounding the word “External,” especially while viewing filters in the Catalog.
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.