This blog covers some of the latest new features and enhancements in SAP Analytics Cloud and SAP Digital Boardroom release 2019.05. 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.219 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.85 for SAP Business Warehouse (BW)
- Version 1.0.99 for SAP ERP / SQL databases
- Version 1.0.91 for SAP Universe (UNX)
- Version 1.0.75 for all other data source types
For more information, see System Requirements and Technical Prerequisites.
Highlights of this release:
- Planning: Option to publish data collection tasks with your calendar tasks
- Planning: Create input tasks on responsive pages
- Planning: Hide referenced columns of front-end calculations
- Planning: Data Actions – Option to select target currency
- Planning: Trigger planning sequences in stories via live connection to the embedded BPC system
- Data Integration: SAP Integrated Business Planning (IBP) import connection
- Data Integration: Google Sheets import enhancements
- Data Integration: Model creation enhancements
- Data Integration: Import data from an entity directly into a dataset
- Mobile: Geo map support
- Data Visualizations: Absolute base value for % Variance and % Difference From calculations
- Data Visualizations: Performance enhancements
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 >
When you submit your Calendar task, you can now choose to publish data collection tasks as well.
Input tasks can now also be created with Stories containing only responsive pages.
Hide referenced columns of front-end calculations
Less is more! After creating calculation columns in your tables (such as running sums, moving averages, etc.), you are now able to hide the column(s) that the calculation was based on while the calculation column remains visible.
Data Actions – Option to select target currency
Fancy using euros over dollars? Or prefer working with your local currency? For models with currency conversion, Data Actions can now be run on the currency of your choice. You have the option choose between default and local currency. This selection is used to create the version in Edit mode in the selected currency. However, please note that this setting will be ignored for private versions.
Trigger planning sequences in stories via live connection to the embedded BPC system
With just a simple click, Story Designers can now include a BPC Planning Sequence widget allowing Planners to easily trigger remote BPC calculation logic. Variables of these planning sequences can be set in the Stories. Please note that the BPC Work Status function can be used, although the planning function type file upload is currently not yet supported.
SAP Integrated Business Planning (IBP) import connection
Import data connection to SAP Integrated Business Planning is now available. Follow the usual on-premise setup by declaring the system in the SAP Cloud Connector administration panel and installing the SAC Cloud Agent.
Google Sheets import enhancements
Select which sheet to import for Google Sheets. Please remember that you can work with up to 5M cells in a sheet.
Model creation enhancements
When importing a smaller data file to create a model, you will be immediately directed to the data preparation area. No more unnecessary clicks!
Import data from an entity directly into a dataset
Import data directly from an entity into a dataset and use it to perform predictive workflows from the following sources:
- Generic OData
- SAP SuccessFactors
- SAP Business ByDesign
- SAP Cloud for Customer
- SAP Cloud for Customer Analytics
- SAP Integrated Business Planning (IBP)
Geo map support
Get insights and dive deeper in your geo map analysis when you’re on the go! You can now view and interact with geo maps on the SAP Analytics Cloud mobile app by exploring your choropleth and drill layers. Please note that geo on mobile does not currently support the following basemaps: Transparent Dark Gray, Night Time Streets, and China-based basemaps. Stay tuned for more!
Absolute base value for % Variance and % Difference From calculations
Use the absolute value of the denominator as the new default when calculating the % variance and % difference from. The resulting values will no longer deviate from the direction of their numeric counterparts which was the previous case whenever the denominator was a negative value. You will always be able to revert to the previous behavior if required.
Example: 𝐴=−20 ;𝐵=−40
Numeric Variance=𝐴 −𝐵=−20−(−40)=20
〖% 𝑉𝑎𝑟𝑖𝑎𝑛𝑐𝑒〗_((𝑂𝑙𝑑 𝑏𝑒ℎ𝑎𝑣𝑖𝑜𝑟))=(𝐴 −𝐵)/𝐵=(−20−(−40))/(−40)=−50%
〖% 𝑉𝑎𝑟𝑖𝑎𝑛𝑐𝑒〗_((𝑁𝑒𝑤 𝐷𝑒𝑓𝑎𝑢𝑙𝑡) )=(𝐴−𝐵)/|𝐵| = (−20 −(−40))/|40| =50%
With on-demand loading of filter values, your Stories will render faster! Previously, the filters’ list of values and the Story data itself were loaded simultaneously. The loading list of values for collapsed filters is now delayed until you expand it. Therefore, greater priority is given to displaying the data in the page: charts, tables, expanded input controls.
Please note that the dimension member count will no longer be displayed next to the dimension name if the Story Designer selects “All Members”.
As a part of our performance enhancements, when opening an SAC story from a direct link, persisted queries are now submitted during the startup sequence. We have also improved SAC’s logic to batch queries where possible. Please note that the batching of queries only applies if there is no data cache available. This is currently supported in the Chrome browser.
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.