Skip to Content

This blog covers some of the latest new features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2018.11. 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.107 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 all other data source types
  • Version 1.0.109 for SAP Business Warehouse (BW)
  • Version 1.0.91 for SAP Universe (UNX)
  • Version 1.0.99 for SAP ERP / SQL databases

For more information, see System Requirements and Technical Prerequisites.

Highlights of this release:

Learn with our latest video tutorials:

Planning

Improvements to editing public versions

Gone are the days of going back and forth when editing public versions. You can now use the main menu to publish or revert your changes instead of entering the version management panel. We’ve introduced a specific “Publish Data” button on the toolbar which will bring up a list of versions in edit mode where you can publish or revert the state for these versions.

Learn more about editing public versions here.

Workflow status

Tracking the status of your input tasks is simple.  As a task owner, you can view the workflow status of your input task in hierarchical form.  You can see an overall view of the status state for the participants nodes, or see the specific details and state by node and assignee.

Learn more about working with assigned input tasks here.

Adding new dimension improvements

We’ve made your financial planning even easier. You no longer need to use the “unbooked” setting when adding new dimension members to your table. With our new update, members-on-the-fly are virtual members which behave like front-end calculations.

Here is more information on creating new dimension members in a table.

Thresholds for calculated rows or columns

Let your inner artist thrive! You can now create thresholds based on calculated rows or columns. A threshold panel gives you the opportunity to define the thresholds and set symbols as well as colors for the grid.

Learn more about using thresholds in charts and tables.

Manage processes and tasks with the calendar

We’ve redesigned the calendar feature to make consolidated plan management and tracking much easier. You can now group and relate planning activities by creating a hierarchy of processes, and incorporating individual tasks as discrete work activities for any specific process: i.e. leaf members to a given process. Improved status handling via aggregation allows participants to have a better view of their work. Additional enhancements include the ability to color code processes and tasks to further differentiate them. 

Data Integration

GUID data blending options with the generic OData driver

The data import connector for generic OData has been further enhanced to allow the import of GUID data types, provided it is exposed by the underlying OData service. The imported GUID data types can then be leveraged within SAP Analytics Cloud for data blending or advanced linked analysis use cases where the unique identifiers can be used.

Find out how to import OData services data to a new or existing model here.

S/4HANA_Cloud_export

You can now directly export an SAP Analytics Cloud model to S/4HANA Cloud via the export workflow.

For financial planning scenarios with S/4HANA Cloud, you can now push SAP Analytics Cloud data back into S/4HANA Cloud. This scenario allows the user to map the SAP Analytics Cloud planning model dimensions to the S/4HANA Cloud ACDOCP table.

Digital Boardroom

Set an advanced filter for a topic

As a content creator, you can define an advanced filter for topics. Seamlessly view and change the advanced filters during your presentations.

Learn more about advanced filtering.

Cross topic navigation with filter context

Set a chart or table to use the data point selected as a filter in the navigation panel. Easily select a value on a chart or table to jump to a topic once you apply the value as a story filter.

Intelligent enterprise

3rd Party Business Content

Oh rats! We forgot to tell you about a fantastic feature introduced in Release 10! As part of our new Intelligent Enterprise Ecosystem, we’ve opened the business content repository to our partners!

Check out the new 3rd Party Business Content in the Content Library.

Infrastructure

Dynamic user creation for SAP Analytics Hub

We’ve streamlined the process for creating an SAP Analytics Hub account. We’re dynamically creating user accounts for both SAP Analytics Cloud and SAP Analytics Hub users who have valid SAML accounts.

Prerequisites:

  • Configure SAP Analytics Cloud for custom SAML authentication with “Dynamic User Creation” enabled
  • Set one of the predefined SAP Analytics Hub roles as a default role in SAP Analytics Cloud or use a custom role based on the SAP Analytics Hub license

 

Data Analysis, Stories and Tables

Compound Growth Rate for time based charts

You can now add a Compound Growth Rate (CGR) for bar/column and stacked bar/column charts with a time dimension.  

We’re still perfecting this feature so please note that this is for one measure scenarios with single versions. Also, integrated variance types, and live Universe and BW connections are not yet supported.

Length Calculation

You can now create a length calculation for string values with import data connections. This is available for both calculated dimensions and measures and returns the length of a string.

Substring Calculation

Create Substring calculations for string values with import data connections. Not only is this available for calculated dimensions, it’s also available within an IF function in calculated measures. The result set is a specific part of the string.

Substring (String, Start Index, Length)

  • String – string from which substring is computed
  • Start Index – position from which to start extraction, where 0 is the first character of the string
  • Length (optional) – the number of characters to extract

For example:

  • SubString( Product.ID, 3) returns “ST1” from “NA-ST1”
  • Substring( Product.ID, 0, 2) returns “NA”

Like Calculations

You can now create Like calculations for string values with import data connections. In calculated dimensions to determine whether characters in a string match a specified pattern using a regular expression. Don’t worry, the syntax is not case sensitive.

 

Create thresholds directly in charts

Story designers, you’ll love this! Create thresholds directly from your charts by simply selecting the data points in the chart. All relevant fields in the threshold builder dialog are pre-filled allowing for an easier and a more efficient experience.

 

Formatting the number of decimal places

Check it out! Story designers can now format the number of decimal places in charts and variances. If you love showing negative signs, you can do that too! You can find this setting in the styling panel under number formatting. The default number of decimal places specified in the model is preserved. The range is from 0-7 decimal places unless specified otherwise in the model.

 

Contextual styling for tables

We’ve improved the manual styling process. Story designers can apply style formatting to selectable sections such as header region, data region and dimension. This enhancement allows for a more flexible and efficient styling experience.

 

Improved highlighting of linked analysis for tables

We’ve improved the highlighting of selected cells in table for linked analysis. You can easily see what filter selections influence other charts on the page with linked analysis.

Learn how to create a linked analysis.

 

Time zone offset for date calculations

Story designers can specify the time zone when using Current Date in Date Difference and Difference From calculations. This allows designers to see the exact calculation output no matter the time zone difference.

 

 

Additional resources:

Previous feature summary blogs:

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

 

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Hau Ngo

    Incredible summary, Colin Chu. Thanks for putting this together! 👏🏼

    The third party business content is especially interesting. How I publish my supply chain analytics (models and stories) for other teams to preview and use?

    (1) 
      1. Hau Ngo

        It looks like the Build engagement model is perfect for my team: https://www.sap.com/partner/become/partneredge-build.html

        Thanks John!

        (1) 

Leave a Reply