Oracle® Cloud

What’s New for Oracle Analytics Cloud

E81761-19

June 2019

What’s New for Oracle Analytics Cloud

Here’s an overview of new features and enhancements added recently to improve your Oracle Analytics Cloud experience. It's organized by the date a specific feature or capability became available.

Release 105.3 - June 2019

Service Management

Feature Description
More options to scale services

(Services deployed on Oracle Cloud Infrastructure)

  • Scale the number of Oracle Compute Units (OCPUs) allocated to Essbase services up and down.

See Scale Up or Down.

Redesigned Console Improved design that’s simple to navigate and easy to use.
Redesigned System Settings page

A redesigned page that makes it easier for you to find and update advanced service-level settings.

See Configure Advanced Options.

Data Visualization

Feature Description
Visualization types

You can create Language Narrative visualizations. See About Language Narrative Visualizations.

Tooltips improvement

Use the Tooltips field to adjust the content in a visualization's tooltips or to turn off a visualization's tooltips. See Modify a Visualization's Tooltips.

Refresh embedded data

You can configure the refresh of data in embedded HTML pages. See Refresh Data in Embedded HTML Pages.

Select alias table

You can select an alias table when creating or updating Essbase data sets. See Create Data Sets from Essbase Cubes.

Configure currency symbols

You can dynamically populate a currency symbol in visualizations based on the configured currency. See Set Currency Symbols for Visualizations.

Pixel-Perfect Reporting

Feature Description
View audit data

You can enable or disable audit of reports and catalog objects.

See Audit Reports and Catalog Objects.

Scale up and down

Some thresholds and limits associated with publishing vary, depending on the size of your deployment.

See Plan Your Service.

Connecting to On-Premises Data Sources

Feature Description
Connect more easily to on-premises data sources using Data Gateway Install Data Gateway in your on-premises environment on Linux, MacOS, or Microsoft Windows to connect to on-premises data sources. See Workflow for Connecting to On-Premises Data Sources.

Introduction of Data Gateway and Deprecation of Remote Data Connector

Oracle Analytics Cloud version 105.3 introduces the Data Gateway utility. This utility replaces the Remote Data Connector of earlier releases. Although you can continue to use Remote Data Connector, it's been deprecated as of Oracle Analytics Cloud 105.3 and will be removed in future releases no sooner than six months from the release date of 105.3. Oracle recommends adopting Data Gateway within six months of the release date of 105.3 to avoid loss of functionality.

What's Fixed in Release 105.3.0

For a list of defects fixed in Oracle Analytics Cloud, see Doc ID 2545288.1.

For a list of defects fixed in Oracle Analytics Cloud – Essbase, see Doc ID 2544870.1.

Release 105.2.3 - May 2019

Service Management

Feature Description
Pause and resume services

Pause services you deploy on Oracle Cloud Infrastructure to prevent users from accessing the service.

See Pause and Resume a Service.

Release 105.2 - March 2019

Service Management

Feature Description
Scale service up and down

(Data visualization or business intelligence services deployed on Oracle Cloud Infrastructure)

Scale up the number of Oracle Compute Units (OCPUs) allocated to your service to improve performance. Scale down to save costs or if your workload reduces.

See Scale Up or Down.

Track usage

Track user queries and generate reports and visualizations to analyze the usage data.

See Track Usage.

Additional service-level configuration

A range of configuration options for additional, advanced use cases are available through Console.

See Configure Advanced Options.

Data Visualization

Feature Description
Add notes

Add, edit, and adjust notes on a canvas.

See Add Notes.

Enhanced column operations

Quickly reorganize items in the Projects, Data, and Machine Learning pages by sorting the items based on their attributes.

See Sort the Items in a Page.

Data flow improvements

Employ improvements to data flows including:

Map improvements

Employ improvements to maps in data visualizations including:

Connection improvements
Specify filters for relative time periods

Display data for a specified time period based on the current date and time using the relative time filter on a Date or Date/Time column.

See Apply Relative Time Filters.

Share files to LinkedIn

Share one or more of your project's visualizations, canvases, or stories to LinkedIn as a file.

See Use LinkedIn to Share a File of a Visualization, Canvas, or Story.

Upload larger data files

Upload files with a maximum size of 250 MB. The number of data columns allowed in a single file is 250 columns.

See About Adding Spreadsheets or Other Files.

Generate larger reports

The maximum number of rows you can return from any data source query or export to various file formats increases to 2,200,000 rows of unformatted data and 50, 000 rows of formatted data. The maximum limits for individual services vary, depending on the size of your deployment.

See Plan Your Service.

Connect to on-premises databases Visualize data in on-premises databases using the Use Remote Data Connector option. See Supported Data Sources (to find out supported remote database types, look for databases with a Y in the 'Remote Connection to Data Sets' column).

Pixel-Perfect Reporting

Feature Description
Use Data Visualization data flows as data sources Create pixel-perfect reports with data flows from Data Visualization. See Create a Data Set Using a Data Visualization Data Flow.

Connecting to On-Premises Data Sources

Feature Description
Connect to on-premises data sources much more easily using Remote Data Connector Install Remote Data Connector in your on-premises Linux environment using Oracle Universal Installer. See Workflow for Connecting to On-Premises Data Sources.

Reporting in Dashboards and Analyses

Feature Description
Modify data in tables

Users of a dashboard page or an analysis can modify the data they see in a table view (also known as "writeback").

What's Fixed in Release 105.2.0

For a list of defects fixed in Oracle Analytics Cloud, see Doc ID 2522269.1.

For a list of defects fixed in Oracle Analytics Cloud – Essbase, see Doc ID 2522690.1.

Release 105.1.4 – March 2019

Feature Description
Oracle Analytics Cloud Subscription - Number of OCPUs With Oracle Analytics Cloud Subscription, you can now subscribe to a set number of Oracle Compute Units (OCPUs). When you set up a service with this type of subscription, you specify the number of Oracle Compute Units (OCPUs) you want to deploy. See Create a Service with Oracle Analytics Cloud Subscription.

Release 105.1.1 - February 2019

Feature Description
Oracle Analytics Cloud Subscription - Number of Users A new way to subscribe and deploy Oracle Analytics Cloud on Oracle Cloud Infrastructure. With Oracle Analytics Cloud Subscription, you can subscribe to a set number of users. When you set up a service with this type of subscription, you specify the number of users you expect to use the service. See Create a Service with Oracle Analytics Cloud Subscription.

Release 105.1.0 – January 2019

Service Management

Feature Description
Product name changes

Oracle Analytics Cloud: Name used for deployments on Oracle Cloud Infrastructure, previously known as Oracle Autonomous Analytics Cloud.

Oracle Analytics Cloud - Classic: Name used for deployments on Oracle Cloud Infrastructure Classic, previously known as Oracle Analytics Cloud.

See About Oracle Analytics Cloud Products.

Quick start deployment

Create trial instances faster. Set up Oracle Analytics Cloud on Oracle Cloud Infrastructure Classic with a single click.

See Create a Trial Service with a Single Click.

Multiple identity domains

Oracle Identity Cloud Service supports multiple identity domains. When you set up Oracle Analytics Cloud, you’re asked which identity domain one you want to use, if more than one is available in your environment

See Create a Service (Oracle Analytics Cloud).

Migrate Oracle Analytics Cloud environments

Migrate content easily between Oracle Analytics Cloud environments using snapshots. It doesn’t matter whether Oracle Analytics Cloud is deployed on Oracle Cloud Infrastructure Classic or Oracle Cloud Infrastructure Classic.

See Migrate Oracle Analytics Cloud Using Snapshots.

Migrate from Oracle BI Enterprise Edition 11g

Additional menu options in Console make migration easier. You can download a utility that exports content from Oracle BI Enterprise Edition 11g to a migration bundle (JAR file). After exporting your content, you can upload the migration bundle to Oracle Analytics Cloud using the Console.

See Migrate From Oracle BI Enterprise Edition 11g.

Snapshot enhancements

You can capture much more when you take a snapshot. You can take a snapshot of your entire environment (everything) or specify specific content that you want to back up or migrate (custom). Similar options are available on restore -- improving your backup, restore, and migration experience.

See Options When You Take a Snapshot and Options When You Restore a Snapshot.

Data file migration utility

This utility moves data files from one Oracle Analytics Cloud environment to another. Sometimes, connection issues between the source and target environment can interrupt data file migration during snapshot restore. This utility offers you an alternative way to move your data files.

See Migrate File-based Data.

Advanced service-level configuration

You can set configuration options required for advanced use cases through Console.

See Configure Advanced Options.

Data Visualization

Feature Description
Autonomous Data Warehouse connection enhancements You can more easily create a connection to Oracle Autonomous Data Warehouse because key connection details are prepopulated from the selected client credentials zip file.

See Create Connections to Oracle Autonomous Data Warehouse.

Autonomous Transaction Processing connections You can create connections to Oracle Autonomous Transaction Processing.

See Create Connections to Oracle Autonomous Transaction Processing.

Essbase - Release 12.2.1.1.115

Feature Description
Calculation tuples By selecting tuples, you can focus your calculations in the active Smart View grid, limiting their scope to specific slices of data in your cube. Tuple selection helps you optimize asymmetric grid calculations across dimensions, avoiding over-calculation.

See Calculate Selected Tuples.

Performance Analyzer The Performance Analyzer, available in the Console of the Essbase web interface, helps you monitor usage and performance statistics of your Essbase service. It reads Essbase log files behind the scenes and then creates .csv files of the Essbase activity data. You can then use the reporting tool of your choice to create charts and other visualizations of the data.

See About Performance Analyzer

Layouts and MDX Reports You can save ad hoc grid views as layouts, and you can save MDX queries as reports.

See Analyze Data in the Web Interface.

Ancestor position You can specify the ancestor position for hierarchies in ad hoc grids in Smart View, if you set the SSANCESTORONTOP configuration parameter in Essbase to TRUE. By default, this parameter isn't enabled, and the ancestor is positioned at the bottom. To enable it, see SSANCESTORONTOP in Technical Reference for Oracle Analytics Cloud - Essbase.

See also Specifying Ancestor Position in Ad Hoc Grids in Working with Oracle Smart View for Office.

New gallery templates

In the Files catalog, new gallery templates are available:

  • Solve Order Performance—Technical cube comparing query performance using dynamic calculations versus using stored members and a calculation script.

  • Flip Sign—Technical cube demonstrating how to flip signs of data values during a data load to meet reporting requirements.

  • RFM Analysis—Marketing application demonstrating how to identify the most profitable customers based on metrics.

  • Currency Triangulation—Utility cube that uses a calculation script to triangulate currencies.

  • Consolidation Eliminations—Financial analysis application demonstrating how to identify and eliminate balances between two companies.

  • Organization Restatements—Financial analysis application demonstrating how to restate expenses after an organizational change.

  • CalcTuple Tuple—Technical cube showing how to optimize asymmetric grid calculations across dimensions.

  • Sample Dynamic Basic—Updated version of Sample Basic, configured in hybrid mode to efficiently calculate stored members that depend on dynamic members. Sample Basic is a cube that is commonly referenced in Essbase documentation.

Gallery templates are application workbooks you can use to build fully functional Essbase cubes. See Explore the Gallery Templates.

Aggregate views You can create aggregation views to be generated automatically, according to dimension structure in an outline for an aggregate storage application. See Create and Manage Cube Outlines Using the Web Interface.
Multi-cell drill through You can select multiple cells or multiple ranges of cells, and see the merged results in drill through. See Analyze Cube Data with Drill Through Reports
Oracle Autonomous Data Warehouse connection and Datasource In the Essbase web interface, you can create a connection and Datasource to Oracle Autonomous Data Warehouse using the Oracle Database type connection and Datasource. You can also upload the wallet files required for connecting to Oracle Autonomous Data Warehouse.

See Create a Connection and Datasource to Access Oracle Autonomous Data Warehouse

Alias tables In the Essbase web interface, you can create alias tables. Aliases provide alternate names for members on an outline. Aliases are stored in one or more tables as part of a database outline. An alias table maps a specific, named set of alias names to member names. See Understand and Create Alias Tables.

Pixel-Perfect Reporting

Feature Description
POV parameter in an MDX query View an Essbase cube and filter data for reports. See Include a POV Parameter Value in an MDX Query.
Snapshot includes pixel-perfect reporting Migrate the credentials, configurations, and scheduled jobs of pixel-perfect reporting from one environment to another. For custom migration, select the Jobs option if you want to migrate the scheduled pixel-perfect report jobs. See Take Snapshots and Restore.

For a list of defects fixed in Oracle Analytics Cloud release 105.1.0, see Doc ID 2494345.1

For a list of defects fixed in Oracle Analytics Cloud – Essbase 12.2.1.1.115, see Doc ID 2496335.1

Release 18.3.3 - September 2018

Service Management

Feature Description

Fast setup for Oracle Analytics Cloud

Fewer setup steps and your service is ready to use in about 20 minutes!

See Create Services with Oracle Analytics Cloud.

Console reorganization

(BI and Data Visualization services only) In the Console, all administrator-only options are reorganized under a Service Administration menu.

Essbase - Release 12.2.1.1.114

Feature Description

Modern interface

The Essbase web interface is enhanced with a new look and improved usability.

Gallery templates

In the Files catalog, you can find gallery templates, which are application workbooks you can use to build fully functional Essbase cubes. Think of these templates as starter kits to learn about technical features and to model a variety of analytical problems across business domains. See Explore the Gallery Templates.

Connections and data sources

Many Essbase cube operations require connection information, such as login details, to access remote data sources or hosts. You can define these connections and data sources once and reuse them in various operations, so that you don’t have to specify the details each time you perform a task. See Use Connections and Data Sources.

Rules editor

You can use the enhanced rules editor to preview data from a data source or file while creating a rules file, use connections and data sources created in the interface, and define rules for dimension builds and data loads. See Build Dimensions and Load Data.

Efficient dynamic security filters

You can create filters on your applications to allow access to specific slices of your cube and reduce the number of filter definitions needed. See Create Efficient Dynamic Filters.

MDX query and script execution

In the Essbase web interface and in Smart View, you can execute free-form MDX queries to analyze cube data. You can also run saved MDX scripts to perform data export and import or to perform analysis in the context of a Smart View grid. See Analyze and Moving Data with MDX.

MaxL execution over HTTPS

Use the MaxL Client to securely manage Essbase cubes and artifacts using a language-based interface. See Manage Essbase Using the MaxL Client.

Scenario management calculation enhancements

  • Calculation scripts without explicit FIX statements, when executed on scenario management enabled applications implicitly fix on the Base member. See Understand Scenario Calculations.

  • Calculation expressions that calculate a sub-hierarchy, such as @CHILDREN or @IDESCENDANTS weren't supported in an earlier release, but they are supported in this release.

  • If you execute a calculation script in Smart View from a scenario-launched Excel sheet, the calculation runs in the sandbox associated with the scenario as long as no sandbox is explicitly mentioned in the script. See View and Work With Scenario Data.

Outline editor enhancement

The outline formula editor includes a member tree and a function list from which you can pick members and calculation functions. See Create Member Formulas.

Calculation script editor enhancement

The calculation script editor now includes a member tree and a function list from which you can pick members and calculation functions. See Create Calculation Scripts.

Data Visualization

Feature Description

Preparing data

You can use data transformation and enrichment recommendations to prepare your data before visualizing it. See Preparing Your Data Set in a Project.

Visualization types

You can create Grid Heatmap, Picto, 100% Stacked Bar, Horizontal 100%, 100% Area, and Correlation Matrix visualizations.

Map layers and backgrounds

Essbase enhancements
Saving changes automatically You can use the Auto Save option to automatically save your updates to a visualization project without repeatedly clicking Save. See Saving Your Changes Automatically.
Opening objects using keyboard shortcuts You can use keyboard shortcuts to open artifacts in a new tab or window. See Keyboard Shortcuts for Data Visualization.

Inspect object properties

You can use inspectors to view and edit the properties of standalone objects in the Home, Data, Projects, and other top-level pages. See Viewing and Editing Object Properties.

Data replication enhancements

Replace a data set in a project

Replace a data set by re-mapping columns used in a project to columns from a different data set. See Replacing a Data Set in a Project

Analyze subject areas

Use subject areas as data sources in data sets and data flows. See Creating a Project and Adding Data Set and Creating a Data Flow.

Enable users to search data sets using BI Ask

See Enabling Searching Using BI Ask.

Tooltips

Make visualizations more interactive with tooltips. See Identifying Content with Tooltips.

Embed data actions in external containers

Include data actions in embedded visualizations. See Creating Data Actions in Visualizations Embedded in External Containers

Pixel-Perfect Reporting

Feature Description

Upload configuration–specific files

Use Upload Center in the Administration page to upload and manage configuration–specific files for font, digital signature, ICC profile, SSH private key, SSL certificate, and JDBC client certificate. See Uploading and Managing Configuration–Specific Files.

Password protect report outputs

Configure password protection for report outputs in DOCX, PPTX, and XLSX format. Use the Open password property at the system level or report level. See PPTX Output Properties, DOCX Output Properties, and Excel 2007 Output Properties.

Apply a digital signature in PDF documents

Upload the digital signature file in Upload Center, enable a digital signature in PDF reports, and specify the location for the digital signature in the PDF document. See Applying a Digital Signature in PDF Documents.

Use data sets from Data Visualization

Use data sets from Data Visualization for pixel-prefect reports. See Creating a Data Set Using a Data Visualization Data Set.

Enable scalability in Excel templates to handle a large volume of data

Enable scalability in an Excel template to overcome the Microsoft Excel limitation of 65000 rows per sheet. See Enabling Excel Template Scalability.

Validate data model properties and SQL queries

Validate data model properties and optimize the SQL queries used for data sets, LOVs, and bursting definitions in data models. See Validating Data Models.

Optimize SQL queries

Use the Skip Unused Data Set Query, Optimize Query Execution, and Multithread Query Execution data model properties to optimize SQL queries. See Setting Data Model Properties.

Deliver reports in compressed format

Compress the output prior to delivery to reduce the output size. See Setting Output Options.

Request email notification when an email is delivered or read

Configure to receive email notifications when emails are delivered or read. See Report Output Destination Types.

Data Models

Feature Description

Externalized database connections

Define database connections in Console and use them in Oracle Analytics Cloud Developer Client Tool. See Managing Database Connections for Data Modeler and Connecting to a Data Source using an External Connection.

Release 18.2.5 - June 2018

Feature Description

Duplicate a data set

Duplicate an uploaded data set that is listed in the Data Sets page to help you further curate (organize and integrate from various sources) data in projects.

See Duplicating Data Sets.

External communication over HTTP

(Essbase services only) You can handle all external communications over HTTPS without the need to open additional ports to communicate with Essbase. See Connecting to Essnet over HTTP.

Release 18.2.3 - May 2018

Feature Description

Bring Your Own License

Leverage your existing on-premises license entitlement when you deploy Oracle Analytics Cloud in a user-managed environment.

Get license support through your existing on-premises support contract.

See Creating Services with Oracle Analytics Cloud.

Service creation

Database configuration made easier. The Schema Prefix field is no longer required. See Creating a Service.

Release 18.2.1 - April 2018

Feature Description

Oracle Analytics Cloud

A fully managed version of Oracle Analytics Cloud that’s quick to set up and requires minimal administration.

About Oracle Analytics Cloud Products.

To set up a service, see Create Services with Oracle Analytics Cloud.

MaxL Client utility in Essbase

A MaxL client utility is available to download and install from the Utilities section in Oracle Analytics Cloud – Essbase. If you use Oracle Analytics Cloud, this utility provides a way to execute MaxL statements for administration and querying with Essbase.

Service Management

Feature Description

Service creation

Storage container configuration made easier. The fields Storage Service Base URL and Storage Container are combined into a single field Storage Container URL. See Creating a Service.

Update the password for cloud storage

(BI and data visualization services) Update the password Oracle Analytics Cloud uses to access Oracle Cloud Infrastructure Object Storage Classic from the Console instead of using a script. Use the new Update Cloud Storage Password option on the Connections tab. See Updating the Cloud Storage Password.

Configure a public storage container for data visualizations

Share data visualizations through a public storage container. Specify the container you want to use from the Console instead of using a script. Use the new Edit option for Public Web Store on the Social tab. See Setting Up a Public Container to Share Visualizations.

Add one predefined application role to another

(BI and data visualization services) Oracle Analytics Cloud comes with several predefined applications roles. Use the new Add Predefined Member option to add one predefined application role to another. For advanced users only. See Adding One Predefined Application Role to Another (Advanced).

Update the database schema passwords

(BI and data visualization services) Use the script reset_schema_password to update the database administrator password used by BI and data visualization services. See Updating Database Credentials (BI Service Script).

Release 18.1.3 - February 2018

New features for Oracle Analytics Cloud-Classic.

Reports and Dashboards

Essbase Edition, Enterprise Edition

Feature Description
Use agents to deliver content

Create agents that deliver your analysis, dashboards, and briefing books to specific recipients and to subscribers. See Enabling Content Delivery Through Agents and Automating Business Processes Using Agents.

Set up devices and individual delivery profiles

Configure one or more devices where you want alerts and content from Oracle Analytics Cloud to be delivered. Set up personal delivery profiles to suit your different needs. See Configuring Your Devices and Delivery Profile.

Manage your deliveries in one place

You can manage all your deliveries from the Console, that is, email deliveries and deliveries generated by agents.

Synopsis mobile app

Create and share instant analytics from data on your mobile devices. See What can I do with Oracle Analytics Cloud Synopsis?

Service Management

Feature Description

Configure a public storage container during service creation

Share data visualizations through a public storage container. Specify the container you want to use when you set up your service. See Creating a Service.

Update the password for cloud storage

Update the credentials Oracle Analytics Cloud uses to access Oracle Cloud Infrastructure Object Storage Classic. See Managing Credentials.

Connect to EssNet over HTTP

Connect from any software using Essbase Real Time Client (RTC) over HTTP protocol without needing to open ports or perform other configuration or communication. See Connecting to EssNet over HTTP.

Update the database passwords for Essbase services

Use a script to update the database administrator password for an Essbase service. See Updating Essbase Database Credentials.

Essbase

Feature Description

Install Cube Designer from the scenarios page

You can download the Cube Designer installer directly from the Scenarios page in addition to the traditional installation from within Smart View. See Install the Smart View Cube Designer Extension.

Export MDX query output to the service

You can run MDX queries and have their metadata and data output results exported to saved structures on Essbase. This is an alternative to viewing the query output on a client. For syntax used to export an MDX query, see MDX Export Specification.

Release 17.4.5 - December 2017

New features for Oracle Analytics Cloud-Classic.

Service Management

Feature Description

Oracle Identity Cloud Service integration

Secure your Oracle Analytics Cloud deployment using Oracle Identity Cloud Service. The Foundation Edition is available with all Cloud Accounts. See Managing Oracle Identity Cloud Service Users and Migrating LDAP-Based Services to Oracle Identity Cloud Service .

Load balancing

An Oracle managed load balancer is configured automatically for services using Oracle Identity Cloud Service. See About Oracle Cloud Infrastructure Load Balancing Classic.

Scale out and scale in

Scaling lets you add or remove resources for a service in response to changes in load. Default deployments include one node or "analytics server”. You can add additional nodes if more resources are required, up to the maximum ten, until performance is satisfactory. See Scaling a Cluster.

Configure a public storage area

Share data visualizations through a public storage container. Use a script to specify the container you want to use. See Creating a Public Storage Container for Sharing Content.

Migrate content from Oracle BI Enterprise Edition 11g

Export content from Oracle BI Enterprise Edition 11g to an archive (BAR file). Upload the archive to Oracle Analytics Cloud. See Migrating from Oracle BI Enterprise Edition 11g.

Migrate content from Oracle BI Enterprise Edition 12c

Migrate content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud. See Migrating From Oracle BI Enterprise Edition 12c.
Day by Day mobile app enhancements

Data Visualization

Standard Edition, Essbase Edition, Enterprise Edition

Feature Description
Brand new home page

Improved design that’s simple to navigate and easy to use. Personalize your home page to suit the way you want to work.

Use machine learning to make predictions and intelligent suggestions

You can use machine learning (ML) algorithms to show patterns and uncover insights in your data sets, and then add them to your visualizations.

  • Self service ML for diagnostics analytics of attributes (Explain).
  • Use the Machine Learning catalog to manage your ML scripts and models.
  • Use data flows to score and predict data sets using ML models.
  • Create a custom scenario for attributes by applying ML models to a data set.

See Working With Machine Learning.

Connect to more databases

You can connect to several data sources:

  • Oracle Data Warehouse Cloud Service.

  • Oracle Big Data Cloud Service.

  • Oracle Talent Management Cloud.

See Connecting to Database Data Sources.

Data flow enhancements

Improved narration and storytelling features Use improved narration to make presenting your data stories even easier. See Building Stories.
Include links to related content in your project Enhance visualizations by offering links to related content under a handy Data Actions menu. See Working with Data Actions.
Numeric values in file-based data sources uploaded as measures When you upload a file based data source, columns containing numeric values are imported as measures with the number data type.
More display formatting options for numbers and dates You can select from a wide range of number and date formats to choose the best display format for data in your visualizations. See Adjusting the Display Format of Date or Time Columns.
New properties area in the Data Panel For quick and easy access, the properties of objects you select are displayed in the Data Panel. See Adjusting Visualization Properties.
More options to copy, paste, and duplicate It’s often quicker to copy visualizations than starting from scratch. You can paste within the same canvas and between canvases in the same project.

Use the duplicate option to make copies of an object within the same canvas or to duplicate the entire canvas.

See Adjusting the Canvas Layout.

Add unrelated data sets to the same project Your projects can contain visualizations from multiple, unrelated data sets; that is, the data sets don't have to be joined.
Date and time intelligence You can seamlessly transition through different levels of time hierarchies or granularities with ease.
Data warning indicator Warning signs Warning icon indicate possible issues with your data. If you don't want to see any warnings in your projects you can hide them. Warnings never display in printed or shared output. See Visualization Data Warning Notification.
Background maps Use background maps to enhance your geographical visualizations. See Enhancing Visualizations with Map Backgrounds.
Coloring maps using attribute column values You can use color features to interpret the measure columns and attribute values in projects that include map visualizations. See Interpreting Data Measure and Attribute Values by Color in Map Visualizations.
Data replication

Build content packs for Oracle Cloud applications such as Oracle Service Cloud (RightNow) by easily importing a database into a cloud database without needing extract-transform-load (ETL) tools. See Replicating Data for Visualization Projects.

Control access to projects

Finely control who can access individual shared data visualization projects. See Controlling Access to Your Projects.

Set up social channels for sharing content

Set up social channels, such as Twitter, Slack, so that content authors can easily share their data visualizations with others. See Setting up Social Channels for Sharing Visualizations.

Improved sharing Use the Share icon to share a visualization, canvas, or story with others, as a file, by email, a printed page, on the cloud, Twitter, Slack, Public Web Store, and Oracle Content and Experience Cloud Service.

You can also share a project or folder only in DVA format, as a file, by email, and on the cloud.

See Importing and Sharing.

Embed visualizations in other applications

You can embed visualizations in a web page using web technology or Oracle JET.

See Embedding Visualizations in Other Web Pages.

Reports and Dashboards

Essbase Edition, Enterprise Edition

Feature Description
Create pixel-perfect reports

You can author, manage, and deliver highly formatted reports from your data. See Creating Pixel-Perfect Reports and Layouts and Publishing Reports.

Users familiar with Oracle’s on-premises product range might recognize this feature as Oracle BI Publisher.

Secure mail server connections for deliveries

Security options are available on the mail server connection you configure to deliver reports. See Setting Up an Email Server to Deliver Reports.

Data Modeling

Essbase Edition, Enterprise Edition

Feature Description
Import and export data models In Data Modeler, you can export a single data model to a JSON file and use the information in the file to recreate the model in another service.

See Importing a Data Model and Exporting a Data Model.

Essbase

Feature Description

Use new CLI commands and options

Create a stored local connection to use for streaming data load and dimension build. See Loading Dimensions and Data by Streaming from a Remote Database.

Control data-transfer compression options during file upload and download. See CLI commands upload and download.

Use calculation and partitioning enhancements

Calculation in hybrid mode is improved to work more efficiently when some intersections have #Missing values.

Calculation tracing is improved to work better with complex IF statements, and with hybrid mode calculations. Support is added for tracing implicit assignments.

Partitioning is simplified for single-instance Essbase deployments. If all cubes involved in a partition are hosted on the same instance of Oracle Analytics Cloud - Essbase, then no login credentials are needed as part of the partition setup. You must be signed in on the data target, and also provisioned on the data source. See Connecting Cubes. Additionally, the @XREF and @XWRITE calculation functions have expanded syntax so that you can either incorporate values from a remote cube, or from another cube on the same Essbase instance.

Use Scenario Management enhancements

You can revert scenario values to the base values. See Reverting Scenario Values Back to Base Values.

You can change scenario values to #Missing. See Setting Scenario Cells to #Missing.

Use Cube Designer enhancements

You can validate formulas in the Cube Designer Formula Editor. Validation works against existing cubes in the cloud service. It doesn’t detect application workbook changes that haven’t been applied to the cube. See Creating and Validating Member Formulas in Cube Designer.

In Cube Designer Hierarchy Viewer, you can display duplicate members in more than one dimension.

Release 17.3.5 - September 2017

New features for Oracle Analytics Cloud Classic.

Service Management

Feature Description

Scale up storage volumes

If you run out of disk space, it’s easy to add more storage. See Scaling Storage.

Data Visualization

Feature Description
Creating and Managing Data Sources

New data source connections

The following connection types are available, have limited support, and are marked as Beta in the user interface: OData, Oracle Docs, JDBC, and ODBC.

Data Source editor

Previously in Data Visualization you used the Data Source dialog to create or edit data sources. The Data Source dialog is replaced by the Data Source editor, which provides the same functionality but is more dynamic and easier to use. See Using the Data Source Editor.

CSV and text file delimiters

When uploading CSV and text files for data sources, you can specify a delimiter. Your choices are: Comma, Semicolon, Space, Tab, and Custom. If you select Custom, you then specify the delimiter used in your CSV file.

Subject areas as data sources

You can build data sources from Oracle Fusion Applications with Oracle Transactional Business Intelligence or Oracle BI EE subject areas. See Composing Data Sources from Subject Areas.

Data flow improvements

You can save a data flow as a database connection, which stores the data flow data to a database table. See Saving Data Flow Output Data to a Database.

You can merge two or more columns in a data flow to display as one column. See Merging Columns in a Data Flow.

The Data Flow editor layout is easier to use. See Using Data Flows to Curate Data Sources.

Creating and Working With Projects

Visualization types

You can create box plot, horizontal box plot, and waterfall visualizations.

Apply top or bottom N filters

You can use the top or bottom N filter to filter a measure to display a subset of its largest or smallest values. See Applying Top or Bottom N Filters.

Date and time column improvements

You can convert a text column into a true date, time, or timestamp column. See Converting Text Columns to Date or Time Columns.

You can adjust the display format of a date or time column to show a different level of granularity. See Adjusting the Display Format of Date or Time Columns.

Canvas duplication and multi-canvas reordering

You can duplicate an existing canvas on a visualization and use the duplicate canvas as a starting point for a similar canvas. You can also manually reorder the sequence of multiple canvases in a visualization. See Adjusting the Canvas Layout.

Support for event data at second or millisecond grain

Line visualizations can show a continuous date-time reading on the x-axis. You can analyze data at the second or millisecond grain. Previous versions of Data Visualization supported analyzing data at the day grain, only.

Custom map layers support

You can load and manage custom map layers in a project using geometric JSON files. See Adding Custom Map Layers.

Reports and Dashboards

Feature Description

Custom themes

Change the default reporting user interface logo, heading, and styles. See Applying Custom Logos and Dashboard Styles.

Localized captions

Provide reporting strings in multiple languages. See Localizing Presentation Catalog Captions.

Oracle Planning and Budgeting

Analyze Oracle Planning and Budgeting data. See Reporting With Data From Oracle Planning and Budgeting Cloud Services.

Smart View

Deploy your dashboards and analyses in Microsoft Office using Smart View. See Smart View and Oracle Analytics Cloud.

Data Modeling

Feature Description

Upload data models directly from Oracle BI Enterprise Edition

Redeploy data models from Oracle BI Enterprise Edition, so that you don’t have to start your data modelling from scratch. See Uploading Data Models from Oracle BI Enterprise Edition.

Edit data models in the cloud

If you’ve redeployed a data model from Oracle BI Enterprise Edition, you can edit it directly in the cloud using Oracle BI Administration Tool. See Editing a Data Model In The Cloud Using BI Administration Tools.

Essbase

Feature Description

Use new CLI commands and options

Use new Essbase Command Line Interface (CLI) commands: script, listfilters, listlocks, start, stop. Use streaming data load and dimension build options. See Essbase Command-Line Interface (CLI).

Run MaxL Statements

Execute MaxL statements from the CLI and from Jobs. See Executing MaxL Statements.

Create measures dimensions using column headers

Use formulas in tabular data column headers to create measures dimensions with calculated data during the transformation process. See About Using Tabular Data to Create Cubes.

Export cube files to your cloud service instance

When exporting a cube to an application workbook, you can save the exported cube files to your cloud service instance. See Exporting a Cube to an Application Workbook.

Aggregate based on unit weight

Using the @WEIGHTEDSUMX calculation function, you can aggregate all members in a member list, depending on the unit weight of each member. @WEIGHTEDSUMX improves the performance of aggregating currency databases by calling the calculation framework only once. See @WEIGHTEDSUMX.

Release 17.3.3 - August 2017

New features for Oracle Analytics Cloud-Classic.

Essbase

Feature Description

Edit load rules for dimension build and data load using SQL as a source

Create Essbase dimension build and data load rules, connect to an RDBMS, and load dimensions and data from SQL to an Essbase cube. See Loading Data Using a Rules File and Loading Dimensions and Data using SQL.

Drill through to RDBMS

Using data in an existing Essbase cube, drill through to an external data source. See Analyzing Data with Drill Through Reports.

Manage cubes using Cube Designer and application workbook enhancements

Use MDX enhancements

  • Nested SELECT clauses are supported on block storage as well as aggregate storage cubes. See MDX Sub Select.
  • Use an MDX Insert clause to update a database with new data, by inserting tuples from a source to a target. See MDX Insert Specification.

Use calculation and partitioning enhancements

  • Trace calculations to analyze member formula processing and refine your calculation scripts. See Tracing Calculations.
  • Create a location alias which you can later use to incorporate values of a source cube into your current, target cube. See Connecting Cubes.
  • Create transparent partitions to connect cubes. Replicated partitions are also available. See Connecting Cubes.
  • Change member solve order using Smart View.

Keep a data audit trail

Track changes to cube data, including changes to cell data, adding notes, attaching files, and referencing URLs. Export your log to an Excel spreadsheet, and perform ad hoc queries. See Tracking Changes to Data.

Store password for CLI session

Set and store a password in the Essbase Command Line tool. See Essbase Command-Line Interface (CLI).

Download script templates

Download sample MaxL scripts, calculation scripts, and batch scripts from Utilities, in the Sample Utility Scripts package. See the Readme in that package for more information.

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 Analytics Cloud

E81761-19

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

Primary Author: Denise Storm

This document describes new features and other notable changes for Oracle Analytics Cloud.

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.