This blog covers some of the latest features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2020.13. 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.279 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.75 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: String Functions in Calculated Dimensions
- Data Visualization: Data Labels with Background Colour and Opacity
- Data Visualization: Display Values for Mixed Periods in Previous Period Time Calculations
- Data Visualization: BW: Paste Filter Values in Story and Page Input Controls
- Smart Assist: Synonyms for Measures and Dimensions in Search to Insight Questions
- Planning: Transforming a Legacy Value Driver Tree
- Planning: Work Files Handling Made Easy
- Collaboration: Commenting Widget
- Analytics Designer: New API openNavigationPanel()
- Analytics Designer: Shake and Long Press Gesture
- Analytics Designer: Save & Leave
- Analytics Designer: New API getVariableValues()
- Analytics Designer: New API getDimensionFilters()
- Analytics Designer: Planning Model Extension
- Data Integration: Acquire Data from SAP HANA using an SSL Connection
- Platform Services: Schedule Story or Analytic Application based on SAP HANA 2.0 Live Data Connection
- Administration & Infrastructure: Define Default Tab
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.
Great news! We have introduced the following new functions in calculated dimensions to provide you with more flexibility to manipulate strings at the story level instead of planning to do the changes at the data source level. The functions specially help when you want to do ad-hoc analysis and analyze your data. Please note that these functions are only supported for models based on acquired or live HANA connections.
- SPLIT: You can now use the SPLIT function to return a substring from a string, using a delimiter character to divide the string into a sequence of tokens. An example would be if you want to split your customers’ first names and last names with a comma.
- FINDINDEX: The FINDINDEX function searches for substring and returns its start index with 0 as a default. The function will return -1 if the target is not found.
- ENDSWITH: The ENDSWITH function returns “True” if the given string ends with the user’s mentioned substring. This function does not ignore trailing white spaces.
- RIGHT and LEFT: The RIGHT function returns the specified number of characters from the end of the given string. The LEFT function returns the specified number of characters from the start of the given string.
Have you ever created a chart and the data label was difficult to read? We have a new customization feature that will enhance the readability of your data labels. Now, you can choose the background color and opacity for your data labels. Please note that this feature does not support Cluster Bubbles, Bullet & Numeric Point Charts, and in conjunction with Web Fonts.
We have made an enhancement to the Previous Period Time Calculation. Now, story designers have the flexibility to show all values in widgets containing different hierarchy levels such as year, quarter, and months in Previous Period Time Calculations. This new capability can provide you with more holistic view when analyzing your data.
Both story viewers and designers can now make changes to story and page filter selections faster, especially when working with a large list of values. You can now simply copy and paste filter values into the input control to either overwrite or append the existing selection when working with BW models.
Power users can now define synonyms for measure and dimension names, which they can then easily search for in Search to Insight. The synonyms created will appear in the Search to Insight autosuggestions along with other measures and dimensions. Under System, you can access the synonyms dictionary, which lists all the definitions of synonyms used for dimension and measure names independent of a model. This new enhancement will allow provide you with more customization when searching for your answers, allowing you to ask questions in a more business-like language.
A few waves back, we announced the new Value Driver Tree widget that can be added directly into your stories. This widget contains many amazing capabilities such as the ability to leverage story calculations, to collapse and expand branches of the Value Driver Tree, to utilize more granular time scales, and several other capabilities. With this release, we are now allowing you to easily transform your legacy Value Driver Trees into a Value Driver Tree widget. This feature will save you time and effort since you don’t need to completely remodel the Value Driver Trees to gain the benefits that the new story-based Vale Driver Trees provide.
For calendar tasks and processes, we have redesigned the header section in the Builder panel to provide a streamlined experience for accessing all relevant information. This update includes:
- Work files: A huge part of this redesign is that you can now find all the work files of a task or process in the header section, which are displayed as separate tokens.
- Add URL links as work files to your tasks: In addition to stories and analytic applications, you can add URL links as work files to your tasks or processes.
- Links that will instantly take you to a desired section in the Builder panel: Here, you can view relevant information in greater detail.
It isn’t a well-kept secret that collaboration is key to any business’ success. This new collaboration feature was designed to help you and your teammates seamlessly collaborate when analyzing stories. The new Commenting widget allows you to contextually add comments based on a specific data model directly in your story page. A highlight of this new widget is that you can add comments on different filter combinations in your story, providing other users with the most relevant comments regarding specific contexts.
The Navigation Panel for tables is now available in the Analytics Designer. This enhancement provides users with a convenient way to analyze their underlying data models. With the Navigation Panel, users can perform the following actions at application runtime:
- Add/remove dimensions and measures
- Swap axis /Arrange Totals
- Display dimensions in key/text representation
- Select Hierarchies/Properties
- Compact Display/Suppress Zeros (for BW)
To open or close this panel, you can use the following new APIs:
- Available items panel can be opened via the optional parameter.
We have an exciting enhancement that will provide a more mobile user-friendly way to consume analytic applications on your iPad device. We are introducing the following mobile specific gestures for analytic applications running on a native safari browser on the iPad:
- Shake event
- LongPress event for Button, Shape, and Image widgets
- onOrientationChange event
When exiting an analytic application that has not been saved, there will now be a new “Save & Leave” dialog. This dialog will ask you whether you want to save your progress before exiting. This ensures you don’t accidentally exit and lose all your unsaved changes that you have made to your application.
You can now use the new API getVariableValues() to return an array of the current values of a specified variable. With this new API, you can transfer those returned variable values to other widgets, applications and stories, providing you with more flexibility to add interactivity between widgets or within your applications and stories.
You can now use the new API getDimensionFilters() to return an array of the current filter values of a specific dimension, also providing you with more flexibility when adding interactivity between widgets or within applications and stories. This new API supports single filter values, multi filter values, and range values.
Did someone say more flexibility when designing planning interfaces? You heard right. The Planning Model API has been extended, meaning you can now read and change a dimension member‘s data locking owner and responsible person.
With SAP Analytics Cloud, security is at the top of our agendas. We are introducing a new option to configure an SSL connection when connecting to SAP HANA from SAP Analytics Cloud. This adds a higher level of security when you’re connecting to SAP HANA on-premise.
For those who are using a HANA 2.0 live data connection, we have a fantastic update for you. You can now schedule a Story or Analytic Application based on SAP HANA 2.0 live data connections, increasing the scope for sharing your stories and analytic applications with your teams and stakeholders. When creating or editing a Schedule Publication for your stories based on SAP HANA 2.0 Live Models, you will also be able to define and edit prompt values.
Administration & Infrastructure
With SAP Analytics Cloud, one of our goals is to ensure you can easily access the content you need. This new feature will help you do just that. On the SAP Analytics Cloud home page, administrators can now define a default tab by going to System > Administration or by clicking the Edit Home Screen button. Your individual users can also navigate to the Edit Home Screen dialog and define their own default tab. Please note that if all tabs are disabled, then this option will be hidden in the Edit Home Screen dialog and disabled in the Default Appearance tab.
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.