This blog covers some of the latest new features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2018.07. 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.
Highlights of this release:
- In-grid calculations
- Improved cell formatting on grid pages
- Cell reference enhancements
- Input task improvements
- Version management panel improvements
- Planning operation improvements
Integration and OEM
Data Analysis, Stories, and Tables
- Optimize story building performance
- Auto refresh of stories in view mode
- Force prompt on open
- Star join time hierarchies in HANA
- Notification when multiple users are editing a story
- Date interval calculation
- NULL value calculations
- Setting hierarchy drill level in charts
- Expanding hierarchies in charts
We now allow direct entry of user defined calculations within the calculation area of the grid in both the rows and columns. Previously, support existed for calculations in the grid but it was outside of the predefined calculation area. This capability simplifies both the construction of report calculations (e.g. variance calculation) and the ability to customize the layout of your reports and calculations. Moreover, these in-grid calculations will be replicated down (or across!) consistent with changes in drill state of the specific report.
Improved cell formatting on grid pages
Never again will you forget which cells you’ve changed! In this release, when you select a cell to add to a formula, the cell will be highlighted so it’s easier for you to remember which cells you’ve changed.
Cell reference enhancements
When you type a formula in a cell, you can now create cell references by simply selecting a table or grid cell.
Input task enhancements
Made a mistake? Don’t sweat it! If needed, you can now reset all your substitutes back to your default assignees. You can even exclude pages from input tasks that get sent to assignees, too!
Your administrators can see all the pages but your assignee will not. Got an issue with that? Now as an assignee, you can include comments when you choose to submit or decline a task.
Version management panel improvements
Easily create private versions by dragging and dropping your public version to your private version section. We’ve also added keyboard support for all versions.
Planning operation improvements
Planning operations including data entry on unbooked cells are now supported when filtering by dimension attributes. These navigation attributes can be combined with other types of dimension filters.
Navigation attributes are allowed in:
- Story filters
- Page filters
- Builder panel filters
Data source tab for public dimensions
We’ve upgraded our public dimensions area! Now access the “Datasource” tab for public dimensions. This will capture all the information uploaded in it, creating a smoother consistent user experience for you and showing information about all data uploads into a public dimension.
SAP BPC improvements
We’ve extended support to BPC models which use non-calendar fiscal years. To streamline and simplify integration with BPC, we’ve removed the option of creating a “read-only” model. Any BPC model can be read-only or write-enabled simply via the specific security configuration for the model within SAP Analytics Cloud.
Complex multi-dimensional filtering with R visualizations
R visualization widgets can now accommodate advanced filters for complex multi-dimensional inclusions and exclusions—so you can easily select N-tuples of dimension members to be filtered together.
Auto refresh option
Tired of seeing yesterday’s data? You can now set your story data in Digital Boardroom to automatically refresh in your presentation settings. It’s up to you to choose if you want your story refreshed every 5 minutes or 5 hours! Auto refresh is also available for stories independent of the Digital Boardroom.
Integration & OEM
Universal display hierarchy
Table visualizations using live connections to SAP BW now supports the BW Query setting “Display as Hierarchy” (also known as Universal Display Hierarchy.)
The Universal Display Hierarchy setting in the BW Query can be activated in the rows and/or columns. This allows two or more dimensions defined in the row or columns in the BW Query to be displayed hierarchically within a table visualization.
Interested in learning more? Check out our new blog on Universal Display Hierarchy support with SAP BW!
Support for two structures in a BW BEx query
Stories using live connections to BW BEx queries containing two structures now support custom measures (calculated or restricted) within a visualization (table/chart.)
Enterprise management of mobile deployments
Now, administrators can manage their SAP Analytics Cloud Mobile application via Mobile Application Management (MAM) solutions. As an administrator, you can specify your tenant URL, set up a default story to open on launch, and remove the application off a user’s device.
Data Analysis, Stories and Tables
Optimize story building performance
Save time when you design your stories! By enabling this performance optimization option in the modeler, charts or tables can be altered in a story without triggering an automatic refresh with each action.
Auto refresh of stories in view mode
Auto refresh stories! Set an interval for auto refresh in seconds, minutes, and hours (min. 30 secs.) You can also turn off auto refresh in view mode.
If auto refresh fails five times in a row, the feature will be temporarily disabled and you will be notified.
Force prompt on open
Story designers can configure prompts for viewers when they open a story, ensuring that the viewers are aware that the story is driven by prompts that can be adjusted.
Please note if there are two models and all variables are linked, only one prompt variable dialog will be shown for both models.
Star join time hierarchies in HANA
We now support star join time hierarchies in HANA! Please note that the minimum HANA version is 122.05.
Notification when multiple users are editing a story
Whether it’s two people, or twenty, all users editing the same story concurrently will be notified of each other’s presence. If any user in this scenario saves their story, all the other users will become viewers of that story and can only save a copy of it.
Example: Colin is in Design Mode for a story and Cynthia opens the same story in Design Mode. They will both receive a notification of each other’s presence. If Colin saves his version before Cynthia, then Cynthia will have the option to save a copy of her edits as a new story (and vice versa.)
Date interval calculation
You now can create date difference calculations on:
You can also calculate on different granularities such as:
Please note that this is only available for imported data.
NULL value calculations
Now you can do calculations on NULL values in either calculated measures or dimensions.
We’ve added histograms as a new chart group! Histograms are easy-to-read charts that allow you to compare quantitative data in a visually compelling way.
Please note that blended data-sets and remote connections are not yet supported.
Setting hierarchy drill level in charts
You can now set the hierarchy drill levels in the chart details and builder panel. Once the chart is saved, the drill level selection is maintained when reopening the story.
Please note that the only live data source supported for this feature is HANA.
Expanding hierarchies in charts
Expand hierarchy top nodes of accounts or dimensions in your charts. Once they’ve been expanded, you can see both parent and child nodes. This level selection is maintained when reopening the story once the story is saved.
Please note that the only live data source supported for this feature is HANA.