2019 Releases

General

• You can now add your own custom fonts to use in Stories and the Digital Boardroom.

• You can now choose Danish as your user interface language for SAP Analytics Cloud.

• You can now add comments to the data cells of a table based on acquired Analytics Models. As an administrator, you can define the limit of dimension members as a condition to enable or disable commenting on data cells. This means, if the count of dimension members is more than the value defined by you, then commenting on data cells will be disabled.

Data Acquisition, Live Data Connections, and Integration

• When using SAP Universe Live Data Connections, you can now resize the Query Panel and employ it in full-screen mode.

SAP Digital Boardroom

• In a Digital Boardroom presentation, you can now combine the action bar with the header or footer to save screen space. See the Action Bar section of Presentation Settings and Theming for more information.

Analytics Designer

• You can improve performance by merging queries from SAP BW or SAP HANA for multiple charts in the Analytics Designer.

Smart Predict

• The following improvements have been made to debrief reports for time series forecasting predictive models:

  • The relative contribution of the influencers has been added to time-series predictive models debriefing.

  • The Signal Analysis tab contains newly designed sections for signal components with improved textual descriptions to help interpret the Trend, Cycles, and Fluctuations.

  • Forecast and Signal Analysis reports are now available as tabs.

  • The content of the time-series predictive models debrief has been reorganized to make the information grouping more meaningful.

System Administration Notes

• With the 2019.24 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.233.

  • If you require data acquisition from an SAP HANA view, the minimum version is 1.0.235.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.254, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

• Regarding supported features and required updates for live universe access through SAP BusinessObjects Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

Data Acquisition, Live Data Connections, and Integration

• You can now create connections to SAP HANA 2.0 without creating an HDI container. See Live Data Connection to SAP HANA 2.0 on SAPCP Cloud Foundry (Without HDI Containers) for details.

Stories

• When you have a chart with threshold values, you can now include the threshold legend in the chart.

• You can now add an image or a color gradient to the background of your responsive pages and lanes.

Planning

• When exporting data to S/4HANA, using OData Services, previously, if the target S/4HANA key-figure amount was a currency, you could map it to a currency and export the number of different currencies involved. Now, in addition to that, if the target S/4HANA key figure is a quantity, you can also map it to a unit dimension and export the quantities of the different units.

• You can cut and paste cell values by pressing Ctrl+X and Ctrl+V, or Cmd+X and Cmd+V. The cells that you cut become unbooked when you paste them.

Smart Assist

• To help you make better business decisions, Smart Insights now brings you top contributors for all generic dimensions, even those with a very large number of dimension members. For variances, Smart Insights now supports up to 30 dimension members.

• You can now get Smart Insights on a data point that was calculated using the average aggregation type.

Analytics Designer

• You can now add a new text-area widget to an analytic application. The widget is similar to the input field widget, but different in that it can wrap text automatically based on the size of the widget and the line break entered by application users. This is especially useful when you post or get a long text from comments and descriptions.

• As a user of the Analytics Designer API Reference, you can now use and consume the following improvements that highly broaden the ease of use of the API reference:

  • The wave version of the API reference is displayed in the browser tab and in the first link of the "Contents" section, for example "API Reference Version 2019.23".

  • The link "API Reference Latest Published Version" in the "Contents" section navigates to the latest publicly available version of the API reference.

  • Class, field, method, and event API additions are listed in their documentation with the wave version of their addition under the heading "Since". Class, field, method, and event API updates are listed in their documentation with the wave version of their update under the heading "Last Update".

  • Direct subclasses of a class are listed in the class documentation under the heading "Direct Subclasses". For an example, see the documentation of class "Widget".

  • Each class in the "Contents" section has decorator icons indicating special capabilities of the class:

    • An icon with the letter "D" indicates whether the class contains fields or methods that can be directly accessed in the script editor without creating an instance of the class (sometimes called "static" fields and methods in other programming languages).

    • An icon with the letter "T" indicates whether the class can be used as a type in method arguments, return values, or global script variables.

  • The API reference shows the type library information of each class. All classes are grouped into type libraries. This is useful information for developers who create widgets with the Custom Widget SDK.

    • Each class displays the type library name of the class in its heading.

    • The type library name is a link that navigates to an overview page, listing type libraries and their classes.

    • The class list in the "Contents" section can be grouped by type library.

Smart Predict

• Smart Predict has reduced the differences experienced when creating a predictive model on either a live or acquired dataset. This alignment, for now, requires that all predictive models created before release 2019.23 using acquired datasets, must be retrained to view their debriefs. This also applies before they can be applied to new datasets.

System Administration Notes

• With the 2019.23 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.233.

  • If you require data acquisition from an SAP HANA view, the minimum version is 1.0.235.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.251, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

• Regarding supported features and required updates for live universe access through SAP BusinessObjects Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

General

• The Content Network, Translation, and Analytic Application Bookmarks can now be accessed from the Browse menu instead of in the Files area. See Content Folders for details.

Data Acquisition, Live Data Connections, and Integration

• For customers who are switching on, or have already switched on, Custom IdP, you can now configure IdP-initiated SSO for SAP Data Centers. You can also choose SAP Analytics Cloud log-off behavior, to log off from your IdP or only SAP Analytics Cloud and remain logged in to your IdP.

• The system owner can now update and manage IdP metadata in SAP Analytics Cloud.

• You can now omit validation for specific hierarchies, to allow non-leaf members to contain fact data, when importing data into public dimensions.

Stories

• You can now create exception aggregation story calculations for Live BW models. See SAP Note 2781149 (general 7.50 SP16 note) for more information.

• You can now create a time-based variance in charts based on a Live BW model that has a time hierarchy defined. See SAP Note 2786890 for more information.

Modeling

• You can now delete private versions belonging to a model; for example, if you need to remove model dependencies so that users can upload and delete model data.

Mobile

• The mobile app now supports BW BEx variable prompts for fiscal year and currency.

• The mobile app now runs on iOS 13 for supported devices.

Analytics Designer

• You can now use the data source prompt API DataSource.setVariableValue(). Please note the following:

  • The DataSource API setVariableValue is not supported for hierarchy node variables for live data connections to SAP BW.

  • The DataSource API setVariableValue is not validating the values specified (neither at run time nor at design time). All values and value combinations that are accepted in the prompt dialog will be supported. All other combinations might lead to errors or to an inconsistent state.

• As an application designer, you can now leverage the setTheme() API to allow end users to flexibly change their theme when running an application. You can also add the theme ID to an application's URL to allow users to initially load a theme when running the application.

• You can now use data-locking APIs to check if a model is data-locking enabled and to set or get data locks, even if the table is not planning enabled. You can use the following APIs for data locking:

  • Table.getPlanning().getDataLocking

  • Table.getPlanning().getDataLocking.getSate

  • Table.getPlanning().getDataLocking.setState

System Administration Notes

• With the 2019.22 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.233.

  • If you require data acquisition from an SAP HANA view, the minimum version is 1.0.235.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.249, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

• Regarding supported features and required updates for live universe access through SAP BusinessObjects Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

General

• Administrators can now assign copy privileges for files and folders.

SAP Digital Boardroom

• You can now add the Reset Topic and Refresh Topic buttons to the Action Bar for a Digital Boardroom presentation.

Modeling

• You can now delete all members of a dimension, even if some members haven't been loaded into the Modeler yet.

Calendar

• When you're working on a story that's part of a calendar task, you no longer need to switch back and forth between the Calendar and the story. You can now check the details of the task and submit your work within the story.

• If the work on a task or process is blocked, you can now change the status to On Hold. Resume or discontinue the task or process when you're ready.

Stories

• The right-click menu for tables now provides more options.

• We have reduced data label collision for line charts and combined (stacked) bar and line charts. Data labels will be shown above and/or below their data points instead of being hidden if they collide.

  Note

  For complex cases, some labels may still be hidden.

• If you accidentally delete a story widget, an option to restore the widget will appear for a limited time.

• There are more options for dynamic time filters for charts and tables. You can apply offset ranges, apply common filters using shortcuts, and see suggestions for time-based variances.

• You can now specify font styling options for error messages in charts.

• You can now customize the error message displayed when a chart contains no data. Note: this setting is only available in the administration settings for the your system.

• Smart Insights now detects significant changes in your data over time, and presents the information as a textual insight, and a chart. To help you better understand your data, the Smart Insights panel now displays up to two types of Smart Insights simultaneously. You can see how your selected data point has changed over time, and what its top contributors are, or how it was calculated. Smart Insights also offers you the flexibility to go back, step by step, to the original insights provided, if you choose to drill down further into the top contributors to your data point.

• The spatial data for SAP Analytics Cloud now contains the United Kingdom at the "Country" level, with England, Scotland, Wales, and Northern Ireland at the Region level.

Planning

• For advanced formulas, the following new functions and options are now available:

  • Business function CarryForward() first carries forward account balances to the opening amount of the new periods, then recalculate the account balances of the new periods based on the new opening amount.

  • Time functions:

    • DAY(), MONTH() and YEAR() respectively return the day, calendar month, calendar year in a date. The day, month, and year returned will be in number format such as 31, 12, or 2019.

    • PERIOD() converts a date to a time period based on the time granularity.

    • DAYSINMONTH() and DAYSINYEAR() respectively returns the number of days in a specific calendar month or year. The month or year can be taken from an exact fixed date, time dimension, or dimension attribute defined in these time functions.

    • DATERATIO() calculates how many days between the start and end date overlaps a given period. Then divides the overlapping days by the total number of days in the period.

  • Use the CONFIG.HIERARCHY() function to specify the hierarchy of one or more dimensions you will be working on throughout the entire script.

  • For the visual tool:

    • Use the option "Repeat for booked members only" to repeat statements only for booked members when creating advanced formulas. Booked members refer to the dimension combination in the repeat scope that has values. This can save unnecessary looping and therefore enhance the performance.

    • In addition to the overwrite mode, you can choose to append data in the target scope.

• When If you're using longer node titles for a value driver tree, you can set a Minimum Node Width to make sure that they're readable.

Analytics Designer

• As an application designer, you can now adjust widget size and position dynamically when the canvas size changes. This will enable you to automatically fit the widgets to the modified canvas size.

• As an application designer, you can now iterate over the result set based on an input data selection.

• As an application designer, you can allow users to export an application as a PDF. Only content visible on your application page can be exported.

• To improve your work efficiency and design accuracy, you can align the position of multiple widgets (such as charts, tables, images, text, images, etc.) when designing an analytic application.

• In this release, we are pleased to announce the general availability of the SAP Analytics Cloud Custom Widget SDK. The SDK lets you extend the predefined set of widgets provided by the Analytics Designer for your custom widgets. For more information see: https://help.sap.com/viewer/0ac8c6754ff84605a4372468d002f2bf/2019.20/en-US.

• New functionality in the Data Analyzer includes:

  • You can now enable universal display hierarchies by using the "Compact Display" context menu for rows or columns.

  • In the "Available Items" panel, we can now display hierarchies in measure structures.

  • In the Builder panel, you can now reorder measures of non-hierarchical measure structures.

  • You can now use a table context menu to add calculations.

• In Security  Roles, the previous privilege named Application Bookmark has been renamed to Global Application Bookmark. The privilege still controls the security settings of both global and private bookmarks. In the next wave, we will separate private analytic application bookmark settings from global bookmark settings.

Content Network

• You can now share private content to systems in different landscapes.

• As an administrator, you can now transfer multilingual content (within your story) between systems in your landscape.

System Administration Notes

• With the 2019.20 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.233.

  • If you require data acquisition from an SAP HANA view, the minimum version is 1.0.235.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.245, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

• Regarding supported features and required updates for live universe access through SAP BusinessObjects Enterprise Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

General

• When sharing Files, Folders, or Stories, you can now choose whether to send an email to new users.

Data Acquisition, Live data Connections, and Integration

• You can now use SAP BW smart queries to improve performance in stories that contain several charts. In such cases, query requests are now combined. The combinations allowed depend on several factors, one of them being that the queries share the same dimensions.

• Now if you enable the setting "Use Characteristic as Key Figure" in a BPC live connection model for a specific characteristic, SAP Analytics Cloud treats this dimension as a measure, which can be used normally like other measures, for example:

  • In a planning table, you can freely edit the measure that was transformed from a dimension.

  • The value of the measure can be disaggregated.

  • You can copy and paste values of the measure or do mass-data entry.

  • In Digital Boardroom, you can edit the measure like others.

• You can now import data from SFTP data sources using Open Connectors.

Stories

• You can now specify which details listed under the Show/Hide action menu should be displayed in your chart.

• When creating a date range filter for a chart or table, you can now choose the Unrestricted Drilling option to allow drilling to any level in the hierarchy, no matter what the filter or date granularity is set to.

• When you have two (or more) charts with the same hierarchy level and a linked analysis is set up, changing the drill level in one chart will change the drill level in all of the linked charts.

Planning

• For tables, when you publish a private version and make it public, you can now choose to publish the private comments as well.

• For tables, you can now use context (right-click) menus to perform many actions that previously you could only do from the Builder or Version Management panels. For example, you can change how data is displayed in the table (Description or ID) or you can copy a version to create a private version.

• The default template for Tables now has a white background and distinctive formatting for heading cells, particularly when you have different versions in your table.

• You now have the ability to change the color of the expand/collapse (drill) icon in your tables: apply a dark background to your table cells and a light color to the drill icon. All the options are listed here: Styling Options for Tables on a Canvas Page.

Analytics Designer

• As an application designer, you can now define a timer to delay the trigger of script calls.

Content Network

• In the My Content page, you can now use security settings to determine which systems can share content with you.

System Administration Notes

• With the 2019.19 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.233.

  • If you require data acquisition from an SAP HANA view, the minimum version is 1.0.235.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.243, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

• Regarding supported features and required updates for live universe access through SAP BusinessObjects Enterprise Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

Analytics Designer

• With this version, we've changed the calculation handling for account dimensions in script APIs. Before this change, member IDs looked like this "[Account_BestRunJ_sold].[parentId].&C4A#CALC0". After the change, the member identifiers are GUIDs and look like this "25880968-9230-4045-b252-417449111942". All script methods accepting or returning member IDs will use the new member IDs (GUID format). If you have used a hard-coded member ID in a script API such as setDimensionFilter or getData on the data source in your application, you need to change it to the new format.

• When running an analytic application, you can now add comments either to a widget or a cell of a table for which planning is enabled. Widgets that you can add comments to include chart, table, geo map, image, shape, text, RSS reader, web page, R visualization, and clock. In the view mode, you can directly show or hide all comments in the toolbar; while in a embed mode, you can leverage corresponding APIs to show or hide comments.

• As an application designer, you can use \n as a control character to force line breaks when using the applyText() API of a text widget.

Mobile

• When deploying the SAP Analytics Cloud app through Microsoft Intune, you can now push default supported configurations.

System Administration Notes

• With the 2019.18 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.233.

  • If you require data acquisition from an SAP HANA view, the minimum version is 1.0.235.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.241, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

• Regarding supported features and required updates for live universe access through SAP BusinessObjects Enterprise Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

Data Acquisition, Live data Connections, and Integration

• Data from a file server can now be uploaded in the background, while you work on other tasks. Also, file server connections can now be shared.

• You can now export data to a file hourly.

• For SAP BW, you can now display the values for Grand Total and percentage Grand Total in tables and charts by using the functions GrandTotal() and %GrandTotal(). The SAP BW behavior regarding calculated measures has been adjusted to the SAP HANA behavior.

Stories

• You can now get Smart Insights on data points that are based on calculations.

• When creating a Time-based chart, you will now see suggestions for adding a time-based variance to the chart.

• When you add a chart to your story, you will now see some recommendations for variances that you can use to build a more meaningful chart.

• You can now sort your chart data using more than one dimension.

• You can now control whether or not anyone viewing the story can delete geo or chart filters.

• When viewing a time-based chart, you will see suggestions for variances that you can add to that chart.

Planning

• In a story created with a BPC Live Connection, the entry lock status of the back-end BPC system is now synced with the status of the planning-enabled option of the table in the story.

Modeling

• You can now enable translations of model and public dimension metadata, in addition to stories.

Analytics Designer

• In an analytic application, you can now run Smart Insight for a table widget.

System Administration Notes

• With the 2019.17 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.233.

  • If you require data acquisition from an SAP HANA view, the minimum version is 1.0.235.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.239, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

• Regarding supported features and required updates for live universe access through SAP BusinessObjects Enterprise Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

General

• You can now decide if people viewing a story can delete its filters.

Data Acquisition, Live data Connections, and Integration

• For Live Data Connections to universes, aggregations in stories are now supported.

• When connecting to newer versions of SAP S/4HANA, the authentication method "SAML Single Sign On (Standard Compliant)" is now available. This authentication method simplifies the live data connection setup.

Stories

• For Radar charts, you can now change the color of the axis and grid lines.

Planning

• You can now export data to SAP IBP (SAP Integrated Business Planning) directly via an IBP connection and schedule export jobs regularly based on your needs.

• When adding new members to a table, you can now set the Read and Write permissions at the same time.

Analytics Designer

• As an application designer, by adding a bookmark scripting object and leveraging the Save API, you can now allow end users to save different states of an analytic application as bookmarks. After creating the bookmarks, application users can either view all available bookmarks, edit or remove any bookmarks in the File Repository, or directly view and delete any bookmarks in the analytic application with the help of their application designer.

• As an application designer, you can now add a tab-strip widget that contains multiple tabs. The new widget enables you to group other widgets together tab by tab so that you can move, show, or hide all widgets in a tab as a whole.

• We've further improved application initialization performance by automatically applying lazy rendering (loading content as it's needed) to invisible chart widgets not affected by chart scaling settings. A chart is invisible when it is hidden or the container storing the chart is hidden. During the process, the APIs of invisible data-bound widgets work as usual even though the widgets are not rendered. Later, when you make the widgets visible again, all data in them will be automatically rendered.

System Administration Notes

• With the 2019.16 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.233.

  • If you require data acquisition from an SAP HANA view, the minimum version is 1.0.235.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.239, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

• Regarding supported features and required updates for live universe access through SAP BusinessObjects Enterprise Live Data Connect with SAP Analytics Cloud, refer to SAP Note 2771921 for further details.

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 data sources.

• 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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.235, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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

• When data labels in your bar charts overlap, you can now change the priority for which bars show the labels.

• You can now use Search to Insight to search within live BW and S/4 HANA data models.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.233, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

Data Acquisition, Live data Connections, and Integration

• Exports to SAP S/4HANA now run in the background, so you can continue to work on other tasks.

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 2732879).

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.231, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.229, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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-explained.

Modeling

• You can now have multiple date dimensions in planning models as well as in analytic models.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.227, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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.

  Note

  The old forecast layout process can still be used but will be deprecated at some point.

• 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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.227, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.225, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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

• Models are now available in the Files area.

• Points of interest (POIs) are now available in the Files area.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.223, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.221, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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 iOS Mobile App 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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.219, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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 2715030.

• 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 iOS Mobile App 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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.217, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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 Note 2737952 – SAP Analytics Cloud browser blending with SAP BW 7.5

  • SAP Note 2737953 – SAP Analytics Cloud browser blending with SAP BW4/HANA

• 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 data source.

• 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 data sources, 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.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.215, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.214, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.

General

• If you use Google Drive, you can now export your story as a Google Slides presentation.

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 data sources to select a data source.

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

• You can now have multiple date (hierarchy) dimensions in acquired data models.

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.

  • Note

    Although it is not required, you can upgrade to the agent version 1.0.211, no matter what data acquisition type you use. Do this to take advantage of updates made to SAP Analytics Cloud agent.

  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 2541557 for further details.