This blog covers some of the latest new features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2020.07. 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.269 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.235 for SAP HANA view
- Version 1.0.91 for SAP Universe (UNX)
- Version 1.0.99 for SAP ERP / SQL databases
- Version 1.0.75 for all other data source types
For more information, see System Requirements and Technical Prerequisites.
Highlights of this release:
- Platform Services: Defining Prompt Value while scheduling a story
- Analytics Designer: New API to send a notification
- Analytics Designer: New APIs to move widgets
- Analytics Designer: New API to apply bookmarks at run time
- Analytics Designer: API DataSource.setDimensionFilter() supports range filters and exclude filters
- Analytics Designer: New APIs for SAP BW models
- Analytics Designer: New API to improve the existing read access to OData services
- Planning: Show Units and Scale in cell
- Planning: Create validation rules to define valid ranges of data
- Planning: Calendar Integration for Reviewer in Story
- Planning: Open the data locking editor from a Data Locking Task
- Data Visualization: User-defined hierarchies with custom shape files in the geo choropleth layer on SAP BW
- Data Visualization: Custom sort for dimension members in SAP BW
- Data Visualization: Display Measure Values in the Bubble Layer of a Geo Map
- Data Visualization: Enhanced Number Format Capabilities for Geo Maps
- Data Visualization: Input Controls Search Improvements
- Administration & Infrastructure: Manage Team-specific Folders
- Administration & Infrastructure: Quicker Access to Content from the Home Page
- Administration & Infrastructure: Publish Content for All Users
- Data Integration: Support for more Open Connectors data sources
- Data Integration: Remove Duplicate Rows
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 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.
When creating or editing a “Schedule Publication” for stories based on SAP BW and HANA data models, you can now define prompt values. In this way, you can share different views with different prompt values for your story with the same or a new set of recipients, increasing the shareability.
Application developers can now use the Application.sendNotification() API to send a notification when an analytic application is running on the backend, i.e. scheduling. You can use scripting capabilities to configure the notification. Users can receive the notification via email or the notification panel. A maximum of three notifications can be sent per scheduling job.
Application developers can now decide to move widgets or containers dynamically to other containers at application runtime to cover dynamic layout scenarios.
Supported container widgets are canvas, panel or tab strip.
Provided scripting APIs:
Application developers can now use the BookmarkSet.apply() API to load/apply bookmarks at run time. This scripting API needs to be related to the technical component of a bookmark, Bookmark Set. This new feature lets designers load bookmarks more conveniently.
The included widgets within the bookmark definition will be reloaded. The status of non-included widgets within the bookmark definition will be kept.
Application developers can now use the scripting API DataSource.setDimensionFilter() to support:
- Range filters
- Excluding members with single and multiple filter values
Application developers can use the following scripting APIs for SAP BW models in the table widget:
- Table.isZeroSuppressionEnabled() table axis.
This allows application designers to customize the table design. For example, when a user wants to open a chart in a popup / fullscreen container, the application developer can move the table to that popup / fullscreen container directly – with all the interaction states kept.
You can now use the API getEntitiesCountFromEntitySet to improve the existing read access to OData services by enabling the OData system query options for “filter”, “orderby”, “select”, “count”, “top”, and “skip”.
The new API works like the getEntitiesFromEntitySet API but returns the count instead of an entity list.
Using the styling panel, story designers can decide where units and scale should be shown in the table. You can format it at the cell level to increase visibility. You can choose to display units and scale in:
In planning models, you can now create validation rules to establish relationships of members across different dimensions to restrict planned data entry. For example, you may want to restrict planning to only a few products in a given geography. With this capability, you can set relationships based on attributes to enforce this type of restriction.
When you’re reviewing a story that’s part of a calendar task, you can access it through the new status bar, which is located on the top of the task-connected story. It also shows calendar information when hovered over, together with Submit, Reject, and Details buttons. This update saves you unnecessary clicks to switch back and forth between the Calendar and the story.
You can now easily open the Data Locking editor in read-only mode from a Data Locking Task. The context of the task is applied to the editor as driving dimensions so you can see the current lock state for your task.
For SAP BW, you can now consume user-defined hierarchies with custom shape files in the geo choropleth layer. It allows you to drill down to a specific level. For example, you can access level two with one click.
You can now set up a custom sort for dimension members in tables, visualizations and Explorer. Flat list and Hierarchy are sorted only within the same hierarchy level and Characteristic Structures. This can be shared between the same model within the same story.
Now you have the ability to show measure values in the bubble layer of a Geo Map. You can choose to display the color, size, or measure values.
We have enhanced our number formatting styling capabilities, so you can adjust the scale, scale format, and decimals when working on geo maps. All values also update in tooltips, even when they’re hidden.
You can now search for members with certain patterns in input controls.
Note that this feature works only for searches of existing members of the dimension. New members are not automatically reselected. It is available for Acquired and HANA Live models only, and not supported for Hierarchies.
You can now manage team-specific folders the same way you can manage other folders. This addition gives admins more control over the Team folders, including being able to rename and delete them, improving file repository organization.
The Home page now includes the following features to let users and teams quickly discover and access important content:
- A Favorites tab dedicated to all the content you have designated as “Favorites”
- A Shared with Me tab listing all the content that has been shared with you by other users
Note that this feature is disabled by default, and tenant admins can turn it on via the administration settings.
The ability to publish to “All Users” has been added to the Publish To Catalog dialogue box. This allows you to publish content to all current and future users of an SAP Analytics Cloud system.
We now support more data sources via SAP Open Connectors: Autotask CRM, Close, ConnectWise CRM, Infusionsoft CRM, Insightly, and Box. Users can acquire data from one of these sources and create a model based on imported data. Note that the users must be on a Cloud Foundry tenant and have the Open Connectors account.
Duplicate rows in the dataset can be removed while creating a public model. You can find the option “Remove duplicate rows” in the Actions tab. Initially, the duplicates are removed from the sample. Once the “Create Model” button is clicked, the duplicate rows are removed from the entire dataset. This helps you keep your dataset lean and clean.
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.