What's New – 2019 Releases

Find out what's new in the latest version of SAP Analytics Cloud.

Version 2019.15

Check out our video highlights of the top features in Q3 2019!

Administration & Infrastructure

  • Featured files on the home page

    You can access files from a featured files tile on the homepage for quick access, saving you time from looking through folders. Featured files will be dynamic based on sharing settings, so team members can edit who sees which file and each user will only see their accessible files on the homepage. Fantastic!

  • Administrators can audit changes made to files' sharing settings

    The Activities log is now updated to show details for any changes that are made to the Sharing Settings of files stored under Browse > Files.

    These include:

    • The name of the object whose permissions were changed

    • The permissions that were granted/revoked and to which specific user/team

    • The user who made the change

    • The timestamp of the change

    This will allow for the administrators to view their sharing settings history.

  • User & team provisioning API improvements for user properties

    Synchronize your user accounts from other systems with default values for the following user preferences:
    • SAP Analytics Cloud UI language

    • Data access language

    • Default date, time, and number formatting

    • Email notification settings

    • URL to a profile picture

  • Add, remove, and reset folders & file permissions with inheritance

    We've simplified and improved the share dialog box for your convenience. Now you get visibility into the inheritance of permissions that users & teams are assigned on parent folders. You can choose to break the inheritance at any subfolder level or choose to re-establish inheritance from its parent. To make the dialog box more intuitive, the object owner is displayed, and we have prompting available for you to confirm whether a cascading effect is required. The control is entirely in your hands. You can choose to give specific access levels to multiple users and teams.

  • Edit the sharing settings for samples

    Administrators can now change sharing settings on samples that are installed by default, making it easier to control access for samples.

  • Edit the default permissions that users & teams have on the Public folder

    Administrators can now edit the default permissions for the Public folder through the "Share Folder" dialogue. Previously, the Public folder was locked down and you had to change the permissions of each file individually. Now, you no longer need to go back and change users' rights manually, just set it and forget it!

  • Users' API Provisioning enhancements

    You can now add filters to user GET requests made through the User and Team Provisioning API. This will support the Username and Email attributes.

  • Two-legged OAuth Support

    Two-legged OAuth integration support for SAP Analytics Cloud instances running on non-SAP data centers has been added, allowing seamless integration with S/4HANA and Intelligent Asset Management.

Analytics Designer

  • Debug mode

    We've now added the ability to debug scripts in the browser script debugger. Gone are the days of loading up other programs!

  • Define filter lines for different input data in R-visualization widgets

    When you use R-visualization widgets in Analytics Designer, you can now add filter lines directly to the widget without having to work around using hidden tables. Now if you'd like to take a minute, just sit right there, and enjoy all this extra time we gave you to spare!

  • Geo map widget enhancements

    With this update, geo maps will work in Analytics Designer just like they do in Stories! The geo maps will support additional quick menu entries such as full screen, drilling in the Choropleth layer, and filters. We are also adding two new API calls with many more on the way!

  • Set widget size and position according to application logic and canvas size

    As an application designer, you'll be able to allow application users to dynamically set a widget's size and position according to application logic and canvas size using the layout-related APIs. Alternatively, users can change the widget width, height, and position statically using the Styling Panel.

  • Define theme

    Application designers can now define, load, or edit a theme at application design time, as well as store all the widget settings in a theme. The theme will be stored in the file repository and can be reused in any other analytical application, though owner permissions will be required to make any changes.

  • Panel widget

    This update also brings panels to Analytics Designer, enabling you to create a container for grouping widgets together. This will help move multiple widgets around easier, instead of having to move them all individually.

  • Data analyzer

    The data analyzer is a predefined ready-to-run service for SAP BW queries. You can use the Builder panel and the Available Items area to navigate and analyze your data by adding and removing dimensions from the table, filtering for items, and changing its display and sort order.

  • Change cell values in your tables at run-time

    We've added three new script commands to help you with…
    • Fetching a planning object from the widget’s data source

    • Writing data into a cell

    • Submitting updated data

    This should make changing data at run-time a little more enjoyable!

  • Copy and paste technical components

    You can now duplicate Scripting objects from the context menu of the outline pane, as well as copy and paste technical components to and from external programs, helping to increase your efficiency!

  • Renaming enhancements

    We've now taken the trouble of renaming variables away from you! When you go in to change a widget name in the Analytics Designer outline, the related scripting will automatically be changed for you, saving you time and effort.

  • Specify simple or advanced mode on your dialogue

    When using Search to Insight in Analytics Designer, you can choose whether to search in advanced mode or simple mode, with the advanced mode giving you more search suggestions if you so desire.

  • BPC planning sequence widget improvements

    A BPC planning sequence UI widget is now available in Analytics Designer along with two new APIs to set the widget's visibility. The BPC Planning Sequence is now also supported by the BPC Live embedded model, continuing with our mission to bring you the greatest variety of data sources possible.

Data Integration

  • SAP S/4HANA exports run in the background

    The time has come, from this point onwards, SAC will do all the running in the background when it comes to exporting to S/4HANA, allowing you to focus on more important things.

  • Maintain BW member order in Global Dimensions

    Consistency is key. That's why SAC now maintains member order when acquiring BW Global Dimension hierarchies, saving you time and keeping everything exactly where you left it.

  • Replicating data from SAP HANA

    You can now import data via the new SAP HANA driver, giving you more flexibility with SAP HANA sources so you can choose whether to import or use a live connection.

    Key details:

    • Data can be acquired from:

      • All view types via the Query Builder

      • All tables and procedures via Freehand SQL

    • Supports single or multi-container

    • Requires setup of SAP Cloud Agent and SCC

  • Import larger volumes of transaction data from BPC

    With this update, you can now import much larger volumes of transactional data from BPC to SAC, allowing you to analyze more data than ever before.

  • Import data from Amazon S3, Egnyte, Dropbox, NetSuite, Microsoft Dynamics, and OneDrive via Open Connectors

    This update brings access to six new sources which can be set up with SAP Cloud Platform’s Open Connector service found in the SAP Store. The SAP Analytics Cloud administrator will also have a global pause button available to manage usage. Let the information flow begin!

  • Import data file size improvements

    We now support CSV files up to 2GB and Excel files up to 200MB, giving you double the data import capability. Because when it comes to data and analytics, bigger is always better!

  • Data export improvements

    With this feature, you're getting two great updates for the price of one. Not only can you export up to six million rows of fact data, but the speed for exporting is even faster than when you could only export one million rows. You can also choose whether to export facts, calculations, or both, but calculations are still limited to one million.

Data Visualizations

  • Export tables into Excel files

    Are you a spread-head and do you love spreadsheets? Even if you just like spreadsheets, now you can export tables in point-of-view scope into Excel, as well as to CSV. We also support export in Explorer mode too!

  • Prevent Viewers from removing Non-Modifiable Story Filters

    To increase the designer's control, you now have the option to disable the ability for viewers to remove non-modifiable story filters.

  • Dynamic time filter workflow enhancements

    Users can now create dynamic time filters and calculations faster than ever. These filters and calculations can also be adjusted for different levels of granularity (i.e., Periods) with fewer steps than before.

    • Period selections include:

    • Current

    • Previous

    • Next

    • Current & Previous

    • Current & Next

  • Dynamic time offset for page and story filters

    Story designers can now create dynamic time filters with offsets for months and years to fine tune exactly which time periods you want on your dashboard.

  • Enhanced linked analysis

    Now linked analysis has gotten more pro! A more intuitive design allows users to access linked analysis via the quick action bar, rather than the toolbar. And story designers have greater control and flexibility to select which widgets can be included in linked analysis. This enhancement allows more than one linked analysis group per page!

  • Cross calculations for currency conversion in charts

    Convert any currency to any other with SAC's new currency conversion models in charts! This will allow story designers to create currency conversion calculations for each desired currency, making it even easier to interact with global currencies.

  • Variance as a Data label for line, radar, scatterplot, heatmap, and more!

    We've now enabled support for adding data labels to several charts, which is perfect for comparing performance between two data figures. Say, for example, you're running a shipping company and want to see how two of your ships, the Olympia and Titanic, are doing. You can now show the variance as a data label directly in your scatterplot, letting you see more than just the tip of the iceberg. Now that's what we call a monumental advancement, some might even call it Titanic.

  • Display percentages or absolute values in Pie/Donut Charts

    You can now easily toggle between percentage and absolute values to be displayed in your Donut or Pie Charts, and for the Donut Charts you can also choose to display the total aggregate amount in the center, making it easier to visualize your data.

  • Prioritize front bar data labels in layered bar charts

    Story designers can now prioritize the bars in a visualization to show the front bar's data labels only, making it easier to view your information.

  • Dynamic text for any dimension

    This will give you the ability to create dynamic text from a Dimension rather than a single filter or input control. Dynamic text will also include the dimension member(s) selected when using linked analysis. For example, when applying a single member page filter in your story, you can build a report style dashboard that dynamically changes your text based on what’s being filtered and shown on screen.

  • Explorer in Embedded mode

    Viewers can now access explorer mode in embedded view as long as the story designer enables the feature. This will make it easier for viewers to investigate data beyond existing charts.

  • On-demand Loading of Inactive Values on Story and Page Filters

    We've changed the inactive values in story and page filters to load on-demand and made the story opening time faster than ever before!

  • Cross calculation input control in charts

    Story designers can create cross calculation input controls in charts, providing more flexibility to end users by allowing them to select which currencies to display at any given time.

  • Optimized performance for open-ended and dynamic date range filters

    Story opening times have been improved by delaying queries for dynamic or open-ended date range filters until after the story has loaded.

  • Optimized Geo performance when Clustering is enabled

    We've reduced the number of queries for bubble size and color for the Bubble Geo Map legend from four, to one per layer. This will free up slots for other queries on the page allowing other charts to load faster.

  • Stacked bar chart without dimension axis

    You can now show multiple measures all stacked without needing a dimension. That's a measurable improvement!

  • Input controls for multiple cross calculations for tables

    The new cross calculation input control supports single and multiple member selection in tables, giving you more precision to accurately view your data.

  • Performance improvement for clustered geo maps

    Unnecessary legend information in clustered geo maps will no longer be displayed, allowing for load times faster than ever.

  • New default for Story & Page time range filters

    To save you time, dynamic time is the new default option for Story & Page time range filters.

  • Add comments without saving your story

    You can now add or delete comments without having to save your story since the comments will be added as soon as you post them. This more intuitive approach will make it easier to add comments and collaborate with your peers!

  • Add comments to an embedded story

    Embedded stories will now support commenting, as long as the system administrator enables the feature under system configuration. Who needs social media anymore? Now you can like, comment, and share all through SAP Analytics Cloud!

General

  • Multilingual content support

    You can now translate user-defined fields for a given story, with appropriate permissions. These can also be exported to an XLF file and translated using third-party translators to help speed up the process!

Intelligent Enterprise

  • Extended support for live BW blending use cases

    We now support extended use cases for blending with live SAP BW data. Our supported use cases extend to the following scenarios:

    • Multiple live BW models from same/different BW systems

    • Multiple model blending using imported data with live BW models

    • Support live HANA SDI and browser blending

    • Support BW as primary data source

  • You can now answer questions about how your business has changed with version to version variance and waterfall charts for SAP BW live data sources.

  • Hierarchy geo map visualizations for SAP BW

    The choropleth layer in geo maps can be used to visualize data as a hierarchy of geographical shapes with SAP BW.Version to version variance & Waterfall chart support for SAP BW live data

    When dynamic filters are created by a variable submission for a specific dataset, they will automatically be applied on all layers.

  • Sort measure values with two-structure queries with live BW models

    When you have more than one dimension in the existing structure, you are now able to sort the measure values from lowest to highest and vice versa.

  • Performance improvements for BW

    Version to version variance With these new performance improvements for BW you'll be running faster than an Olympian!

  • Date picker

    The new date picker lets you select a date more efficiently for a BW characteristic value variable!

  • Enable currency conversions using SAP BW remote connections

    You can now convert currencies using SAP BW remote connections, with the conversion types and rates defined in BW available in the SAP Analytics Cloud User Interface.

  • Tuple filters for charts and tables when drilling down

    You can now use tuple filters for charts and tables when drilling down on dimensions ordered in hierarchies. Tuple filters can also be combined with linked analysis between different tables or charts, giving you more flexibility in how you want to view your data.

Mobile

  • Additional language support

    SAP Analytics Cloud mobile now supports 12 new languages! These include:
    • Croatian

    • Dutch

    • Greek

    • Finnish

    • Hindi

    • Indonesian

    • Norwegian

    • Portuguese

    • Thai

    • Turkish

    • Ukrainian

    • Romanian

  • Support for featured content

    Featured stories and presentation can now be accessed from mobile, as well as being able to set featured content as a default filter when logging into the app. You won't ever have to worry about missing critical information from your business again!

Modeling

  • Quartile exception aggregation type support

    As with models based on acquired data, you can now define additional exception aggregations types based on SAP HANA Live models. These include First Quartile, Median, and Third Quartile. This should help to normalize your distribution of time when working with SAP Analytics Cloud.

Planning

  • Turn calendar tasks into recurring tasks

    You can now turn your calendar tasks into recurring tasks. It's up to you to modify the series and you can still modify one occurrence independent of the whole series. The choice is yours. You can choose to create your recurrence hourly, daily, and weekly. End your recurrences anytime you'd like – pick a specific date, after specified number of occurrences or never end it at all!

  • Default mass data entry

    You can now enter mass data entry mode by default when making data entry changes in your table. This can be toggled on and off from the builder panel.

  • Calendar keyboard support

    Check out Keyboard Command List for Calendar Navigation for all the great shortcuts that are now available.

  • Enhanced visualization of child tasks within a process

    This update brings new calendar visualizations, so you can see if processes are related to each other or if they just happen to start at the same time.

  • Context for calendar tasks and processes

    With Calendar tasks, you'll now be able to set up a context that defines the first scope filter on dimensions of a specified model. This will boost productivity, making it easier to zero in on the data you need to work with.

  • Generate tasks or processes with the Calendar wizard

    You can now generate calendar tasks and processes along a driving dimension using a wizard. This should help save lots of time when creating batches of events.

  • Parameters for data actions and advanced formulas

    When you're creating a data action, you can now create parameters and add them to any of the steps of your data action. You can use parameters to create prompts for users in stories or to quickly update a fixed member value or number in several different places throughout the data action.

    Once you've created a parameter in a data action, you can call the parameter in an advanced formula action. This works with creation via script and with the visual tool, increasing your speed and efficiency through automation.

  • Create a Forecast or Rolling Forecast from the Builder Panel

    Easily create a Forecast or Rolling Forecast layout from the Builder Panel without having to use the restricted measures method. Now you can use time as a normal dimension, choose the version to use for look back, and add additional look back and look ahead periods.

  • Empty cells are treated as unbooked cells during copy and paste

    When you copy and paste your empty cells from your spreadsheets (or SAP Analytics Cloud grid) to your table, they are now treated as unbooked cells.

  • Multiple date dimensions in planning models

    Need to keep track of several time metrics at once? Now you can add multiple date dimensions to your planning models! These dimensions will be supported by the Advanced Planning dialog patterns and can be consumed in Data Actions.

  • Booked mode enhancements

    You can now add new members by right clicking on the header of an empty table and they will be added as unbooked data. You no longer need to see visible elements in a table before adding a new member, giving you more flexibility in how you want to use SAP Analytics Cloud!

  • Change calendar tasks to processes and vice versa & assignee roles for calendar process

    You can now change your calendar tasks to processes or your processes to tasks with a simple click. You can also add assignees to a calendar process and they can distribute tasks to other assignees by transforming those tasks into processes and adding child tasks. Efficiency maximized!

  • Copy and paste in your tables with live BPC

    When working with a table based on a live data connection to BPC Embedded, you can now copy and paste values inside the table, between tables, and with external tables (such as an Excel file). Keep in mind that only values will be copied. Typing data manually is over.

  • Enter data into empty cells while using advanced filters

    Now you can enter data into empty cells even when using advanced filters. This will help improve your efficiency, while giving you more control over your data.

  • New keyboard shortcuts in Gantt charts

    Check out these brand-new shortcuts to help make your day a little easier!

  • Copy and paste enhancements for aggregation accounts

    When copy-pasting in aggregation accounts, you will now be provided visual cues that will help define a valid target cell for your paste.

  • Dynamically select leaves for a hierarchy

    For all non-account dimensions, you can now dynamically select to display only the leaves for the selected hierarchy.

  • Data locking task in Calendar mode

    The Calendar mode will now enable the creation of a Data Locking Task to trigger an assignee to complete Data Locking.

  • Attribute function

    In advanced formulas, you can now get the values of a numerical dimension attribute using the Attribute function and use it in a mathematical calculation. So, when you start getting a bunch of new information, you can attribute it to this new update.

  • Performance enhancements in advanced formulas

    Advanced formulas need advanced performance, and that's why we've optimized their overall response time by 46% on average.

  • Visual Formula enhancements

    In Advanced Formulas created using Visual Formulas, you can now choose to copy or read data from other models besides the default model of the Data Action. On top of that, in Advanced Formulas created using the Visual Formula editor, you can now add a "Delete" component to clear data facts within a defined data scope.

Smart Assist

  • Search to Insight brand-new user experience

    Smart Assist just got a whole lot smarter with an updated user experience.

    Search to Insight can now be launched from a dedicated icon and offers new user-specific recommendations. Easily search by models or choose to view your insights by the measures and the dimensions in your models.

  • Smart Insights on tables

    We have introduced a more intuitive design, right click on a cell instead of searching in the toolbar for the Smart Insights icon. This makes it easier to access the insights your company needs, and to keep all your goals in sight!

  • Search to Insight for BW & S/4 HANA Live Data Models

    Now you can use Search to Insight to create charts and find information with BW & S/4 HANA Live Data Models. Administrators can also configure live model indexing.

  • Smart Insights on navigational attributes

    When generating Smart Insights, navigational attributes are now considered and will help provide more detailed context to better enable your decision making! This will bring Smart Insights to a whole new dimension!

Version 2019.14

SAP is pleased to announce a new version of SAP Analytics Cloud.

General

  • You can now add filters to user GET requests you make through the SAP Analytics Cloud User and Team Provisioning API.

  • OAuth2 with SAML 2.0 Authentication is now supported for SAP Analytics Cloud instances running on non-SAP datacenters.

Data Acquisition, Live data Connections, and Integration

  • You can now create connections to and acquire data from SAP HANA views.

  • Currency conversion is now enabled. You can convert currencies during SAP BW remote connections.

  • The maximum file sizes for importing data have been increased.

  • To make life a bit easier, we've added a progress bar to all export options.

  • You can now import .csv and Excel files from cloud storage services such as, Egnyte, Amazon S3, Dropbox, and OneDrive. You can then use the imported files to create stories in SAP Analytics Cloud.

  • When exporting a model to a file, the limit per export job is now either 1 million rows (if account calculations are included) or 6 million rows (with no calculations).

  • You can now integrate SAP Cloud Platform Open Connectors with SAP Analytics Cloud and create import data connections to several third-party datasources.

  • For Live Data Connections to universes, thresholds on measures in stories are supported.

  • For Live Data Connections to universes, ranking in stories is supported.

Stories

  • You can now create a stacked bar chart that doesn't have a dimension axis.

  • You can now insert dynamic text based on dimensions from any model in your story and have it be affected by filters such as linked analysis.

  • You can now explore charts and tables from within an embedded story.

  • For SAP BW, you can now use the choropleth layer in geo maps to visualize your data as a hierarchy of geographical shapes.

  • For SAP BW geo maps, dynamic filters that are created by a variable submission for a specific dataset will be automatically applied on all layers using said dataset.

  • You can now use tuple filters for charts and tables when drilling down on dimensions ordered in hierarchies. You can use tuple filters combined with linked analysis between different widgets (tables or charts).

Calendar

  • You can now create a Data Locking task in the calendar.

  • You can now use a wizard to generate calendar tasks or processes along a driving dimension (for example, an organizational dimension).

Planning

  • You can now have dimensions with multiple hierarchies.

  • When you're creating a data action, you can now create parameters and add them to any of the steps of your data action. You can use parameters to create prompts for users in stories, or to quickly update a fixed member value or number in several different places throughout the data action.

  • You can now use an input control to select single or multiple cross calculations, including currency conversions, in a table.

  • After you create a parameter in a data action, you can call the parameter in an advanced formulas action, no matter whether it's created via script or the visual tool.

  • In advanced formulas, you can now use the Attribute instruction to get the values of a dimension attribute. The values must be numbers.

  • We have further optimized the performance of single and multiple ResultLookup functions in advanced formulas.

  • In advanced formulas created using the visual tool, you can now choose to copy or read data from other models besides the default model of the data action.

  • In advanced formulas created using the visual tool, you can now add a DELETE component to clear data facts within a defined data scope.

Modeling

  • The "quartile" exception aggregation types are now supported for models based on SAP HANA views, if your SAP HANA system meets baseline level 5.

Analytics Designer

  • The data analyzer is a predefined ready-to-run service for SAP BW queries. The data analyzer uses SAP BW live connections created in the tenant of SAP Analytics Cloud. All SAP BW queries can be accessed directly in the Select Data Source dialog and no additional model is created. You can open it by writing a script that uses the function openDataAnalyzer.

  • In the data analyzer, you can use the Builder panel and the Available Items area to navigate and analyze your data by adding and removing dimensions from the table, filter for item, and change its display and sort order.

  • There's a new execute permission for the data analyzer that you need to grant to your users before they can start working with it. As we've included this permission into many standard application roles, most users can just go ahead and use it.

  • As an application designer, you can enable application users to dynamically set a widget's size and position according to application logic and canvas size, using the layout-related APIs.

  • As a developer, you can now build your own widgets. As an application designer, you can add these custom widgets to your analytic applications in addition to the widgets delivered with the analytics designer. Please note that this feature is currently only available for selected Beta customers.

  • You can now use lazy loading to improve the performance of your analytic application at startup. Please note that this feature is currently only available for selected Beta customers.

  • As an application designer, you can now define a theme to store your favorite styles from canvas, pages, popups, and different types of widgets, or you can choose an existing theme to change the application's look and feel instantly. Once a theme is created, you can reuse it in any other analytic applications.

  • You can now add a panel widget to your analytic application as a container to group widgets together. You can choose to enable vertical and horizontal scroll bars for a panel and nest a panel inside a panel.

Mobile

  • A Featured filter has been added to the mobile app that lets you see important Stories or Digital Boardroom presentations highlighted by an administrator.

Content Network

  • From the Content Network, you can now share content privately between different systems. For example, you can share to individual systems, or to all systems that belong to a specific customer or partner. You can set different permissions for each sharing destination, too.

Multilingual Content Support

  • You can now translate user-defined fields for a given story, with appropriate permissions.

System Administration Notes

  • With the 2019.14 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), you must update to version 1.0.233 as a minimum.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.13

SAP is pleased to announce a new version of SAP Analytics Cloud.

General

  • Administrators can now restrict who can create files and folders within dedicated subfolders of the Public folder. These users still won’t be able to create files and folders directly within the Public folder itself.

Stories

Planning

  • In the calendar, you can now see if processes are related to each other or if they just happen to start at the same time. Also, in the Gantt view, you can now see the time values changing when you drag and drop a process.

  • You can now set up a context for a Calendar task, defining all the relevant information for the task such as the Model, primary or Driving dimension, and assignees and reviewers.

  • When you copy an aggregated account with calculated subaccounts, you can now see additional targets highlighted so you can paste the account value and its underlying records.

Analytics Designer

  • As an application designer, you can now add geo map widgets to your analytic application and allow your application users to create stories from the widgets. Currently geo map widgets don’t support data source-related APIs. Support for this is planned for future waves.

  • Analytics Designer introduces a concept of names for widgets and other application entities to ease the handling effort at design time.

    If you as an application designer want to rename some entity, various references to it must be adapted (mainly scripts, dynamic texts, and calculated measures). Previously, you had to do this work manually, which is a tedious job, especially for larger applications.

    The new automatic refactoring automates this process as much as possible. Ideally, you don't need to do anything: the rename just works, keeping the application intact.

  • You can now add a Search to Insight object to the scripting area and design its open dialog by defining the source of the questions to be asked. You can also specify whether the dialog is in simple mode or advanced mode and if you want to enable Clean History and Auto Search.

  • You can now use the BPC Planning Sequence widget to run planning sequences for BPC live data connection models. This way, the application user can run a planning sequence, which can contain one or more planning functions, as defined in the BPC system.

System Administration Notes

  • With the 2019.13 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.231.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.12

SAP is pleased to announce a new version of SAP Analytics Cloud.

Data Acquisition, Live data Connections, and Integration

Stories

  • You can now add variance figures to the data labels for additional chart types: Line, Combination Column & Line, Stacked Area, Scatterplot, Bubble, Heat Map, Tree Map, and Radar.

  • For Pie and Donut charts, you can now choose to show the data labels as percentages or as absolute values. For Donut charts, you also have the ability to show totals; they are displayed in the center of the Donut.

Planning

  • You can now import a larger volume of transaction data from BPC to SAP Analytics Cloud with the same memory configuration after applying BPC note 2755379 or upgrading your BPC system to a minimum support package specified in the note.

  • Data Entry support has been added for empty cells (unbooked) when advanced filters are present.

Analytics Designer

  • Name change! From now on, what used to be SAP Analytics Cloud Application Design is called SAP Analytics Cloud, analytics designer (note the comma!). Most of the time we'll just call it analytics designer.

  • You can now define filter line for different input data of a R-visualization widget.

System Administration Notes

  • With the 2019.12 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.231.

      • For BW users, please upgrade to agent version 1.0.231 at your earliest convenience. This version contains an improvement for the better handling of large data volume for BW acquisitions. Before upgrading, ensure that Tomcat has at least 4GB of memory (for help increasing the memory, see SAP Note 2732879Information published on SAP site).

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.11

SAP is pleased to announce a new version of SAP Analytics Cloud.

General

  • Administrators can now edit the default Samples folder and its contents. The sharing settings for the folder and its contents can also be modified.

Data Acquisition, Live data Connections, and Integration

  • You can now acquire data from Dow Jones articles.

Stories

  • Currency Conversions are now supported in Charts.

  • When filtering the time dimension in a page or story filter, or a restricted measure calculation, you can now shift dynamic time ranges into the past or future using the Offset option. New options let you quickly set up common dynamic time ranges like Current Year To Date or Previous Quarter.

  • Users can now access Smart Insights from supported table cells in the Explorer view or Canvas, Responsive, or Grid pages.

  • Configuration for linked analysis has been improved. You now have more control over which widgets are affected by linked analysis.

  • Administrators can now make it easier for end users to access significant content by adding the Featured content tile to their Home screen.

  • For SAP BW live data sources, you can now use a variance or waterfall chart to display the variance between versions.

  • You can now create an input control for your cross calculations.

Calendar

  • You can now change your Calendar tasks to processes or your Calendar processes to tasks.

  • You can now add Assignees to a Calendar Process.

  • You can now use some keyboard commands to move around in the Calendar.

Planning

  • The Mass Data Entry mode for adding data to a table can now be chosen as the default data-entry mode during story-design time.

  • When working with a table based on a live data connection to BPC, you can now copy and paste cell values.

  • When choosing a date for an SAP BW characteristic value variable based on date (0DATE), you can now select a date more efficiently, using a date picker.

  • The metadata call that is necessary to see any data from a BW system has been reduced to only the objects which are needed to get a result. That means, for example, that the free characteristics and attributes not used in drill-down of a BEx query are ignored. The performance improvements, which are up to 30%, are realized in the initial opening of a story and the setting of variable values.

  • In your story, when you have the Version Management panel open, it will now stay open when you change to another page.

  • You can now do data entry on a table that appears to be empty except for Dimension Headers: members exist, but they do not have any booked data.

Mobile

  • The SAP Analytics Cloud mobile app now supports new languages: Croatian (HR), Dutch (NL), Greek (EL), Finnish (FI), Hindi (HI), Indonesian (IN), Norwegian (Bokmal) (NO), Portuguese (ptBR), Romanian (RO), Thai (TH), Turkish (TR), Ukrainian (UK).

SAP Analytics Cloud Application Design

  • You can copy and paste technical components, including script objects and script variables, within the outline.

System Administration Notes

  • With the 2019.11 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.10

SAP is pleased to announce a new version of SAP Analytics Cloud.

Data Acquisition, Live data Connections, and Integration

  • When using SAP BW live data connection models, you can now sort measure values in charts with two-structure queries. Note that at least one additional dimension needs to be drilled down into the existing structure. Also, when using the Sort function, a specific structure member must be chosen. The sorting sequence based on one structure member is applied to all measures of the other structure members.

Stories

  • Search to Insight has a brand-new user experience and now includes support for the following new functionalities:
    • User-specific recommendations.

    • Users can now specify the search scope based on all available models, models included in the current story, or a specified model.

    • Search to Insight can now be launched using a dedicated icon in the main toolbar or the search bar on the Home screen.

    • You can now view a list of all measures and dimensions included in your models.

    For more comprehensive information, see https://www.sapanalytics.cloud/search-to-insight-functionality-explainedInformation published on non-SAP site.

Modeling

SAP Analytics Cloud Application Design

  • To find errors in your scripts, you can either use the Web browser's development tools to set breakpoints, or you can use the Application Design debug mode that lets you make use of a debugger statement in your scripts. The debug mode also generates your script comments into the transformed JavaScript displayed in the Web browser's development tools.

  • With the setUserInput and submitData APIs, you can enable the application user to change the value of a cell in a table at runtime.

System Administration Notes

  • With the 2019.10 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.9

SAP is pleased to announce a new version of SAP Analytics Cloud.

General

  • You can now set a user's profile photo with the SAP Analytics Cloud User and Team Provisioning API.

  • The sharing dialog has been updated so that it's easier to view and set the permissions on folders and files.

  • You can now assign a concurrent session license to BI users with the SAP Analytics Cloud User and Team Provisioning API.

  • You can now set user profile properties using the SAP Analytics Cloud User and Team Provisioning API. For example, you can set the user's preferred date formatting and preferred language.

Data Acquisition, Live data Connections, and Integration

  • SAP Analytics Cloud now supports extended use cases for blending with SAP BW data; for example, blending SAP BW live data models with other SAP BW live data models.

Stories

  • For your tables, you can now export the data you can see, including the data hidden in scrollable areas, as Excel-compatible XLSX files.

Calendar

  • You can now make your Calendar tasks into recurring tasks.

Planning

  • You can now create a Forecast or Rolling Forecast layout from the Builder panel; you don't need to use restricted measures anymore. The new format enables the following additional features: using time as a normal dimension; choosing the version to use for look back; and adding additional look back and look ahead periods. This new format is faster and allows planning with unbooked members.
  • Empty cells in grids and spreadsheets are now treated as unbooked cells when you copy and paste them to a table.

System Administration Notes

  • With the 2019.9 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.8

SAP is pleased to announce a new version of SAP Analytics Cloud.

General

  • You can now set the amount of time before a user session expires if the user doesn’t interact with the system. By default, the session timeout is set to 1 hour.

Analytics Hub

  • Analytics Hub now supports the following additional languages:

    • Bulgarian

    • Greek

    • Finnish

    • Hindi

    • Croatian

    • Indonesian

    • Malay

    • Dutch

    • Norwegian

    • Portuguese (Portugal)

    • Romanian

    • Slovenian

    • Serbian

    • Thai

    • Turkish

    • Ukrainian

    • Vietnamese

SAP Analytics Cloud Application Design

  • In this release, we are pleased to announce the general availability of SAP Analytics Cloud Application Design. With Application Design, you can:

    • Create and consume analytic and planning applications in SAP Analytics Cloud.

    • Experience the same look and feel as with stories, because stories and analytic applications share functionality and widgets.

    • Configure the behavior of the widgets with a large set of specific script API events.

    This flexibility lets you create a variety of analytic applications, ranging from simple static dashboards to highly customized analytic applications with numerous options to browse and navigate data.

    For more information, see Analytic Applications.

  • You can now use the SAP Analytics Cloud for business intelligence license to create, edit, or delete analytic applications. Previously, the SAP Analytics Cloud for planning, standard edition license or the SAP Analytics Cloud for planning, professional edition license was required.

    • We've introduced a new standard role, called Application Creator. This role includes all authorizations required to create, edit, view, or delete analytic and planning applications.

    • If you need to create planning models for your planning applications, you need the Modeler role in addition to the Application Creator role.

    • We've removed the authorizations to create, edit, or delete analytic applications from the Modeler and Planner Reporter roles that used to have these authorizations during the Beta phase of Application Design. These two roles now allow you to view analytic applications.

  • The following changes have been made to the Application Design API:

    • Until further notice, DataSource.setVariableValue and DataSource.getVariables are deactivated.

    • You can use the privateVersion.getOwner API to check if a private planning version is owned by the current user of the private version.

  • You can now access EntitySets exposed via OData Services by programmatic access in Application Design. Use these two new APIs in your script:

    • getEntity: for retrieving a single OData Entity from an EntitySet, by specifying the key to the entity.

    • getEntitiesFromEntitySet: for retrieving all (limited to 1000) Entities from an OData EntitySet.

System Administration Notes

  • With the 2019.8 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.7

SAP is pleased to announce a new version of SAP Analytics Cloud.

Data Acquisition, Live Data Connections, and Integration

  • When you import SAP BW data, metadata from BW such as dimensions, attributes, measures, and hierarchies that have already been created in BW are now recognized, and don't need to be recreated in SAP Analytics Cloud. To enable this capability, you'll need SAP Analytics Cloud agent version 1.0.223 or later.

  • Previously, when you imported, exported, or wrote data back to BPC using a BPC connection shared by others, BPC user credentials of the other users were stored in SAP Analytics Cloud. oAuth is now supported as a more secure way of creating a BPC connection; this enhancement ensures that BPC user credentials won't be stored directly in SAP Analytics Cloud. Instead, an oAuth token is generated to communicate between the two systems. What's more, with the combination of oAuth and SAML, you can now use single sign-on and don't need to enter credentials repeatedly.

  • SAP Analytics Cloud now supports complex filters (filtering with multiple dimensions, using the AND & OR operators) in SAP BW queries (live data connections only).

  • When you schedule jobs, the schedule timing now adjusts for Daylight Savings Time according to the time zone you select.

Stories

  • Input controls for flat dimensions (other than in SAP BW) are no longer limited to 4000 members.

  • When adding Area Name Geo Enrichment to models, you can now use country, region and subregion data to create the location dimensions for countries besides the United States. The country data can be provided as ISO3 and ISO2 codes, or the country names in English.

  • The quick menu action for table cells has changed: now when you select a table cell, you need to right-click to bring up the context menu.

  • You can now share your personal story bookmarks with others.

  • You can now create a global story bookmark and share it.

  • SAP Analytics Cloud now supports dynamic HANA input parameters. HANA variables are considered dynamic if they use an expression to determine the value.

  • In tables, you can now combine the creation of a new member for a dimension with the creation of a new line (or column) for an existing but unbooked member combination.

Modeling

Planning

  • When you're creating an allocation step, you can specify a Booking Account. With a separate booking account, you can use one account to set the values to allocate, and then execute the step on a different account.

  • You can now manage Data Locks on a model from within a story table, given the proper permissions are granted.

  • Using the instruction FOREACH.BOOKED, you can now choose to repeat statements only for each dimension combination in FOREACH that has values. Doing this can save unnecessary looping and, therefore, enhance performance.

  • Data entry in unbooked cells is now supported in more cases, including when cell locks are set in the grid and for mass data entry on accounts with different aggregation types. The performance of data entry in unbooked cells has also been improved.

  • Previously, the DATA function always overwrote existing data defined in the scope. Now you can use the instruction DATA.APPEND to append values to existing data rather than overwrite data.

Mobile

  • The SAP Analytics Cloud iOS SDK now supports AirWatch SDK Integrated authentication with Certificates. Apps built using the SAP Analytics Cloud iOS SDK integrated with AirWatch SDK are now able to pull digital certificates from AirWatch for user authentication for live connections only. For details, see the documentation here.

Analytics Hub

  • Administrators can now use the new import feature to upload the following elements: Asset Structure, Branding, Assets, "Picked for you", Asset pictures, User data, and Usage data.

SAP Analytics Cloud Smart Predict

  • From Smart Predict, you can now publish a predictive model to an existing predictive scenario in a Predictive Analytics Integrator (PAi) application. Now, publishing from Smart Predict allows you to both create new predictive scenarios, and also add new improved predictive models to those, or other existing predictive scenarios.

  • In the debrief of a classification or a regression predictive model, the variables with no influence are no longer displayed.

SAP Analytics Cloud Application Design (Beta)

  • You can call and execute OData (Version 4.0) actions exposed by a connected on-premise S/4HANA system within an analytic application. In detail, you can create an OData service, define the endpoint URL, and trigger the execution of the action by using scripts.

  • You can now use the NavigationUtils API to navigate from one of your analytic applications to another or from your analytic application to one specific page of a story.

  • With version 2019.7, we've changed the script API:

    • The selection API functions now support multi-selection. To enable this support, the getSelection() functions for tables and charts have been replaced with new getSelections() functions, which return an array of Selection objects, each representing a single selection. The properties of such a Selection object are the dimension IDs; the values are the member IDs.

    • We've removed the types Member, Measure, and Dimension. API functions returning these types (or arrays thereof) now return string or string[], and API functions with input parameters of the removed types now take the ...Info version instead.

    • We've removed the ConvertUtils.integerToString() function, as ConvertUtils.numberToString() has the same functionality.

    Please note that your existing analytic applications using these changed or removed API functions won't work anymore. You need to adapt your scripts manually for each analytic application that uses these API functions. For more details, see Using Selection API Functions for Tables and Charts.

  • You can create objects of complex types in a script using object expression notation (used for the new OData scripting options).

  • You can now customize more widget-styling settings. These include: mouse hover and select effect for a dropdown box; the background; font color; mouse interaction effect for a popup; and interaction feedback when hovering your mouse over an image or shape widget.

  • End users can now use a slider and a range slider to input numbers. The slider and range slider can be especially useful in what-if scenarios.

  • Application Designers and users can now view the recently used analytics applications directly in the SAP Analytics Cloud home page. This enhancement lets you quickly access and open these analytics applications.

  • You can now copy planning versions by using the new PlanningVersion.copy API. This API function only works for SAP Analytics Cloud models.

System Administration Notes

  • With the 2019.7 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.6

SAP is pleased to announce a new version of SAP Analytics Cloud.

Data Acquisition, Live Data Connections, and Integration

  • You can now use composite join keys to combine data from multiple imported sources.

Modeling

  • The modeling experience has been enhanced. Some of the new features are:

    • An improved user experience as the result of a clean and intuitive user interface.

    • A model overview that outlines all model objects and their attributes.

    • Account and dimension maintenance via the side panel.

    • A new hierarchy management tool (with drag-and-drop functionality for convenient management of hierarchies).

    • Support for "undo" and "redo" capabilities.

    • Easier object management via a contextual side bar.

  • Fiscal date dimensions can now be displayed as a calendar month or as a fiscal period.

Stories

  • You can now create story and page time filters based on a dynamic range, using a "custom current date" that can be set with an input control.

  • You can now change the description for measures and dimensions in your story.

Planning

  • You can now remove assignees from currently running (in progress) Input Tasks as well as from in progress Calendar tasks and processes.

  • Copy & Paste now supports the pasting of facts (all leaves underneath a node are copied) when used on restrictions.

  • This release introduces visual programming for advanced formulas. Visual programming allows business users with no expertise in programming to design a program via dragging and dropping rather than directly writing scripts. Visual formulas can be switched to script for future editing, but currently not the other way around.

    Visual programming is not a replacement for script-based advanced formulas. Scripting should remain the primary tool to define and design complicated business scenarios, while visual programming can help you quickly set up a simple business case.

    In this wave, when compared with advanced formulas scripts, there are a few functions not yet available in visual programming; these will be supported in future waves:

    • ELIMMEMBER () – Returns the names of the elimination members below the first common parent of the two companies that did inter-company trading.

    • LINK () – Copy or read data from other linked models besides the default model in the data action.

    • DELETE () – Allows users with Delete privileges to clear data facts within a certain data scope.

  • When creating a structured allocation rule, you can now use driver values from another dimension by choosing an account calculated using the LOOKUP function.

Analytics Hub

  • Administrators can now configure either SAP Analytics Cloud or SAP Analytics Hub as the default landing page.

SAP Analytics Cloud Smart Predict

  • When a user account is deleted, all private content that is not shared will also be deleted.

  • When you apply a predictive model, you can now select which variables from the input dataset you want to add to the output dataset.

SAP Analytics Cloud Application Design (Beta)

  • The API ArrayUtils.create() accepts a literal of the "Type" enum, so you as user must specify which type the newly created array should be. Previously, you could only create primitive typed arrays. Now, in addition, you can use all non-primitive types as well.

System Administration Notes

  • With the 2019.6 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.5

SAP is pleased to announce a new version of SAP Analytics Cloud.

Data Acquisition, Live Data Connections, and Integration

  • You can now create an import data connection to SAP Integrated Business Planning.

  • You can now select which sheet to import for Google Sheet files, when importing data from Google Sheets.

  • You can now directly trigger a planning sequence in an SAP Analytics Cloud story based on a live connection model to the BPC embedded system.

  • When you create a model by importing a data file, if the file is small, you now go directly to data integration without needing to select the draft data first.

  • You can now import data directly from an entity into a dataset and use it to perform predictive workflows. You can import data into a dataset from the following sources: Generic OData, SAP SuccessFactors, SAP Business ByDesign, SAP Cloud for Customer, SAP Cloud for Customer Analytics, and SAP Integrated Business Planning.

Stories

  • When calculating percentages for Variance charts and Difference From calculations, you can now set the denominator to be an absolute value. This means you will see correct percentage calculations even if the denominator is a negative number.

Calendar

  • When you submit your Calendar task, you can now choose to publish related data changes as well.

Planning

  • After creating calculation columns in tables (using running sum, moving average, or comment, for example), you can now hide the column that the calculation was based on. The calculation column will still be visible.

  • You can now create Input Tasks on Responsive pages.

  • For models with currency conversion, you can run data actions on the currency of your choice (Local or Default Currency).

Mobile

  • You can now view and interact with geo maps on the SAP Analytics Cloud mobile app. See Mobile Feature Compatibility for some limitations with geo maps on mobile in this first release.

SAP Analytics Cloud Application Design (Beta)

  • You can configure the availability of all context menu entries for each widget during the analytic application runtime in the widget's Styling panel.

  • SAP Analytics Cloud now offers a multiple-language solution for strings defined by application designers in various widgets in an analytic application.

  • The version management APIs allow you to publish or delete versions and to publish revert data from planning versions even if planning enablement hasn't been set. The following APIs are new:
    • Planning.getPrivateVersion

    • Planning.getPrivateVersions

    • Planning.getPublicVersion

    • Planning.getPubllicVersions

    • PlanningPrivateVersion.publish

    • PlanningPrivateVersion.publishAs

    • PlanningPublicVersion.isDirty

    • PlanningPublicVersion.publish

    • PlanningPublicVersion.revert

    • PlanningVersion.deleteVersion

    • PlanningVersion.getDisplayId

    • PlanningVersion.getId

    See the SAP Analytics Cloud Application Design API Reference for details.

  • You can now format a numeric value or a date value via scripting.

  • You can now use the input field widget to receive user-entered text for further processing.

  • You can now reference script variables in formulas in calculated measures.

  • You can now use the improved value help for a function parameter of type enum. The value help now lists all enum literals on top of the proposal list on the very first Ctrl+Space click, so they can be directly accessed.

  • You can now get value help for widgets (for example, table/chart) that are assigned to local variables. This value help is only available if there is only one declaration of the local variable and no subsequent assignments to that variable. The declaration must also be at top level, so that declarations in other block statements (for example, "if" "for" "while") will not be supported.

    Fuzzy matching is automatically applied when you write code by using code completion. There is also now value help for RWidgets, SmartDiscoverySettings and DataExplorer functions (like getDataSource().getDataExplorer().setAdditionalDimensions).

  • You can now get the user ID of the current SAP Analytics Cloud user who is executing the application by using the following scripting API: Application.getUserInfo()

    The new API returns an object of type "UserInfo" with two properties "id" and "displayName", which contain the information from the corresponding columns in the user database table.

System Administration Notes

  • With the 2019.5 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.4

SAP is pleased to announce a new version of SAP Analytics Cloud.

General

  • As an administrator, you can now monitor information on the creation, deletion, and modification of Security Roles, Users, and Teams.

  • The SAP Analytics Cloud User & Team Provisioning API is now available on SAP API Hub.

  • You can now upload macro-enabled Excel files (.xlsm) to the SAP Analytics Cloud file repository.

Data Acquisition, Live Data Connections, and Integration

  • Connecting to S/4HANA on-premise systems through a front-end server is now supported.

  • SAP Analytics Cloud supports Geo layers in SAP BW/4HANA. With this feature, you can display the result of a query on a Geo map. Geo coordinates defined as longitude and latitude attributes in SAP BW are used for location analysis within SAP Analytics Cloud. For more details on supported versions of SAP BW on HANA and SAP BW/4HANA, see SAP Note 2715030Information published on SAP site.

  • You can now create SuccessFactors queries that use "effective dates". Use effective dates to feed data into workforce planning models or to generate reports that show changes in headcount over a specified time range.

Stories

  • In Tables, you can now change the order of Account members, including Calculated measures, that are on the same hierarchy level.

  • To see the Measure Descriptions instead of the Measure IDs for Calculated Measures, you can now select any point in the Calculation Editor outside the formula editor area.

  • SAP Analytics Cloud now supports Variance charts for SAP BW.

  • For waterfall charts, the nested axis labels have been changed: the primary dimension label has been moved to its own line.

Planning

  • For Input Tasks and Calendar tasks, you can now specify what actions occur when the task due date is reached.

  • For Calendar tasks, you can now set up a reviewer chain: when one review is done, the task automatically passes to the next reviewer.

  • In Advanced Formulas in Data Action, you can now use the Link function to copy or read data from other models besides the default model of the data action.

Mobile

  • The menus, buttons, messages, and other elements of the user interface in the mobile app now respect your device language settings. For details, see Mobile Feature Compatibility.

SAP Digital Boardroom

  • When you filter an SAP Digital Boardroom topic, the filter is now applied to its subtopics too.

  • The Lane Setup options for an SAP Digital Boardroom presentation have been simplified. For more information, see Presentation Settings and Theming.

SAP Analytics Cloud Smart Predict

  • The debrief reports for a predictive model containing more than 20 segments are now generated individually on demand by the user, and not automatically during the training process. Each segment can be selected from a drop-down list and its debrief is generated for the user. For predictive models with less than 20 segments, all the debrief reports are created during the training and are all available at the end of training.

SAP Analytics Cloud Application Design (Beta)

  • Previously, script variables could be defined with some primitive types, such as string, Boolean, number, and integer. Now there’s a wider variety of non-primitive types for script variables, such as Table, Chart, Button, and Clock.

  • You can now define script variables as dynamic text in text widgets.

System Administration Notes

  • With the 2019.4 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.3

SAP is pleased to announce a new version of SAP Analytics Cloud.

Data Acquisition, Live Data Connections, and Integration

  • You can now use the unpivot transform to transpose columns into rows when preparing data.

  • You can now import data from systems on different on-premise networks.

  • SAP Analytics Cloud now supports data blending (done via the web browser) between live data models from SAP BW, and data models based on imported data stored in SAC. No additional hardware deployment or licensing is required. Ensure that your SAP BW system has the latest SAP Notes applied, depending upon your deployment:

  • SAP Analytics Cloud now supports data blending (done via the web browser) between imported models and browser-based SAP HANA models.

  • You can now share import data connections with other users in your system. You can also give others rights to edit a connection.

Stories

  • You can now create Waterfall charts when you have a BW datasource.

  • When you deselect all values in a page or story filter, the related visualizations wait for you to select a value before refreshing.

  • For tables based on BW datasources, you can now change the order that the measures are displayed in.

  • In Waterfall charts, you can now have four colors, one for each of the four members; Increase, Decrease, Subtotal, and Total. You can also customize the color of the Subtotal member.

  • SAP Analytics Cloud charts now support the Short/Medium/Long text setting in BEx queries.

  • In tables, you can now create "full context" calculations, calculations that apply to a single column or row instead of to a member.

Calendar

  • You can now see the context of your Input Tasks listed in the Calendar task panel.

  • For Calendar tasks, the style options are now beside the task title instead of in a separate panel.

Modeling

  • We've moved models from the Models list to the Files list. To understand why we made this change, and how it might affect you, see this white paper.

Planning

  • You can now use input values from any different data version when running a predictive forecast.

  • In tables that show only booked data, you can now make one existing combination of members visible that does not yet have booked data.

  • When planning on BPC Live connection models, you can now enter values using mass data entry mode.

  • When creating a data action, you can now use calculated accounts and accounts with exception aggregation for Cross-Model Copy Actions.

  • The performance of advanced formulas is further enhanced. Now only selected records are loaded by parsing the MEMBERSET functions and all formula statements; unnecessary FOREACH loop statements are detected in the Data Action designer, and a warning message is provided. This is done automatically for newly created advanced formulas data actions. For advanced formulas created before release 2019.3, you need to re-save the data actions first.

  • In tables, you can now enter amounts that are less than 1 without the leading 0. For example, you can enter ".194 Million" instead of "0.194 Million" or "-.194 Million" instead of "-0.194 Million".

  • For tables, you can now show the option "Reason for unplannable data" on canvas and responsive pages.

Mobile

  • You can now annotate a Story or Boardroom page by drawing or adding text on the page image. When you're done, share the screenshot with your colleagues.

  • If you use VMware AirWatch in your organization to deploy and manage mobile apps, integrate the AirWatch SDK with the SAP Analytics Cloud iOS SDK to take advantage of AirWatch SDK features. Read the SDK help here.

  • The SAP Analytics Cloud mobile app now requires iOS 11.0 or later. iOS 10 is no longer supported. See System Requirements and Technical Prerequisites for details.

SAP Analytics Cloud Application Design (Beta)

  • During analytic application runtime, you can now create a story from a chart or table with all the settings and data statuses, such as filters, inherited.

  • The Outline panel in the analytic application is now redesigned. Canvas and popups are now displayed under the Layout tree while script objects and script variables are now displayed under the Scripting tree. Global variables are now renamed as script variables.

  • You can now add a script to a widget from the quick action menu. Also, you can now comment/uncomment a script line in the script editor with the keyboard shortcut Ctlr+ # (for Microsoft Windows).

  • You can now use predictive forecast functionality in application design by clicking the Predictive Forecast button in the tool bar of an analytic application at runtime. Also, more planning APIs are now available for you:

    • Application.refreshData();

    • Table.getPlanning.isEnabled();

    • Table.getPlanning.setEnabled(boolean);

  • You can now use not only primitive types, but also a wide variety of types like "Button", "Dimension", "Date", "Feed" and so on, for:

    • The return type of script functions.

    • The type of script function arguments.

    Also, primitive types are now displayed with lowercase first characters, to have a consistent display across the design time: "void", "string", "integer", "boolean", "number".

System Administration Notes

  • With the 2019.3 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.2

SAP is pleased to announce a new version of SAP Analytics Cloud.

SAP Analytics Cloud Smart Predict

  • From Smart Predict, you can now publish a predictive model to Predictive Analytics Integrator (PAi) as a new predictive scenario. This facilitates the creation of predictive scenarios in PAi and is a simple way to extend automated predictive modeling to an external application with predictive capabilities.

System Administration Notes

  • With the 2019.2 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

Version 2019.1

SAP is pleased to announce a new version of SAP Analytics Cloud.

General

Data Acquisition, Live Data Connections, and Integration

  • You can now create a generic OData import data connection to OData version 4.0 sources.

  • To better guide you, and to keep a consistent look and feel with other data sources, we have changed the entire BPC import and export process. The major changes are as follows:

    Workflow
    • Import and export processes are now done in a step-by-step wizard rather than in one dialog.

    Query
    • In the new import process, we separate the selection of dimensions and filtering of dimension members from dimension mapping.

      Previously you specify BPC dimensions and filter dimension members to be imported in the Mapping dialog. Now we offer a dedicate step Build SAP BPC Query to do the selection and filtering.

    • In the new import process, you can choose whether you want to build a new BPC query starting from scratch or reuse an existing query derived from previous import jobs as a template.

    Others
    • In the new import process, when importing data to a basic model, you can create dimensions either as public or private dimensions.

    • A brand new mapping dialog is available. In addition to dimension mapping, you can also configure the currency dimension (where the local currency is taken from) in the mapping dialog.

    For detailed steps about BPC data import and export, you can refer to Importing SAP BPC Data to a New or Existing Model or Exporting data to SAP BPC.

    Also before importing data to SAP Analytics Cloud, make sure you check the minimum BPC support package for import and apply all required notes specified in System Requirements and Technical Prerequisites.

  • Users can now connect using a Generic JDBC driver and can also connect to many additional databases. For a list of the additional databases, see System Requirements and Technical Prerequisites.

  • When importing data into a model, dimension, or story, you can now more easily filter through the list of datasources to select a datasource.

Stories

  • For tables, you can now create Cross Calculations for measure-based models.

  • For tables, you can now add table-specific dynamic text to the table title.

  • You can now combine data from multiple acquired sources in the data preparation tool.

  • Search to Insight now understands fiscal phrases, such as “Show sales for fiscal year 2018”.

  • You can now specify refinements such as greater or less than to measures when using Search to Insight.

  • Live HANA models, on most recent HANA 2.0 revisions, now also support the following features that were introduced for acquired data models in previous waves:

    • You can now use the ToNumber(…) function to convert string values to a number in calculated measures or calculated dimensions. Also, a new Dimension to Measure story calculation type is available to convert a dimension to a measure, using a specified dimension context and aggregation operation.

    • You can now use the ToText(…) function to convert numeric values to a string in calculated measures or calculated dimensions. The Measure-Based Dimension calculated dimension form has also been enhanced to allow for measure to dimension conversions with a given scale and precision (in addition to the already available dimension and filter context).

    • In charts, tables, and tooltips you can now change how your units and currency are displayed as well as where the units and currency symbols should be placed in relation to the numeric values.

    • For tables, you can now create Cross Calculations.

  • In tables, you can now display the ID and Description in separate fields.

Calendar

  • You can now pin your Calendar to your home screen, making it easy to quickly see your tasks.

  • In your Calendar tasks, you can now more easily handle large numbers of assignees.

  • You can now see when tasks are only partially accomplished.

Allocations

  • When creating an allocation step, you can choose whether to keep the values of the source cells and whether to overwrite the values of the target cells. These options are then taken into consideration during execution, allowing structured allocations to be executed multiple times leading to the same results (without actually moving values but by copying instead).

Planning

  • In Advanced Formulas, you can now define the version dimension in a RESULTLOOKUP function to read data from another version.

  • A new function called DELETE has been introduced in Advanced Formulas to support delete data facts in a model.

  • When you start to type an inverse formula, you can now complete it by selecting a suggested inverse formula from the hint list.

Modeling

SAP Analytics Cloud Application Design (Beta)

  • As an application designer, you can now use script objects in analytic applications to group a set of functions. A function can be used to encapsulate certain script logic used in different other script functions like event handlers. This avoids duplicating code and makes maintenance of applications easier.

  • The following API functions are new:

    • DataSource: setMemberDisplayMode, getMemberDisplayMode, getMeasures

    • Chart: getDimensions, getMeasures

    • Table: getDimensionsOnRows, getDimensionsOnColumns

    The following API functions have changed:

    • DataSource: copyDimensionFilterFrom

    • Chart: addMeasure, removeMeasure

    Also, the type Dimension has been introduced and can be used as an input parameter for several API functions that currently use the type DimensionInfo. Now you can use both types: Dimension and DimensionInfo.

  • The product now provides a PostMessage API to allow application designers to enable communication between a host HTML page and an analytic application embedded inside an iFrame on the host HTML page. The change also allows communication between an analytic application and an HTML page embedded in it, via the analytic application’s Web Page tile.

System Administration Notes

  • With the 2019.1 release of SAP Analytics Cloud, SAP Analytics Cloud agent's minimum version remains at 1.0.75, with the following exceptions:

    • If you require data acquisition from SAP ERP / SQL Database, the minimum version is 1.0.99.

    • If you require data acquisition from SAP Universe (UNX), the minimum version is 1.0.91.
    • If you require data acquisition from SAP Business Warehouse (BW), the minimum version is 1.0.109.

    For more information, see System Requirements and Technical Prerequisites.

  • Regarding supported features and required updates for the integration of SAP BW with SAP Analytics Cloud, refer to SAP Note 2541557Information published on SAP site for further details.

  • For information on new features introduced in versions of SAP Analytics Cloud from 2018, see 2018 Releases.

  • For information on new features introduced in versions of SAP Analytics Cloud from 2017, see 2017 Releases.

  • For information on new features introduced in versions of SAP Analytics Cloud from earlier than 2017, see the SAP Notes here.