This blog covers some of the latest features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2020.17. 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.289 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.233 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:
- Data Visualization: Simulation for Agile BI
- Smart Assist: Improved Search to Insight Autocomplete Suggestions
- Smart Assist: Chart Interactions in Search to Insight
- Smart Assist: Re-pointing an Acquired “Identical” Model in a Story
- Add-in for Microsoft Office: New features in Add-in for Microsoft Office
- Add-in for Microsoft Office: Availability on Windows Desktop App
- Planning: New Enhancements to the Calendar with the List View
- Modeling: Add or Remove Dimensions for Models with Private Version
- Analytics Designer: Viewing Custom Messages of Scheduled Tasks
- Analytics Designer: Switch Widget
- Platform Services: Scheduling a Story in PowerPoint File Format
- Data Integration: Deduplication Transform
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.
SAP Analytics Cloud users can now quickly simulate different scenarios by creating private simulations on data uploaded from Excel. Basic simulation features such as entering values, copying and pasting, and undoing or redoing changes are available. This allows you to simulate the impact of different strategic changes on business outcomes so you can gain valuable insights on the fly.
In SAP Analytics Cloud, we’ve streamlined the search suggestion experience. Now, Search to Insight will automatically group matching measures and dimensions (that are found in multiple models) into the same search suggestion. Additionally, the measures and dimensions that are suggested are now ranked based on the frequency that they are used in Stories.
In SAP Analytics Cloud, you can now directly interact with your search results from Search to Insight. This provides the following benefits:
- Quickly answer follow up questions. For example, by drilling on a dimension member
- Efficiently filter or exclude dimension members that aren’t your focus
- Easily export your search results to Excel
Within Data View, you can now replace any acquired model in your story with another acquired model that has the same structure, saving you time and effort. Replacing the model also preserves the configuration of all widgets in your story.
Add-in for Microsoft Office
Great news! We have a handful of new features for the SAP Analytics Cloud, Add-in for Microsoft Office. These enhancements include:
1. The ability to log off from your SAP Analytics Cloud Tenant
2. Removing tables within your workbook
3. With one click, swapping axis allows you to move all dimensions (including Account / Measure structure) in the Rows axis to the Columns axis and vice versa.
You’ve asked, and we’ve listened! The SAP Analytics Cloud, Add-in for Microsoft Office will now support your application version of Microsoft Excel on your Windows desktop. Now, you can leverage the best of the Microsoft Excel interface with the planning and analytic benefits of SAP Analytics Cloud right on your Windows desktop application.
Collaboration is a huge part of the planning and analysis process. That’s why we are introducing the “List View.” Now, you can monitor and manage your calendar events with greater efficiency with “List View.” You can now easily toggle between List, calendar, and Gantt chart to provide an overview of your planning processes.
This next enhancement will help you simplify model maintenance. For models with private versions, you can now add or remove dimensions. Upon deleting dimensions, a warning message will let you know what dependencies will be impacted.
As an analytic application user, you can now view user-defined warning and error messages of your scheduled publication tasks in the Calendar, using the available script API: Scheduling.logMessage(messageType, messageText).
Application designers can now design a switch widget to allow application users to tap the switch and change the state to “on” or “off,” providing a more user-friendly experience. The application developer can configure the following properties:
· Background color
· Button handle color
· Boarder color
· Size, position
Provided script API:
For all you PowerPoint users, you’ll be excited for this next feature. In SAP Analytics Cloud, the PowerPoint presentation, .pptx format, will now be supported as a file type while scheduling a story. This way, you can send your data visualizations in a PowerPoint format, so your end-user can easily integrate the slide in future presentations.
We understand that data wrangling can be a tedious process. With SAP Analytics Cloud, one of our main objectives is to alleviate some of the common challenges that accompany the data wrangling process. That is why we are excited to introduce the new Remove duplicate rows transform. This feature allows you to remove all duplicate rows across all columns in a dataset. Once you’ve deleted the duplicate rows from the sample, you’ll be able to see the total number of rows that were removed. Preparing your data is now easier than ever.
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.