This blog covers some of the latest new features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2019.01. 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.211 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.91 for SAP Universe (UNX)
- Version 1.0.109 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:
- Planning: Keep Source, Overwrite Target
- Planning: Inverse formula suggestions
- Planning: Cross calculations for measure-based models
- Planning: Display ID and description separately
- Planning: Pin Calendar to home
- Planning: Calendar task improvements
- Planning: View partially completed tasks
- Planning: Advanced formula improvements
- Modeling: Multiple date hierarchy dimensions in acquired date models
- Data Integration: SQL driver improvements
- Data Integration: Import connection to OData 4.0
- Data Integration: Data import filtering enhancements
- Data Integration: Combine data from multiple import sources
- Data Integration: BPC data import and export wizard improvements (updated Feb 19, 2019)
- Smart Assist: Fiscal phrases in Search to Insight
- Smart Assist: Greater or less than parameters in Search to Insight
- Data Visualizations: Export Story pages to Google Slides
- Data Visualizations: Dynamic text in table titles
- Data Visualizations: Browser caching for Story and Boardroom
- Data Visualizations: Zoom ability for maps of China
- Data Visualizations: Live HANA 2.0 – Display currency/unit and scale in numeric point charts
- Data Visualizations: Live HANA 2.0 – Positioning of currency/scale based on corporate standards
- Data Visualizations: Live HANA 2.0 – Convert measure into dimension and vice versa
- Data Visualizations: Live HANA 2.0 – Convert numeric and string dimension
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 >
Keep Source: Source values that are allocated to the targets aren’t eliminated and duplication takes place instead.
Overwrite Target: Possible targets are cleared before allocating the source values and possible values are defined by the rules. If a rule is defined but the corresponding reference values are 0, targets can be cleared without getting a new value allocated.
Inverse formula suggestions
Don’t you love it when your friends can finish your sentences? Now when you start to type an inverse formula, you can easily complete your formula with a suggested inverse formula from the hint list.
Seamlessly create Cross Calculations in your tables for measure-based models.
We’re a big fan of data granularity! Now you can display the ID and Description in separate fields for tables. This also works for both analytic and remote models.
Counting down the days until the weekend? Take advantage of this new feature and pin your Calendar to the home screen! With this layout, the home screen can include a Calendar tile for easy access. You can quickly view which of your tasks will be overdue and due soon.
Please note that the tasks shown can span from the past three weeks to one month forward and can currently show three tasks on default.
Managing a big team? No worries! You can easily handle many assignees of Calendar tasks with this new dialogue viewing feature. If you have 10 or more team members, they will be displayed in a list and the assignees are grouped by status.
Advanced formula improvements
Pulling data together from different versions is now easier with this advanced formula improvement. With the new RESULTLOOKUP function, you can define the version dimension to read data from another version.
We are also introducing the DELETE function to support delete data facts in a model.
You can now have multiple date hierarchy dimensions in import data models. This feature is available today for analytic models and is expected to be available in planning models soon.
For an analytic model, the Date dimension is optional. However, you are free to specify several date dimensions at any granularity level.
When you initially import raw data, it may include many rows and columns which should be cleaned. Assigning date dimension types to the data columns is now available within this process as well as when you are creating models with multiple date dimensions from scratch.
As part as our hybrid strategy, we have introduced the ability to connect to all 104 JDBC drivers supported by SAP BusinessObjects Enterprise 4.2 SP5. The query interface will be a query panel and/or freehand SQL depending on the data source. SAP Analytics Cloud also supports a generic JDBC driver for all other SQL sources. Queries against generic sources are supported using MySQL as a reference database.
You can now create a generic OData import data connection to OData V4 sources. Connection creation and query workflows are the same as OData V2. Oauth support for OData V4 is planned to be available soon.
Gather all your data in one place. When wrangling data, you can create a model from sequentially merged multiple queries. This includes an upfront summary of the combined dataset and shows a data sample preview with the representative rows. Please note that this is currently focused on left outer and inner joins.
With this feature, you can also combine transformations. If you want to undo a transformation, you must first undo the combined transformation prior to removing the transformation before the “combine” action.
Please note that this supports up to 5 datasets and 30 million cells.
To better guide you, and to keep a consistent look and feel with other data sources, we have changed the entire BPC import and export process.
The major changes are as follows:
Import and export processes are now done in a step-by-step wizard rather than in one dialog.
In the new import process, we separate the selection of dimensions and filtering of dimension members from dimension mapping.
Previously you specify BPC dimensions and filter dimension members to be imported in the Mappingdialog. Now, we offer a dedicate step Build SAP BPC Query to do the selection and filtering.
In the new import process, you can choose whether you want to build a new BPC query starting from scratch or reuse an existing query derived from the previous import jobs as a template.
- In the new import process, when importing data to a basic model, you can create dimensions as either public or private dimensions.
- A brand new mapping dialog is available. In addition to dimension mapping, you can also configure the currency dimension (where the local currency is taken from) in the mapping dialog.
Scheduling has a number of new enhancements including:
- Support for import settings
- Multiple jobs can be grouped in one schedule with dependencies
- Scheduling is supported for both import and export
- Scheduled notifications
Also, before importing data to SAP Analytics Cloud, make sure you check the minimum BPC support package for import and apply all required notes specified in System Requirements and Technical Prerequisites.
Please note that in general, the new BPC connector performs better than the XSJS BPC connector.
Needing to be more specific when preparing financial statements or accounting records? With this feature, Search to Insight now understands fiscal phrases!
Please note that the fiscal year offset will always apply to the time input. For example, if the phrase is to, “Show sales for this fiscal year,” it will only show the result with the fiscal year offset applied. If you don’t specify the fiscal year, such as in the phrase, “Show sales for January 2017,” then it will just show calendar year results instead. This also supports quarterly granularity!
It ultimately depends on you to decide whether the fiscal year offset should be applied. General phrases such as, “Show sales for 2017” will show the calendar year or the fiscal year results based on the default hierarchy set in the model.
You can now specify measure refinements such as greater or less than. Just follow this simple structure of: “Show [measure] by [dimension] where [measure] is [range].”
For example, you can ask the phrase “Show me regions with revenue greater than 100000000 in salary”, or “Show me products with cost of product below 10000000 for 2017”.
We plan to support numbers with commas (e.g. 10,000) next year.
Want to share your dashboard in a presentation? You can now do this by exporting your Stories into Google Slides. Each page of a Story will be exported as a slide image. There is a onetime process to select your Google Drive account and authorize access to SAP Analytics Cloud.
Google Drive credentials will not be shared between users, and exported content will not be available to others unless expressly granted within Google Drive.
SAP Analytics Cloud administrators can govern who can export Stories to Google Drive by sharing the Google export connection with them. You can export up to 12 pages per Story.
Please note that exported pages will have to be within the Google Drive size limits in terms of number of cells and canvas size, and geo maps are currently not yet supported.
For more resources, please view the following help links:
Dynamic text is supported in table titles. We’re working on delivering dynamic subtitles, scales and units in 2019!
With this new improvement, you will be able to load your stories and Boardrooms faster!
SAP Analytics Cloud now supports client-side browser caching of Stories, Boardroom definitions and model metadata.
The cache is stored in Google Chrome if there are no structural changes made on the story and boardroom. The performance improvements scale up as the stories get larger, the more models are used, and the more widgets are on the page.
Please note the following features below for HANA 2.0 require versions 2.00.034.00 (EPMMDS 1.00.201822.00), 2.00.024.06 (EPMMDS 1.00.201822.00) or above.
Administrators for SAP Analytics Cloud subscriptions provisioned out of China can now remove the zoom limit to enhance geo accuracy down to the street level.
Story Designers now have the option to show the currency/unit and scale alongside the data in numeric point charts rather than just in the subtitle.
Forced to adhere to your corporate standards? With this feature, Story Designers will be able to select how currency will be positioned, such as 30$ vs. $30. This can be reflected in charts, tables and tooltips. Tenant configuration offers an option to display the currency as symbols or ISO codes, though keep in mind that the profile settings will override tenant configuration.
Convert a measure into a dimension through the measure-based calculated dimension. Scale and decimal places must be defined as part of the calculated dimension.
As well, you can also convert a numeric dimension stored as type string into a measure through the convenience method or calculation editor. Non-numeric dimension members will return empty values.
With the ToNumber formula, you can now convert a string dimension into a numeric dimension. Conversely, the TwoText formula will be able to do the opposite: convert numeric to a string dimension. You can convert a number to a string prior to concatenating with other strings.
Calculated Dimension 1: ToNumber(Age_String_Dimension)
Calculated Dimension 2: ToText(CD1) + “years”
- Video tutorials
- Guided learning
- Events and recordings
- SAP Analytics Cloud help resources
- Official roadmap contains more info on future plans, subject to change.
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.