This blog covers some of the latest new features and enhancements in SAP BusinessObjects Cloud and SAP Digital Boardroom release 2017.03.

Note: SAP BusinessObjects Cloud agent must be upgraded to 1.0.45 in conjunction with the SAP BusinessObjects Cloud upgrade to 2017.03.0.

Don’t miss our March 16 #askSAP Analytics Community Call: SAP Strategy and Roadmap for Cloud and Hybrid Analytics Scenarios Join us on March 16 to learn more about the SAP Analytics and SAP BusinessObjects Cloud strategy, new enhanced features and functionality, in addition to innovative ideas and capabilities to leverage on-premise SAP investments. Register here >

Latest YouTube tutorials:

New: Apply aggregation and exception aggregation settings in models New: Build a story automatically Updated: Use guided machine discovery

Highlights of this release include:

Schedule a data import from any source into any model Acquire data from SAP Fieldglass Manually enter values that are not in the List of Values (LOV) Progress indicator for data from file servers and on premise data sources Quality info now available for scheduled import jobs Add/Update dimension members when importing data to an existing model Cancel data import from a cloud source Freeze columns and rows in tables Stories: Edit variable parameters in view mode Location analytics: New vector base maps Predictive: Run forecasts on trend time-series charts based on remote models Value Driver Tree: Better handling of cell exceptions Planning: Paste to unbooked cells

Core: Data Integration

We want to help you simplify and automate your workflow. So now in addition to being able to schedule "update model" jobs, you can also schedule "import data to model" jobs. You even schedule multiple data import jobs into the same model (for example, from different BW queries). The import settings "Update", "Clean and Replace", and "Append" are all supported.

Video tutorial: Import data into a model

You can now create a connection to acquire data from SAP Fieldglass to create models in SAP BusinessObjects Cloud. You can use either SSO or your Fieldglass username and password to authenticate the connection. Once you have connected to Fieldglass, you will be able to see the reports for which you have viewing rights.

SAP Fieldglass is a cloud-based Vendor Management System (VMS) that allows you to manage services procurement and external workforce programs. As always, we recommend that you check the System Requirements and Technical Prerequisites page in the SAP BusinessObjects Cloud Help Guide for the most up to date information on supported data sources.

When you are building a query to acquire data from SAP BW, the filter dialog allows you select values from a dimension or measure using a List of Values (LOV). But what if you wanted to quickly type something in? In this release, you can manually enter values that are not in the List of Values in addition to using the existing LOV.

Learn how to create an import data connection from an SAP Business Warehouse (BW) system Video tutorial: Create a connection for an import a model and data from SAP BW

Acquiring data from a file server or on premise data source can be a time consuming process if you have large volumes of data. We’ve built in a new progress indicator to help you see how much data has already been uploaded during the acquisition process.

You can now view detailed quality information after a scheduled data import has been executed. In addition to the overall status of the data import (success, failure, or warning), you will also see details including:

The number of successfully inserted rows An error message if the data import fails The number of rows rejected due to data quality issues If any data rows were rejected during import, you will also have a hyperlink to download a .csv file that contains the rejected rows and the reason for failure

Thanks to the addition of a new "Update dimension with new values" checkbox in the Mapping Options dialog, you can now add and update dimension members when importing data to an existing model. Supported dimension changes include:

Adding a dimension member to a dimension (except in the account dimension) Changing the value of the description Updating a hierarchy that has already been defined

Cancel data import from a cloud source

When importing data from a cloud source, you can now cancel the data import if you decide you don’t want the upload to continue.

Core: Data Analysis, Stories, and Tables

You can now freeze rows or columns in a table so they are always visible while scrolling!

Columns and rows are frozen independently. Within a canvas page you can apply freeze lines separately for each table widget, but on a grid your freeze lines apply to the entire grid regardless of the number of data regions you have.

By default, freeze lines are visible but you have the option to hide them via the show/hide menu. The same show/hide options for the freeze lines also apply when you export a story to PDF.