What's New – 2019 Releases

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

Version 2019.8

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

Application Design

Application Design is released for everyone!

We are pleased to launch Application Design in SAP Analytics Cloud! Application Design enables advanced scripting with a rich set of capabilities for professional designers of analytic applications for multiple business, planning, and predictive scenarios. With Application Design, you can drive standardization of centrally governable analytics content, create reusable UI elements and application logic (such as headers, footers, toolbars), and extend applications via custom widgets and APIs. Stories and analytic applications share functionality and widgets, so business users experience the same look and feel at view time.

There are similarities between stories and applications:

  • Applications and Stories share functionality and widgets

  • Applications and Stories provide same user experience

  • Applications and Stories are different artifacts

  • Applications and Stories are created with different Design Environments

Want to see more details on Application Design capabilities? Please navigate to the SAP Analytics Cloud Product PlanInformation published on non-SAP site.

Planning

  • Create full context calculations

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

  • Data entry enhancement

    Efficiency is key, in tables you can enter values that are less than 1 without the leading 0. For example, you can enter ".194 Million" instead of "0.194 Million".

  • Show option for reason for unplanned data

    For tables, you can now show the option "Reason for unplannable data" for cells that are not input-enabled.

  • Unbooked data table enhancement

    In tables, you can now easily display and enter data for selective unbooked dimension member combinations.

  • BPC integration – Mass data input for BPC live connection

    You can now submit data via mass data entry mode into BPC live models.

  • Copy Calculated Accounts across Models for Data Actions

    When creating a Data Action, you can now add Cross-Model Copy Actions that copies data from calculated accounts across models.

  • Advanced Formula performance improvements

    Advanced formulas keep on getting better! Now only selected records from version data are loaded by parsing the MEMBERSET functions and all formula statements. Unnecessary FOREACH loop statements are detected in syntax validation.

    Please note that you must resave any Data Actions created before release 2019.3 for the performance improvements to be realized.

  • Context information for input tasks in Calendar view

    Find all your information in one place. You can now see context information for your Input Tasks that are listed in the Calendar view. Context allows you to link calendar task or process to any SAC model or story.

  • Calendar style improvements

    Easily style your task titles in Calendars. The style options are now beside the task title instead of a separate panel.

  • Use input values when running a predictive forecast

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

  • Specify actions at due date for input and Calendar tasks

    Input and Calendar tasks just got more intuitive. Now you can automatically complete your tasks at due date and control assignee status transitions at task completion. This means that you can complete the task automatically but also control how the data is completed depending upon the current process state of the individual node.

  • Reviewer chains for calendar tasks

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

  • Link functionality for Data Actions

    Like the ability to link to source models utilizing account formulas, you can now use the link function within advanced formulas to copy or read data from other models.

  • Custom sorting for account dimensions in table

    Enjoy more control with your tables with the new ability to edit the order of account dimensions from import models.

  • Option to publish data collection tasks with your calendar tasks

    When you submit your Calendar task, you can now choose to publish data collection tasks as well.

  • Create input tasks on responsive pages

    Input tasks can now also be created with Stories containing only responsive pages.

  • Hide referenced columns of front-end calculations

    Less is more! After creating calculation columns in your tables (such as running sums, moving averages, etc.), you are now able to hide the column(s) that the calculation was based on while the calculation column remains visible.

  • Data Actions – Option to select target currency

    Fancy using euros over dollars? Or prefer working with your local currency? For models with currency conversion, Data Actions can now be run on the currency of your choice. You have the option choose between default and local currency. This selection is used to create the version in Edit mode in the selected currency. However, please note that this setting will be ignored for private versions.

  • Trigger planning sequences in stories via live connection to the embedded BPC system

    With just a simple click, Story Designers can now include a BPC Planning Sequence widget allowing Planners to easily trigger remote BPC calculation logic. Variables of these planning sequences can be set in the Stories. Please note that the BPC Work Status function can be used, although the planning function type file upload is currently not yet supported.

  • Remove assignees from input and calendar tasks

    Need to switch team members in the middle of project? Seamlessly remove assignees from input tasks that are currently in progress.

  • Respect leaf waiting when copying and pasting

    When working with forecast layouts, you can conveniently copy and paste facts from one restricted measure to another, including leaf members. Keep in mind that facts must be defined on the same set of dimensions, and copying must occur on the same granularity.

  • Structured allocation enhancements

    Want better integration between different versions? We now support using drivers from other versions. When creating this structured allocation rule, choose an account calculated using the LOOKUP function.

  • Visual Formulas

    If you have limited expertise in programming, don’t fret! Visual Formulas allows you to write Advanced Formula rules by simply dragging and dropping.

  • Process loop statements only against booked cells

    No more unnecessary looping! Using FOREACH.BOOKED, you can now choose to repeat statements only against booked cells.

  • Append values to existing data rather than overwrite data

    Previously, the DATA function always overwrote existing data defined in the scope. With DATA.APPEND, you can now increment existing cells rather than overwriting them.

  • Table cell's context menu update

    The quick action menu for table cells has been updated so when you select a table cell, you can easily bring up the context menu with a right click.

  • 'Member-on-the-fly' and 'Table new line' features are now combined

    In your table, you can now combine creating new members in dimensions with creating a new line for booking the data.

  • Specify booking account for allocation steps

    When you are creating an allocation step, you can specify a Booking Account. If a Booking Account is set, all results calculated when executing the allocation step will be booked to that account instead of the original accounts. This holds for both allocated values and eliminations. This can be combined with the options: Keep Source and Overwrite Target.

  • Set Data Locks within a story

    You can now set Data Locks on a table from within a story. The initial drill state of the data locking editor is given by the selection in the story.

Administration & Infrastructure

  • Upload Analysis for Office enabled Excel files

    Want to share your Analysis for Office Excel files? You can now upload macro-enabled Excel files (.xlsm) into Files so it can be accessible by your SAC friends!

  • Connect to S/4HANA on-premise systems through front-end servers

    You can now create live data connections to S/4HANA on-premise systems that are federated through an SAP S/4HANA front-end server or SAP Fiori FES. After you choose SAML single sign-on as your authentication method when creating new connections, you can then enter your "Target System Alias". When logged on via SAML, you can also create or edit these connections and access the S/4HANA system.

  • Models and Points of Interest moved to the Files area

    Who doesn’t like to be organized? Models can now be organized in folders. Existing models are migrated to the Public > Models folder, and existing Points of Interests are migrated to the Public > Points of Interest folder. No need to modify security roles to share models. You can:

    • Save models into team-specific folders

    • Save models into Public subfolders created by Administrators

    A Sharing Settings dialog makes it easier to see which users and teams have access to specific models.

  • Migration of model permissions from roles to teams and sharing settings

    This upgrade will include a migration of existing permissions. No need to fret as you won't lose access to your models during the migration.

    A team will be created with the same name as the role (the creator will be "SYSTEM") and users assigned the role will be added to the team. The team will be granted equivalent Sharing Settings on the models in Public > Models folder. Where roles are already assigned to teams, the existing team will be granted equivalent Sharing Settings on the models.

  • Changes to roles during migration

    To Read, Update, Delete, or Maintain a model, you will need to be assigned both the general application privilege (assigned via a security role) and the Sharing Setting on the model itself (can be applied on the model directly via a parent folder).

    Roles that granted access to some models but not others will be updated to include the corresponding top-level Read, Update, Delete, or Maintain model permissions.

  • Editing model's sharing settings after migration

    Like stories and files, you can also edit the following sharing settings on a model:

    • Model owner

    • Users granted Full Control (or Read and Share permissions)

    • Users who belong to a team of which is granted Full Control (or Read and Share permissions)

    • Users who belong to a team of which is granted Full Control (or Read and Share permissions)

    It is advised to avoid resetting permissions on Browse > Files > System > Public > Models, unless you want to overwrite the migrated sharing settings on models. It is best to create your own folders, move models into them, and reset permissions for users and teams who need access moving forward.

  • Analytics Hub – Include assets in existing administrative download/upload

    Analytics Hub Administrators can now import Analytics Hub content when using the existing "Reset & Upload" workflow. Contents include:

    • Assets (Visible, Hidden, Draft)

    • Images

    • User data, including favorites

    • Picked for you

    • Usage data

  • Set the Session Timeout

    Through the System Configuration, you are now able to adjust the Session Timeout so you can remain logged on when inactive. You will need to click Log On to reload the last visited page or story. The default Session Timeout is one hour. Story embedded, and Boardroom view mode do not time out.

  • Additional language support for SAP Analytics Hub

    SAP 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

Data Integration

  • Transpose columns with unpivot transform

    Manage crosstabs with this new unpivot transformation. After applying this transformation to swap columns with rows, each header row will have its own column, and rows of the dataset will become the column headers. You can unpivot up to 50m cells at a time.

    Please note that models created with unpivot can only be refreshed if the number of columns is the same as rows, and you will have to use the "import data" workflow to bring in new data with a different structure.

  • Import data from sources on different networks and multiple systems on each network

    SAP Analytics Cloud (SAC) can now connect to multiple SAP Cloud Connectors (SCC). This allows you to connect to data across different networks, optimizing the locality of the data in the system. This feature allows you to declare distinct locations inside your data source configuration in System> Data source Configuration

    Use the SCC's "Location ID", to specify which agent to connect to. On-premise connections have an extra "Location ID" for you to fill-in. This works when the SCC is running on different network segments, such as when a firewall separates the SCC from SAC system.

  • Share connections with all users

    All sources that share connections from live and imported data sources, except for SAP Fieldglass, FileServer and SAP ERP, can now be shared with all users! This applies for both current and future users. Just type "All users" in the input text or select “all users” in the user and team selection panel. You can still pass on Read or Edit access to your users as well.

  • Geo dimensions can support up to one million members in data preparation

    Want to better enrich your geo maps? The existing limit of 200,000 points of interests has been increased to 1,000,000 when geo enriching a dimension based on latitude and longitudes.

  • Live connection to SAP HANA as a Service (HaaS)

    Live connections to SAP HANA 2.0 running on the Cloud Foundry as a service is now supported!

    To get started, simply set-up and configure your SAP HANA Analytics Adaptor in your Cloud Foundry application runtime.

    Please note: we only support single sign-on only. Currently, geo maps are not yet supported. Browser-based blending and SDI-based data blending is not supported.

  • SuccessFactors queries with effective dates

    Want to know your employee insights for last year? Gather insights from SuccessFactors data from a specific snapshot in time. For example, you can create reports showing last month's headcount, or the changes in the workforce over a given period.

    Using the filter, you can now specify the as-of-date when running SuccessFactors queries. By default, the "Effective date" is today. Note that "As-of-Today" is dynamic when scheduling.

    You have the following options when creating your filters: range, before, after, as-of-date, as-of-today.

  • SAP Integrated Business Planning (IBP) import connection

    Import data connection to SAP Integrated Business Planning is now available. Follow the usual on-premise setup by declaring the system in the SAP Cloud Connector administration panel and installing the SAC Cloud Agent.

  • Google Sheets import enhancements

    Select which sheet to import for Google Sheets. Please remember that you can work with up to 5M cells in a sheet.

  • Model creation enhancements

    When importing a smaller data file to create a model, you will be immediately directed to the data preparation area. No more unnecessary clicks!

  • Import data from an entity directly into a dataset

    Import data directly from an entity into a dataset and use it to perform predictive workflows from the following sources:

    • Generic OData

    • SAP SuccessFactors

    • SAP Business ByDesign

    • SAP Cloud for Customer

    • SAP Cloud for Customer Analytics

    • SAP Integrated Business Planning (IBP)

  • Combine data from multiple import sources with composite join keys

    You can now combine data using up to three composite join keys.

  • SAP BW import enhancements

    During data wrangling, you can now join up to 10 datasets. As well, we now support Tabs as a delimiter for CSV files.

  • Import data from Dow Jones articles

    With your subscription to Dow Jones, access full datasets directly from SAC! If you want to try out the data, there is a built-in trial key that gives you access to a sample of the dataset. Note that only metadata is retrieved. Connection queries are asynchronous and can be refreshed. To ensure the best performance, it is recommended to add proper filters to your query if the underlying table contains over 2 billion rows.

  • Schedule jobs adjust for Daylight Savings Time

    If you are in a region that encounters Daylight Savings Time (DST), you now won't need to worry whether to "spring forward" or "fall back" with your SAC clocks! For import and export jobs, the schedule timing now adjusts for DST according to the time zone you select. When creating a new schedule, it will default to the time zone of the browser. For existing jobs, you will have to open the models and set the DST.

  • Area name geo enrichment model enhancements

    Geo enriching by area now supports enriching all countries, regions, and subregions. Enriching is possible if the country data can be provided as ISO3 and ISO2 codes, or as full country names in English. Region and subregion must be in English as well. Geo-enriching at the country level is mandatory for imported data or data inputted by the user.

  • Reflect query structure from BW query

    Boost your productivity when you create BW models! Uploaded BW data now respects the model structure. The wrangling session will have inherited modeling structure from the BW source that includes dimensions, attributes, attribute data types, and hierarchies. Please note that you’ll need SAP Analytics Cloud agent version 1.0.223 or later.

  • oAuth support for BPC connections

    BPC connections now support oAuth tokens. With the combination of oAuth and SAML, you won't need to re-enter your credentials. When compared to basic authentication, oAuth provides stronger security. With oAuth support, BPC user credentials will not be stored in SAC.

Mobile

  • Add a drawing or text and share screenshots with colleagues

    Need to make some quick annotations? You can now add a drawing or text to a Story or Boardroom page in the mobile app. When you're done, share the screenshot with your colleagues.

    Please note that this is currently available on the Story or Boardroom page and not on full screen widget

  • iOS 11.0 update

    The SAP Analytics Cloud mobile app now requires iOS 11.0 or later. Please note that iOS 10 is no longer supported. Analytics Cloud Mobile app updates will not be available if you are still on iOS 10.

  • User interface adherence to your device language settings

    Bonjour, ciao, nǐ hǎo! You can now share and access your Stories in different languages! The menus, buttons, messages, and other elements in the mobile app now respect your device language settings. When you enter text, such as the Story name, it will not be translated, and it will be displayed in the original language. This first release currently supports 15 languages. Stay tuned for more!

  • Geo map support

    Get insights and dive deeper in your geo map analysis when you're on the go! You can now view and interact with geo maps on the SAP Analytics Cloud mobile app by exploring your choropleth and drill layers. Please note that geo on mobile does not currently support the following basemaps: Transparent Dark Gray, Night Time Streets, and China-based basemaps. Stay tuned for more!

  • Support for AirWatch SDK integrated authentication

    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 can pull digital certificates from AirWatch for user authentications on live connections. Please note that this is only applicable for customers using AirWatch MDM in their organization.

Data Visualization

  • Browser-based data blending between live data models from BW or HANA and import data models

    Feel like you always need your system administrator for blending? Say no more! Story Designers now can now blend between live models from BW or HANA 2.0 with import data models using your web browser without needing the system administrator to set up Smart Data Integration (SDI).

    Furthermore, no additional hardware deployment or licensing is required. Ensure that your SAP BW and HANA systems have 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 BW/4HANA

    Note 1: For Live HANA 2.0 version 2.00.024.05 (EPMMDS 1.00.201815.00) or higher is needed.

    Note 2: Browser-based blending is limited to 2MB and is for on-premise HANA.

  • Chart support short, medium and long text

    Charts can now support short, medium, and long text settings specified in BEx queries.

  • Waterfall Chart on Live BW and S/4 HANA on-premise

    Check this out! We have an exciting list of Waterfall Chart capabilities that are now supported on Live BW and S/4 HANA models:
    • Create single-level waterfall chart using any measure

    • Add a second dimension

    • Select interim totals

    • Position parent totals before or after its children

    • Decide whether the first measure starts from baseline or aggregated on top of last total

    • Hide or show the root node

    • Select whether the breakdown values will represent delta or actual values

  • Waterfall Chart with 4-member Color Scheme

    Add some more color to your charts with this new option to select and create a waterfall color scheme that has four color members. Colors can represent increase, decrease, totals, and intermediate totals. This helps you easily distinguish between totals and intermediate values.

  • Alter order of measures in tables for live BW connections

    Tables based from live BW data sources now allow you to change the order of the displayed measures. Order altering is not available for measures with hierarchies.

  • Geo layer support for SAP BW

    Geo layers are now supported with SAP BW/4HANA 2.0. Note that this does not include support for Choropleth layers.

  • Variance chart support for SAP BW

    Now the ability to create variance in charts is supported on SAP BW/4HANA and SAP BW 7.5 on HANA. Please note that this currently does not include variance based on Version and Time.

  • Show measure and dimension descriptions in Calculation Editor

    Easily understand your formulas in the Calculation Editor now that it can display measure or dimension descriptions as well as IDs. In Edit mode, the ID is displayed while the formula is being modified as well as when you are working in the formula input area. In View mode, this will display the descriptions when you click outside of the formula input area.

  • Enhanced Waterfall Nested Axis Labels

    Waterfall charts keep on getting better and better. Nested axis labels provide a cleaner look and feel, and an improved user experience overall. Dimension members are grouped and there is improved spacing between labels that will help you easily identify your measures and dimensions. Want this to be applied to all your waterfall charts? No need to worry – your existing waterfall charts will automatically be updated!

  • Absolute base value for % Variance and % Difference From calculations

    Use the absolute value of the denominator as the new default when calculating the % variance and % difference from. The resulting values will no longer deviate from the direction of their numeric counterparts which was the previous case whenever the denominator was a negative value. You will always be able to revert to the previous behavior if required.

  • Performance enhancements

    With on-demand loading of filter values, your Stories will render faster! Previously, the filters' list of values and the Story data itself were loaded simultaneously. The loading list of values for collapsed filters is now delayed until you expand it. Therefore, greater priority is given to displaying the data in the page: charts, tables, expanded input controls.

    Please note that the dimension member count will no longer be displayed next to the dimension name if the Story Designer selects "All Members".

    As a part of our performance enhancements, when opening an SAC story from a direct link, persisted queries are now submitted during the startup sequence. We have also improved SAC's logic to batch queries where possible. Please note that the batching of queries only applies if there is no data cache available. This is currently supported in the Chrome browser.

  • Rename measure and dimension descriptions

    Story designers can now rename measures and dimensions in the story without having to access the models. The new descriptions will be local to the story and will not be reflected in the actual models. As well, the descriptions will persist when the widgets are copied to another page or story. When copied to another story where the same measure or dimension has been renamed, a notification will appear to let you select which description should be kept in the story.

  • Story and page dynamic time filters based on Custom Current Dates

    Story designers can now create dynamic time input controls (page and story) with ranges based on a custom current date. This input control will appear in the story filter bar.

    The story viewer can see the specified current date on the page or story instead of using the browser’s system date. Note that only one Custom Current Date input control can be used in a story.

    After the selection, the Custom Current Date input control will drive all the linked dynamic time range filters in the story.

    This input control can be linked to dynamic time range filters regardless of models used, given that they are non-fiscal, or both with the same fiscal shift. The Custom Current Date selection is captured when a bookmark is created.

  • Support for dynamic HANA input parameters

    HANA input parameters are considered 'dynamic' if they use an expression to determine their value. Control at the story and widget level to access up-to-date dynamic variable values.

  • Removed member count limit on input controls based on flat dimensions

    Design Time:

    Story Designers can now create input controls with more than 4,000 members where all the dimension members are accessible to the users via the backend search. This is only available for filters with dynamic list of values, or where Story Designers have selected the "All Members" option. For static filters where the story designers have fixed selections, the 4,000 limit still applies.

    View Time:

    Story viewers now have access to dimension members beyond the 4,000 limit via backend search. You can select all the values that resulted from the search, given that the search result list has less than 4,000 members. The first 100 members are initially loaded, then the next members will be loaded in the background as users scroll down the widget. Note that deselecting values may result in an exclude query. The loading of filtered members in the background is a performance improvement as it reduces the time it takes to open existing stories.

  • Sharing private and global bookmarks

    Story viewers now have an ability to share their private bookmarks with other users, as long as the users have story access.

    Story owners and story designers are now also able to create global bookmarks that are available to everyone with story access. When sharing the story, you can choose a global default bookmark for the selected set of users. Global bookmarks can also be shared with individual users or teams.

    Bookmarks can be easily shared via a direct link found in the share dialog.

  • Exporting story content in a merged PDF

    Story viewers are now able to create a single PDF export containing each member of the story input control. Only one story input control can be selected per batch export. Note that story filters based on time dimensions are not yet supported.

  • Performance improvement when filtering across models

    When two datasets are linked together using one dimension and a story or page filter is created based on an unlinked dimension, indirect filtering occurs. Backend logic for processing indirect filters has been enhanced to overcome performance issues and data volume limitations.

    The performance improvements are focused on the following scenarios:

    • Models linked by a flat dimension with a filter on an unlinked dimension.

    • Models linked by a time dimension with the same time dimension used as a filter. This was previously treated as an indirect filter.

Smart Predict

  • Segmented time-series models for debrief reports

    Smart Predict now provides debrief reports for a segments-based time-series model. This contains more than 20 segments which can be generated individually on-demand rather than automatically during the training process. Each segment can be selected from a dropdown list to generate the report. For predictive models with less than 20 segments, all the debrief reports are created during the training and are available at the end of training.

  • Apply output variable selection to predictive models

    For your predictive models, you can now select which variables from the input dataset that you want to add to the output dataset.

  • Publish predictive model to an existing PAi scenario

    Create new predictive scenarios while adding new and improved models to existing predictive scenarios in a Predictive Analytics integrator (PAi).

  • Variables with no influence are no longer displayed

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

Modeling

  • Modeling improvements

    Modeling just keeps getting better with all these improvements:

    • Modeler undo/redo

    • Hierarchies can be created and maintained in the side panel

    • Model and dimension preferences now appear in the side panel

  • Input controls display fiscal year

    When a time-range input control is created with a fiscal year hierarchy, the title of the input control displays "Fiscal Year".

Intelligent Enterprise

  • Support for tuple filters in SAP BW queries

    SAP Analytics Cloud now supports tuple filters in SAP BW queries. This includes filtering with multiple dimensions in addition to using the "AND" and "OR" operators. The feature requires BW/4HANA 2.0, BW on HANA 7.5 SP16 (September 2019).

    You can create filters by selecting multiple data points in the widget. Note that "Exclude", blending, and linked analysis between widgets that contain tuple filters are not yet supported. Hierarchy and Currency Unit cannot yet be filtered.

Version 2019.7

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

Data Acquisition, Live Data Connections, and Integration

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

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

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

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

Stories

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

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

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

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

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

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

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

Modeling

Planning

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

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

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

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

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

Mobile

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

Analytics Hub

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

SAP Analytics Cloud Smart Predict

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

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

SAP Analytics Cloud Application Design (Beta)

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

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

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

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

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

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

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

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

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

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

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

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

System Administration Notes

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

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

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

    • 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 2541557Information published on SAP site for further details.

Version 2019.6

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

Data Acquisition, Live Data Connections, and Integration

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

Modeling

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

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

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

    • Account and dimension maintenance via the side panel.

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

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

    • Easier object management via a contextual side bar.

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

Stories

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

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

Planning

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

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

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

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

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

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

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

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

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

Analytics Hub

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

SAP Analytics Cloud Smart Predict

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

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

SAP Analytics Cloud Application Design (Beta)

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

System Administration Notes

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

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

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

    • 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 2541557Information published on SAP site for further details.

Version 2019.5

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

Data Acquisition, Live Data Connections, and Integration

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

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

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

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

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

Stories

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

Calendar

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

Planning

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

  • You can now create Input Tasks on Responsive pages.

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

Mobile

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

SAP Analytics Cloud Application Design (Beta)

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

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

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

    • Planning.getPrivateVersions

    • Planning.getPublicVersion

    • Planning.getPubllicVersions

    • PlanningPrivateVersion.publish

    • PlanningPrivateVersion.publishAs

    • PlanningPublicVersion.isDirty

    • PlanningPublicVersion.publish

    • PlanningPublicVersion.revert

    • PlanningVersion.deleteVersion

    • PlanningVersion.getDisplayId

    • PlanningVersion.getId

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

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

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

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

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

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

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

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

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

System Administration Notes

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

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

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

    • 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 2541557Information published on SAP site for further details.

Version 2019.4

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

General

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

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

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

Data Acquisition, Live Data Connections, and Integration

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

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

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

Stories

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

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

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

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

Planning

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

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

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

Mobile

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

SAP Digital Boardroom

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

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

SAP Analytics Cloud Smart Predict

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

SAP Analytics Cloud Application Design (Beta)

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

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

System Administration Notes

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

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

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

    • 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 2541557Information published on SAP site for further details.

Version 2019.3

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

Data Acquisition, Live Data Connections, and Integration

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

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

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

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

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

Stories

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

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

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

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

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

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

Calendar

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

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

Modeling

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

Planning

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

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

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

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

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

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

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

Mobile

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

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

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

SAP Analytics Cloud Application Design (Beta)

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

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

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

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

    • Application.refreshData();

    • Table.getPlanning.isEnabled();

    • Table.getPlanning.setEnabled(boolean);

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

    • The return type of script functions.

    • The type of script function arguments.

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

System Administration Notes

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

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

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

    • 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 2541557Information published on SAP site for further details.

Version 2019.2

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

SAP Analytics Cloud Smart Predict

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

System Administration Notes

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

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

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

    • 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 2541557Information published on SAP site for further details.

Version 2019.1

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

General

Data Acquisition, Live Data Connections, and Integration

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

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

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

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

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

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

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

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

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

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

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

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

Stories

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

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

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

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

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

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

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

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

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

    • For tables, you can now create Cross Calculations.

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

Calendar

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

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

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

Allocations

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

Planning

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

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

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

Modeling

SAP Analytics Cloud Application Design (Beta)

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

  • The following API functions are new:

    • DataSource: setMemberDisplayMode, getMemberDisplayMode, getMeasures

    • Chart: getDimensions, getMeasures

    • Table: getDimensionsOnRows, getDimensionsOnColumns

    The following API functions have changed:

    • DataSource: copyDimensionFilterFrom

    • Chart: addMeasure, removeMeasure

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

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

System Administration Notes

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

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

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

    • 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 2541557Information published on SAP site for further details.

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

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

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