SAP
Image for

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:

Learn with our latest video tutorials

Planning

Keep Source and Overwrite Target

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.

Cross calculations for measure-based models

Seamlessly create Cross Calculations in your tables for measure-based models.

Display ID and description separately

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.

Pin Calendar to home

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.

Calendar task improvements

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.

View partially completed tasks

Derived from canceled and accomplished assignments, this new aggregated status allows you to see which tasks are only partially accomplished in the Calendar and for your input tasks.

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.

Modeling

Multiple date hierarchy dimension in acquired date models

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.

Data Integration

SQL driver improvements

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.

Import connection to OData 4.0

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.

Data import filtering enhancements

When selecting an import data source for a model, dimension, or story, you can more easily filter through the list of available sources. Get ready for over 100 data sources in 2019!

Combine data from multiple import sources

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.

BPC data import and export wizard improvements (updated Feb 19,2019)

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:

Workflow
Import and export processes are now done in a step-by-step wizard rather than in one dialog. 

Query
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.

Other

  • 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

For detailed steps about BPC data import and export, you can refer to Importing SAP BPC Data to a New or Existing Model or Exporting Data to SAP BPC.

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.

Smart Assist

Fiscal phrases in Search to Insight

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.

Greater or less than parameters in Search to Insight

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.

Data Visualizations

Export Story pages to Google Slides

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 in table titles

Dynamic text is supported in table titles. We’re working on delivering dynamic subtitles, scales and units in 2019!

Browser caching for Story and Boardroom

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.

Zoom ability for maps of China

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.

Live HANA 2.0: Display currency/unit and scale in numeric point charts

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.

Live HANA 2.0: Positioning of currency/scale based on corporate standards

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.

Live HANA 2.0: Convert measure into dimension and vice versa

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.

Live HANA 2.0: Convert numeric and string dimension

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.

Example:
Calculated Dimension 1: ToNumber(Age_String_Dimension)
Calculated Dimension 2: ToText(CD1) + “years”

 

Additional resources:

**Legal disclaimer
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.

 

Still have questions?

We’re always happy to help with any questions you may have.

Contact Support