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.
- Planning: Improvements to editing public versions
- Planning: Workflow status
- Planning: Adding new dimension improvements
- Planning: Thresholds for calculated rows or columns
- Planning: Manage processes and tasks with Calendar
- Digital Boardroom: Set an advanced filter for a topic
- Digital Boardroom: Cross topic navigation with filter context
- Infrastructure: Dynamic user creation for SAP Analytics Hub
- Intelligent Enterprise: 3rd Party Business Content
- Data Analysis, Stories and Tables: Compound Growth Rate for time based charts
- Data Analysis, Stories and Tables: Length Calculation
- Data Analysis, Stories and Tables: SubString Calculation
- Data Analysis, Stories and Tables: Like Calculations
- Data Analysis, Stories and Tables: Create thresholds directly from charts
- Data Analysis, Stories and Tables: Formatting the number of decimal places
- Data Analysis, Stories and Tables: Contextual styling for tables
- Data Analysis, Stories and Tables: Improved highlighting of linked analysis for table
- Data Analysis, Stories and Tables: Time zone offset for date calculations
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 >
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.
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.
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.
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.
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.
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.
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.
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.
- 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.
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.
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
- SubString( Product.ID, 3) returns “ST1” from “NA-ST1”
- Substring( Product.ID, 0, 2) returns “NA”
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.
Previous feature summary blogs:
- SAP Analytics Cloud release 2018.10
- SAP Analytics Cloud release 2018.09
- SAP Analytics Cloud release 2018.08
- SAP Analytics Cloud release 2018.07
- SAP Analytics Cloud release 2018.06
- SAP Analytics Cloud release 2018.05
- SAP Analytics Cloud release 2018.04
- SAP Analytics Cloud release 2018.03
- SAP Analytics Cloud release 2018.02
- SAP Analytics Cloud release 2018.01
- More >
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.