What’s New in SAP Analytics Cloud and SAP Digital Boardroom Q1 2022
SAP Analytics Cloud is a single solution for business intelligence (BI), augmented and predictive analytics, and enterprise planning with the power of artificial intelligence and machine learning technology. It helps everyone in your organization make fast, confident decisions.
This blog post highlights the new features and enhancements of SAP Analytics Cloud Q1 2022 Quarterly Release (QRC).
- Administration and Service Management
- Data Integration
- Import Connections
- Live Connections to SAP Business Warehouse
- Dashboard and Story Design
- Data Modeling
- Enterprise Planning
- Keyboard Support for Value Driver Tree Value Entry
- Pasting Empty Cells to Booked Data Cells
- Open API for Data Export
- Handing of Many People in the Calendar Designer Panel
- Calendar Process Notifications
- Enhanced Cross Model Calculation in Advanced Formulas
- Enhancement of Mass Data Entry mode
- Multiple Account Hierarchy Support
- Mobile Analytics
- Augmented Analytics
- Analytics Catalog
- Analytics Designer
- Generic widget access API
- New Responsive Rule in Flow Layout Panel to Hide Certain Widgets
- Accessing Data Change on the Home Screen
- Navigation Panel Running on Tablets and iPads
- Performance Best Practices at Application Design Time
- Copy Private Bookmarks by Privileged Users
- Linked Widgets Diagram
- Support for Linked Dimensions
- Custom API types supported for Custom Widgets
- Data Exploration
- Microsoft Office Integration
- DWC Integration and Enhanced Open Dialog
- Planning: keep formula on data cell
- Open Dialog: Folder Structure
- Keyboard Shortcuts
- Zero Suppression
- Define Specific Number Format
- Single Table Refresh
- Set or Retrieve Dedicated Filters on Data
- Hierarchy-based Selection of Leaf Members
- Support Prompt Pop-ups
- User Collaboration
Several improvements have been made when data changes are logged:
- If data audit is enabled in the modeler, a log entry with activity “Create” is generated.
- If data audit is disabled in the modeler, a log entry with activity “Delete” is generated (together with the information on how many rows were deleted).
- If in the “Data Changes” dialog, some audit entries were deleted, a log entry with activity “Data Change” is generated, together with some deletion information.
- When a private version is published, a log entry with activity “Data Change” is created, along with some publishing information.
- When facts are deleted in the modeler, a log entry with activity “Data Change” is created, along with some deletion information.
Administration and Service Management
Custom Notification Banner Hyperlink
Customer system banner notifications can now include optional custom hyperlinks, allowing administrators to provide more information beyond the 140 character banner content limit. (SAP Road Map Explorer) (Video)
Custom Logo in Shell Bar
Administrators can now customize the shell bar by configuring the default logo in the shell with another logo of the customer’s choice. (SAP Road Map Explorer) (Video)
Transport Content Stored in Workspaces
During content export, users can now transport content stored in the Workspace from one SAP Analytics Cloud tenant to another. Both the workspace and objects stored in the workspace can be transported as part of the package. (SAP Road Map Explorer) (Video)
Live Connections to SAP Business Warehouse
BW Save Query Variants
Content creators and consumers can now maintain user variants selections within the variable prompt dialog box. This is a pure BW feature that can be used in design and view mode of a Story, Analytic Application, and Data Analyzer. (SAP Road Map Explorer) (Video)
Different functions for Variants include:
- Save (Creating) variants
- Overwrite variants
- Manage variants
- Delete variants
Dashboard and Story Design
Export stories to PDF format from Optimized View Mode
Optimized View Mode now supports Manual PDF Export.
The following export options are available:
- Insert Appendix
- Export All Pages OR Range
For more information on Optimized View Mode, check out the following resources:
New Model support for identifying missing currency conversion rates
Support has been added to the new model for identifying missing currency conversion rates:
- There is improved error handling for new models with currency conversion
- Users can trigger a missing rate analysis with required parameters directly from an error pop-up in stories
- Conversion errors in tables based on new models are now logged in the rate table’s conversion error log
Calendar Process Notifications
Calendar process notifications have been simplified. Upon activation of a calendar process, users who are involved in the process as well as its child events will now receive only one notification instead of notifications for each event. The email notification contains a list of all events that are relevant for the user and specifies their roles.
Enhanced Cross Model Calculation in Advanced Formulas
In advanced formulas, the flexibility and ability to define the scope of a linked model has been improved. The MODEL/ENDMODEL and MEMBERSET statement can be used to define scope of reference models. In combination with the definition of the linked model scope, dimensions existing only in the linked model but not in the default model (missing dimensions) can be omitted in the definition of the LINK function. (SAP Road Map Explorer) (Video)
Once the linked model scope is defined:
- Use dimensions and attributes from a linked model in the IF or FOREACH scope.
- Use the LINK function to return a certain range of data from the linked model and redirect the calculation scope of the default model by using attributes of dimensions from the linked model in the DATA function.
Enhancement of Mass Data Entry mode
Mass Data Entry mode has been enhanced. All calculations that have been created via ‘add column’ and/or ‘add row’ and have been modeled using the formula bar are affected. When Mass Data Entry mode is active, formulas will recalculate automatically upon data entry and changes can be shown immediately. (SAP Road Map Explorer)
Multiple Account Hierarchy Support
Multiple parent/child account hierarchies are now supported, simplifying plan modeling and enabling more flexibility to support management reporting requirements. This is supported for the Account model and New model. (SAP Road Map Explorer) (Video)
Android 12 Support with SAP Analytics Cloud Mobile
SAP Analytics Cloud mobile app is now certified to work on Android 12.
XCode 13 support for SAP Analytics Cloud SDK for iOS
The SAP Analytics Cloud iOS SDK now supports Xcode 13. The introduction of XCode 13 support makes the app future-ready for upcoming iOS releases, fulfilling App store review guidelines and creating a base for leveraging new XCode/iOS features.
Android App Proxy Support via MDM
The SAP Analytics Cloud mobile app for Android now supports proxy settings via MDM allowing customers to securely split internet traffic inside the VPN tunnel.
Piecewise Trend & Data Source Influencers in the same Forecasting Model
Smart Predict is now able to combine piecewise trend and data sources influencers within the same forecasting model. This further improves the handling of disrupted time series, the overall forecast quality is improved, and the explanations become more intuitive.
Navigation Panel Running on Tablets and iPads
Analytic designers can now use the navigation panel for analytic applications that run on bigger mobile devices such as tablets and iPad. This allows users to perform ad-hoc analysis on the table, such as adding or removing dimensions and measures.
The navigation panel is supported in the SAP Analytics Cloud mobile app, and in Safari browser. Smaller devices, like smart phones, are not fully supported for the time being. (SAP Road Map Explorer) (Video)
Performance Best Practices at Application Design Time
Application designers can now build more performant and optimized analytic applications faster thanks to performance optimization tips displayed during design time. (SAP Road Map Explorer) (Video)
Related best practices include:
- Enabling optimized view mode
- Collapsing input controls
- Manually setting Top N
- Keeping images small
Copy Private Bookmarks by Privileged Users
Application designers assigned with the corresponding privileges can now copy private bookmarks when saving or copying analytic applications. (SAP Road Map Explorer) (Video)
Linked Widgets Diagram
The Linked Analysis Diagram has been renamed to Linked Widgets Diagram as it can now visualize more than linked analysis and filter line relationships.
Application designers can now manage cascading relationships between input controls through the Linked Widget Diagram. Users can have a graphic view of relationships among input controls, namely cascading effects, and edit related settings directly on the diagram. (SAP Road Map Explorer) (Video)
Support for Linked Dimensions
Application designers now have the ability to link dimensions and blend data from multiple sources. A primary data source with secondary data sources that contain common dimensions can be joined. Additionally, charts and tables can be defined based on a blended data source, as well as filters that can simultaneously update all the charts and tables with a linked dimension. Lastly, Script APIs are available for blended charts or tables, while they work only on the primary data source. (SAP Road Map Explorer) (Video)
Custom API types supported for Custom Widgets
Custom Widgets developers now have more flexibility to define their own API type for data structure to cover their scenario by creating custom data types.
Select or Deselect all Measures
The ability to select or deselect all measure has been greatly improved. Users can now quickly select and deselect all measures with one click via the “Select All” checkbox in the builder panel. (SAP Road Map Explorer) (Video)
Save Insight with Advanced Options
Advanced options are now available when saving an insight in Data Analyzer. Users can choose to keep the last saved values for dynamic variables and allow the variable prompt dialog to open when opening an insight. These additional settings provide end users with more flexibility in customizing variable settings. (SAP Road Map Explorer) (Video)
Microsoft Office Integration
Open Dialog: Folder Structure
SAP Analytics Cloud folder structure is now supported in the Select Data Source dialog. The enhanced search feature highlights a respective models exact folder location for easy access.
Keyboard shortcuts can be used on desktop versions of Excel to make reporting, and planning data entry faster. The shortcuts are available for Windows and Mac. (SAP Road Map Explorer) (Video)
Users can now switch on/off zero suppression to hide cells with zero value.
Define Specific Number Format
Users can use and define specific cell formatting in a Microsoft Excel grid as percentage, decimal, or currency displays. (SAP Road Map Explorer)
Single Table Refresh
Users can now choose to refresh selective, or an individual table as opposed to all tables in a workbook. This enables users to refresh certain tables while continuing to update another table. (SAP Road Map Explorer) (Video)
Set or Retrieve Dedicated Filters on Data
Report creation can be accelerated with the ability to use cell-based formulas to set dedicated filters on a dimension’s members from a Microsoft Excel grid. This simplifies tasks such as retrieving data directly in the Excel grid without the need to use the right-side panel as in the past. (SAP Road Map Explorer)
Hierarchy-based Selection of Leaf Members
Additional flexibility has been added to make it easier and quicker to select on specific members. In addition to the existing options (e.g., descendants only, self only, etc.), users can now select only the leaf member of a particular node, simplifying the steps for adding data at the lowest level of a hierarchy of a dimension. (SAP Road Map Explorer) (Video)
Support Prompt Pop-up Screen
Workbooks can be designed with a prompt screen that allows end users to restrict result sets or to change currency conversion applied as desired. (SAP Road Map Explorer) (Video)
Bursting Publications on Recipient-based Authorization
Schedule owners can send personalized publications through e-mail, based on the recipient’s data-authorization settings. (SAP Road Map Explorer) (Video)
- Respect Access restrictions with acquired data models
- Respect access restrictions on live data models
- Respect profile settings of recipients such as language preferences and formatting
- For non-SAP Analytics Cloud Users – Schedule owners data authorizations would be respected
Visit the SAP Analytics Cloud Help Portal for more information on scheduling publications.
Notifications for Widget Comments
When a user is tagged in a page or widget comment with the “@User” notation, delivery of an e-mail notification is sent that they have received a comment, providing both the comment details and a link to open the story where the comment was added. As a result, users will receive notice of comments quicker by sending notification by e-mail alert to an external system, as opposed to sending notification only within the SAP Analytics Cloud notifications center. (SAP Road Map Explorer) (Video)
This blog post only provides a high-level overview of the latest features and enhancements of SAP Analytics Cloud. For more details on these features, please visit the SAP Analytics Cloud Help Portal. You can also visit the SAP Roadmap Explorer to see the upcoming features of SAP Analytics Cloud.
Date picker widget expected in Q2 2022 release?
Was announced in ANA300, but at the moment I don’t see it in the 2022 roadmap.
Hi Aleksey Salinin , please note that SAP’s strategy and 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.
Megan Hoy , yes, I understand. That's why I'm asking not about the current Q1, but about the future;) Or are there no exact plans yet and follow the news about fast-track releases? (by the way, thanks for bringing the blogs back)
Due to other high priorities we need to postpone this date picker widget to the future releases.
If you need this widget urgently for now, you can leverage the date picker widget as the custom widget provided by partners or any individual contributor.
Is there any information on Microsoft Office Integration: Set or Retrieve Dedicated Filters on Data? DIMENSIONFILTER is not recognized by Excel. Is this a Macro?
It will be not a macro but a specific SAC add in formula which will be used to retrieve the filters applied on dimensions/properties. Once the filter is retrieved , it will be also possible to change the filter applied directly form the formula: after clicking on it a member selector will pop up and the user will be able to change the selection of the dimension filter.
That is exactly what we need 🙂
When will it be available?
Planned delivery date is end of March.
We were really looking forward for support of multiple account hierarchies.
According to the SAP statement it should be possible to import from source system
"It's now possible to add additional hierarchies to the account dimension of your models. You can either model your hierarchies manually in SAP Analytics Cloud data modeling or directly import from your source system. "
I just attempted to import Account hierarchies from BPC into New Model based on the acquired data. But while for all other dimensions multiple hierarchies get transferred out of the box, for Account hierarchy only pure account IDs and account IDs corresponding to Hierarchy 1 seem to be imported.
Seems like Hierarchy 2 has to be manually created, and nodes need to be added again manually under account IDs.
Am I missing something, or is it the expected behavior?
While you can load multiple account hierarchies from the vast majority of sources, this is not currently supported using the BPC connector (as that's a different type of connection). We are looking at future support for this, however there is not define timeline for this currently.
Please create a request for this on customer influence.
Well, even if we create manually second hierarchy for account, SAC doesn't seem treat it as a real hierarchy in Charts (for drill through analysis), only in tables . Therefore it's of course great we can use it for planning part, but disappointing, that it can't be used for data visualization part.
Should we expect the same behavior, if we start working with S/4 Hana & Group Reporting, and will use SAC for the planning part?
Based on the information from the last section “Notifications for Widget Comments” and the SAC Roadmap, notifications for comments are again available.
I have access to 2 separate tenants (one of them is a Cloud test and demo tenant) but both have the same system version 2022.2.7. For the non-productive tenant notification are working fine in both ways (emails and the notification panel) but for the productive tenant unfortunately notifications by tagging users are not working.
I noticed that in the second tenant tagged users after refreshing stories are displayed in black and in the working tenant the font is staying highlighted in blue.
Do you know what can be the reason of not working notifications for comments with “@User” notation? I tested it with tagging a user in comments on pages, texts and charts.
This looks to me a bug as there are no separate setting as expected, Could you raise this incident so that our support team can take a look at the same .
Thank you for your quick response! This was as well my assumption, after additionally checking the administration settings and roles privileges but I wanted to know if I am missing something. So, we will create the incident. Thank you very much!