Oracle® Cloud

What’s New for Oracle BI Cloud Service

E69184-07

November 2017

What’s New in Oracle BI Cloud Service

As soon as new and changed features become available, Oracle BI Cloud Service instances are upgraded in the data centers where Oracle Cloud services are hosted. You don’t need to request an upgrade to be able to use the new features—they come to you automatically. Here’s an overview of new features and enhancements added recently to improve your Oracle BI Cloud Service experience.

November 2017

General

Feature Description

Restart Service

Administrators can stop and restart Oracle BI Cloud Service if the service stops responding. See Restarting Your Service.

May 2017

General

Feature Description

New home page

The home page has been redesigned to provide better access to your BI content.

Embed external resources in your content

You can embed a range of external web resources in your content: frames, scripts, fonts, stylesheets, audio, video, and connections. See Embedding External Images and Other External Resources in Your Content.

Your administrator controls what you're allowed to embed by whitelisting safe domains and safe resources. See Whitelisting Safe Domains.

Data Visualization

Feature Description
Advanced Analytics

Data Visualization users have access to advanced analytics functions, such as forecasting, clustering, and outliers.

Redesigned Data Sources page

The Display pane contains categories that you can click to see your data sources by type, your connections, and your data flows. The Create pane contains links that you can click to quickly begin creating data sources, connections, and data flows.

Authentication option for Oracle Applications connections You can specify if you want users to enter their own credentials to access the Oracle applications data that they have the permissions to access.
Create Source page The Create New Data Source page is easier to use and includes new features such as the option to add filters when building database data sources.
Smart insights The smart insights feature helps you better understand the data in your data source and how to best visualize it in a project.
Data flow functionality added You can use data flows to produce curated data sources that you can use to create visualizations.
CSV as a data source You can now use .CSV files as data sources.
Visualization types The following visualization types were added: chord, circular network, list, network, parallel coordinates, sankey, timeline, and tree.
Improved visualization coloring You can use hierarchical and non-repeating sequential coloring in visualizations.
Visualization filters You can add filters to individual visualizations in a project.
Filter dependencies You can use the Limit Values option to specify how the filters in the filter bar restrict each other.
Filter controls You can add a filter control to the canvas and use it to control what displays in related visualizations on the same canvas.
Multiple canvases A project can have multiple canvases.
Multiple insights A project can have multiple insights.
Print canvas You can print a project’s canvas or canvases.
Output visualizations to PDF and PowerPoint You can output your project’s visualizations to PDF and PowerPoint. 
BI Ask search functionality You can use BI Ask in the Search field to build visualizations on the fly.

Data Loading

Feature Description

Data Sync Version 2.3 supports data transformations

Data Sync Version 2.3 is available on Oracle Technology Network. For a full list of new features, refer to the Readme document on the download site.

September 2016

Feature Description
Upload data from Oracle Service Cloud (RightNow) Load data from Oracle Service Cloud (RightNow) using Data Sync V2.2. See Loading Data from Oracle Service Cloud (RightNow).
Upload data from JDBC data sources Load data from JBDC data sources using Data Sync V2.2. See Loading Data from JDBC data sources.

August 2016

Feature Description

Email your reports

Email your reports to anyone inside or outside the organization. Schedule daily or weekly emails to keep everyone up-to-date. See Emailing Reports.

Track email deliveries

Track and manage reports you’ve chosen to send to people by email from the Console. See Tracking Email Deliveries.

March 2016

Data Visualization

Feature Description

File size limit increase

File size limit increased to 50MB.

Visualize data in Oracle Applications

Use analyses and logical SQL statements in existing Oracle applications as data sources for projects. See Connecting to Oracle Application Data Sources.

Data wrangling — update data sources after upload

Make updates to existing data sources including editing columns, and creating new ones for use in projects. See Modifying Uploaded Data Sources.

Share reports with others on a read-only basis Give people limited access to your reports. Let them view and interact with visualizations without worrying about compromising the data. See Investigating Data Only Using Interactions.

New ways to present data visualizations

New ways to present data visualizations:

Donut charts – Similar to pie charts.

Tile views – Performance tiles present a distilled analysis of data.

Text boxes – Annotate your data with text. Embed hyperlinks to more information and insights.

Enhancements to visualizations

Trends – Visualize the trend of a data series using a trend line.

Color management – Customize your color schemes.

Thumbnails – Add thumbnail images to projects and insights to quickly identify content.

Sort data elements – Numerically or alphabetically.

Filter data – Create data filters, move filter bars around on the canvas, and easily search for data elements. Use * and ? as wildcards, in addition to current wildcard characters (% and _ ).

Reports and Dashboards

Feature Description
New ways to view data

Legend – Include a legend with results. Use the legend to add meaning to special formatting that you’ve used, such as the meaning of custom colors applied to gauges.

Ticker - Displays results as a ticker or marquee, similar in style to the stock tickers that run across many financial and news sites on the Internet. You can control what information is presented and how it scrolls across the page.

Quickly copy report columns Quickly copy report columns with “Save Column As…”.
Copy existing reports and dashboards to the cloud Upload existing content from another Oracle BI Cloud Service or Oracle BI Enterprise Edition 11.1.1.9.0 or later.

Copy catalog content from one environment to another using new catalog archive/unarchive options. Archiving saves your content to a .catalog file on your local file system. Unarchiving uploads content from catalog files to another location. See Migrating Content To Other Catalogs.

Data Modeling

Feature Description
Build multiple data models Modelers can build multiple, independent data models (also known as subject areas).
Control the database connection Data Modeler can interact with multiple cloud databases. Now business modelers and analysts can analyze company data wherever it is stored. See Creating a Data Model.

Loading Data

Feature Description
Enhancements to Data Sync. Now you can:
  • Upload data from Excel spreadsheets and OTBI (Oracle Transactional Business Intelligence) data sources.

  • Upload data to a data set source suitable for data visualization projects.

Data Loader deprecated Data Loader available from Oracle Application Express in Database Schema Service. Data Loader link removed from the Home page in Oracle BI Cloud Service.

Administration

Feature Description
Integrate with multiple data sources Now Oracle BI Cloud Service can handle data stored in multiple Oracle Cloud databases. See Managing Database Connections.
Whitelist safe domains Approve safe domains for your organization so users can add external images to their reports and embed their reports in other applications. See Whitelisting Safe Domains.
Index content and schedule crawls Set up how catalog content is indexed and crawled so users find the latest content when they search. Exclude folders you don't want searched. See Managing How Content is Indexed and Searched.
Download the public key for remote data connectivity See Where can I find the public key for Oracle BI Cloud Service?.
New “view-only” role for data visualization users The BIConsumer role lets people explore data in projects without the risk they may compromise the data. See Predefined Application Roles.

REST API

Feature Description
Upload and manage data sets for data visualization projects See REST API for Oracle BI Cloud Service.
Updates to the Delete Cache REST API Now you can delete the data cached for all the tables in a connected database. If Oracle BI Cloud Service is connected to multiple databases, you can delete the cache for tables in all your connected databases.

November 2015

Feature Description
Fresh new look to Oracle BI Cloud Service Improved design that’s simple to navigate and easy to use. Includes a brand new Academy to help you get the most out of Oracle BI Cloud Service.
View your data in a heat matrix Use a heat matrix view to see a two-dimensional depiction of data in which values are represented by a gradient of colors. See Editing Heat Matrix Views.
Visualize geographical data on maps Use a map view to display data on a map in several different formats and to interact with the data. See Editing Map Views.
Manage your data files Review, download, and delete data files you’ve uploaded for analysis. Quickly see whether you’re close to reaching your quota. See Managing Data Sources.
Enhancements to Data Modeler:

April 2015

Feature Description
Explore data using Data Visualization Data Visualization provides self-service analysis, seamlessly transitioning you between all phases of the analysis lifecycle: data staging, analysis, composition, and consumption. See Getting Started with Data Visualization.

Manage access to data visualization features through a new application role called BIDiscoveryContentAuthor. See Application Roles Predefined in Oracle BI Cloud Service.

Add your own data to analyses You can add data from an external source to an analysis in Oracle BI Cloud Service. Adding your own data is sometimes referred to as “mash-up.” See Adding Data from External Sources to Analyses.
Upload data models from Oracle BI Enterprise Edition If you’ve modeled your data with Oracle BI Enterprise Edition you don't need to start from scratch in Oracle BI Cloud Service. Simply upload your on-premises data model file (.rpd) to Oracle BI Cloud Service and start exploring your data through visualizations, reports, and dashboards. See Uploading Data Models from Oracle BI Enterprise Edition.
Integrate with Oracle Database Cloud Service Connect Oracle BI Cloud Service to any Oracle Database Cloud Service instance. See Managing Database Connections.

March 2015

Feature Description
Load data programmatically Use methods of REST APIs to programmatically create, manage, and load schemas, tables, and data into Oracle BI Cloud Service. See About the Oracle BI Cloud Service REST API.

February 2015

Feature Description
Copy objects in Data Modeler Sometimes it’s quicker to copy objects rather than starting from scratch. You can copy fact tables, dimension tables, database tables, and database views. See Copying Model Objects.
Drag and drop to extend dimensions We’ve made it easier to add columns to dimension tables. Simply drag and drop tables or views that contain columns that you want to add to the dimension table. See Adding Columns from Another Source to a Dimension Table.
Aggregate before or after calculating the expression for a measure You can create calculations that contain pre-aggregated measures. See About Creating Calculated Measures.
Use fact tables indirectly joined through dimension tables in expressions When you define a calculated measure in Expression Editor, the Expression Elements section includes the current fact table, any dimension tables joined to that table, and any fact tables indirectly joined through a dimension table. See About the Expression Editor.
Data Modeler detects relationships and suggests facts and dimensions for your model When you add source objects with relationships to other tables or views to the model, Data Modeler asks whether you want to include related fact or dimension tables and offers to add them to the model.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.


Oracle Cloud What’s New for Oracle BI Cloud Service

E69184-07

Copyright © 2014, 2017, Oracle and/or its affiliates. All rights reserved.

Primary Author: Pete Brownbridge

Documentation for Oracle Business Intelligence Cloud Service users that describes new features and other notable changes for Oracle Business Intelligence Cloud Service.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.