This blog covers some of the latest new features and enhancements in SAP BusinessObjects Cloud and SAP Digital Boardroom release 2017.07. Please note that with this release, the SAP BusinessObjects Cloud agent remains at version 1.0.51, with the following exception:

Highlights of this release include:

Learn with our latest video tutorials

 

Core: Data Integration

Create joins between tables (Visual Linking)

In just a few clicks, you can now quickly and easily join two or more tables using our new Visual Linking functionality when you import data from a SQL database. The query builder below shows a few tables that were selected in sequence. With the Auto Linking feature turned on, the application can automatically identify and create the appropriate joins between the tables. Located above the data tables list, the “Write freehand SQL” button even allows you to join the results of a SQL statement.

In the Build a Query dialog, you can click the Preview button to see the results and quality of the joins:

And that’s not all – you can edit the data and filters for each table you include in the join:

Acquire data from Google BigQuery

As our team likes to say, “we never met a data source we didn’t like”. In release 2017.07, you can now import data from Google BigQuery projects using freehand SQL and the query builder. Once you create a query for Google BigQuery, you can reuse it for other existing models.

Import Data: Geo enrichment enhancements

When you import data into a model, you can enrich the data so that it can be displayed in geo maps. In this release, we’ve added the option for you to update the latitude/longitude geo enrichment in the Import Data from File workflow.

If you choose to allow dimension updates and geo enrichment info during the data import process, new dimension members added to the dimension will be geo enriched and existing members will also be updated.

 

Core: Infrastructure

Ability to assign the “System Owner”

As the system admin for your organization, you can now assign a different user as the System Owner for your SAP BusinessObjects Cloud tenant. This is a handy feature if you need to transfer admin responsibilities to another person in your organization.

In addition, any updates you make to the current System Owner profile (first name, last name, or email address) are automatically updated in our SAP tenant management system.

  • The System Owner is the person that will receive all system notifications and other email communications from our SAP Cloud Ops team.
  • Please note you cannot delete the system owner’s user account without first transferring system ownership to another user. Also, you must have the System Information > Update privilege to transfer system ownership to another user.
  • Learn more about system administration in SAP BusinessObjects Cloud

 

Files area enhancements

Stories, files, folders, and digital boardroom agendas are now all accessible from a single page when you go to Browse > Files. We’ve simplified the tabs into a single view as part of our ongoing efforts to improve the file repository.

  • Public, Teams, and Input Forms now appear as top-level folders
  • You can filter to see the files you’ve created (“Created by Me”) or have been shared with you (“Shared with Me”)
  • You can also filter by type to view only Stories, Agendas, Files, or Favorites

We’ve also improved the Search to help you find things more easily:

  • You can search down all folder levels
  • Search results indicate the full path to each item, so you can distinguish between objects with the same name
  • Search matches values from all visible text columns on the page (e.g. name, description, owner)

 

Upload data into existing models (Planning Standard and Analytics Standard licenses)

Users can now upload data into existing models, without needing permission to edit the model itself. These users just need Read and Maintain permissions for the model, which require only a Planning Standard or Analytics Standard license (as opposed to needing the Update permission, which requires a Planning Professional license). To upload the data from Excel/CSV, users also need the Execute permission on Personal Data Acquisition. The default Planner Reporter role now includes these permissions on all models.

 

Core: Modeling

Version mapping for models based on live connections

Version mapping is now available in models based on live connections. You can access the Version Information dialog box from within the Modeler, and from there, map the version values in to Actual, Planning, and other categories.

 

New exception aggregation types

New exception aggregation types are available in this release:

  • Count
  • Count excluding nulls
  • Count excluding nulls and zeroes

Learn how to apply aggregation and exception aggregation settings in models in this video tutorial.

 

RESTRICT and LOOKUP with the != operator

You can now use the != operator in the RESTRICT and LOOKUP formulas.

 

Core: Data Analysis, Stories, and Tables

Configure styling of charts and tables directly in Explorer

We’ve made some of the chart and table styling options available from within Explorer, so now you can change chart properties, numeric formatting, fonts and colors, and other options without having to jump out of Explorer. In addition, supported story wide preferences are automatically applied within Explorer though these settings are not editable from there. Please note these styling options are not available in the Digital Boardroom.

 

Improved tooltips for charts and geo maps

Tooltips in geo maps and charts are now improved with a more consistent and appealing look. Though the behavior of the tooltips stay the same (i.e. can provide detail for variance, reference lines, etc.), we’ve improved text wrapping to prevent tooltips from growing horizontally.

 

Export data to CSV: Added support for grid pages

In the previous release, we introduced the ability for you to export data to a CSV file. Now in this release, we’ve extended the functionality so that you can also export data displayed on grid pages to CSV.

 

Planning

Copy facts across versions

Previously, you could only copy and paste facts (table cells) within the same private version. Now in release 2017.07, you can copy and paste table cells from one version to another version, and the values of the source cell’s leaf members are pasted as well.

 

Value Driver Trees: Hover over to see source nodes

Now in addition to seeing the links to the target nodes, you can also now see the source nodes when you hover over a node.

 

Value Driver Trees: Specific account as base value of YoY node

You can now specify a specific account as the base value of a Year Over Year (YoY) node. This allows you to create multiple YoY nodes based on the same data source node, for example, to simulate scenarios with more than one set of driver values.

 

Price * volume revenue formula

You can now create a revenue formula (price * volume) when using a planning model, or other formulas based on lookup functions. Please note that for this current release, price and volume must be stored in the same model

 


Additional resources:

Previous feature summary blogs:

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply