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 update in which a specific feature or capability became available.

Topics:

For the latest Oracle Analytics news, product updates, customer and partner stories, and market insights, see https://blogs.oracle.com/analytics.

May 2022 Update

What's New in the May 2022 Update

Data Connectivity, Modeling, and Preparation

Feature Description

Add files to datasets with multiple tables

You can add files to datasets with multiple tables. When you create a dataset, you can add tables from relational sources, local subject areas, and files. Each new entity created in datasets can be based on any of these data sources. This enables you to add multiple files to one dataset where each file becomes a table and to define joins between tables within a dataset.

Add files from Dropbox and Google Drive to datasets with multiple tables You can add files from Dropbox or Google Drive to a dataset with multiple tables.

Augmented Analytics and Machine Learning

Feature Description

Persist right-click analytics calculations

When a user selects right-click outliers or right-click clusters on a visualization, the results directly show in the visualization. Most of the time, the clusters and outliers that were identified and made visible need to be re-used for a subsequent analysis with different metrics. For example, you can define five clusters on customers sales and service volume, and reuse these five exact clusters to analyze profit for each of them. A single click generates a custom calculation that you can reuse in any other visualization.

Increased limit size for Auto-Insights datasets (Oracle Database) By leveraging random sampling techniques, Auto-Insight generates pertinent insights from datasets of any size provided that they're sourced from an Oracle Database.

Performance, Compliance, and Administration

Feature Description

Track the progress and status of unarchive catalog jobs

Use the Unarchive Jobs tab in your My Accounts dialog to track the progress and current status of any unarchive catalog operations that you initiate.

March 2022 Update

What's New in the March 2022 Update

Data Connectivity, Modeling, and Preparation

Feature Description

Filter based on valid and invalid data in quality insights.

Quality Insights provides clear statistics about the validity of column values. Interact with the insight to filter column values based on their validity or invalidity. See Explore Your Data Using Quality Insights.

Exploring, Dashboarding, and Storytelling

Feature Description

Apply conditional formatting to performance tiles.

Define conditional formatting for performance tiles along with other visualization types. See Apply Conditional Formatting to a Visualization.

Provide authors fine-grain control on consumer options. Authors have fine-grain controls in Present to set visualization actions for consumer interactions on the dashboard (for example Export, Copy Data, Drill, Sort, and Zoom). See Create a Story and View a Story in Present Mode.
Control the dashboard filter bar. In the dashboard filter list box, use multiple filter options in the same control. Instead of putting six list boxes on the screen, manage a single filter bar with drop-down selections. See Create Dashboard Filters.
Find enhanced Auto Insights performance and more insights. Auto Insights has been enhanced for greater rendering performance and additional insights such as Metrics Forecasting. See Choose the Best Visualizations for a Dataset Using Auto Insights.

Augmented Analytics and Machine Learning

Feature Description

Integrate Oracle Functions with data flows.

Register an API call or custom script as a function. For example, suppose you want to execute a data flow that runs a custom Python script. You can upload the script to OCI Function-as-a-Service (FaaS) and define a function for it. Oracle Analytics then natively consumes the function, directly invoking the FaaS function from within a data flow safely and securely. See About Using OCI Functions in Oracle Analytics.

Performance, Compliance, and Administration

Feature Description

Manage content

Administrators can manage Oracle Analytics content from the Console. For example, if an employee leaves an organization, you might assign ownership of their workbooks and machine learning models to a different employee. See Change Ownership of Content.

Control email distribution Use settings to affect email distribution of content such as format, maximum size, and maximum number of recipients. See Email Delivered by Agents Options.
Troubleshoot deliveries If a delivery fails or completes with a warning you can drill down to more information. This will help you find out what went wrong and fix the problem. See Track the Reports You Distribute By Email or Through Agents.

What's Fixed in the March 2022 Update

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

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

January 2022 Update (6.4)

What's New in the January 2022 Update

Exploring, Dashboarding, and Storytelling

Feature Description

Redwood Design

Oracle Analytics fully adopts the new Oracle Design Concepts code-named Redwood. Product look and feel, as well as default colors and fonts will follow the Redwood guidelines created over years of research with close attention to usability and accessibility.

My Calculations Properties

Custom calculations in workbooks show similar properties to other measures.

Consumer Mode Navigation: Bottom Tabs

Authors have a new Bottom Tabs presentation style for curating the consumer navigation experience. Authors can select this style from the Presentation property panel. See Capture Insights.

Change Settings for Multiple Columns

Save time when changing settings for multiple columns. Multi-select columns in the Metadata view to change the Data Type, the Treat As setting, the aggregation type, and the hide setting for more than one column at once. See Configure Columns Properties in a Dataset.

Auto Insights

Oracle Analytics analyzes datasets when you create them and suggests which visualizations will give you the best insights. See Let Oracle Analytics Suggest the Best Visualizations for a Dataset Using Auto Insights.

Inner radius of a donut chart

In a donut chart, control the radius of the donut hole. See Pie and Treemap Graphs.

Augmented Analytics and Machine Learning

Feature Description

Streamlined Advanced Analytics capabilities for some sources

For some datasets such as Oracle EPM and Essbase, we've streamlined the user-interface for advanced analytics so that you won't produce unexpected results.

XGBoost and Neural Network Algorithms for Machine Learning

Register and apply XGBoost and Neural Network algorithms with Machine Learning.

Performance, Compliance, and Administration

Feature Description

Increased limits when you send analyses and dashboards by email

Increased limits on the number of data rows when you send unformatted reports by email (formats such as CSV, Excel, XML, and Tab Delimited).
  • 2-12 OCPUs: Limit increased to 200,000 rows.
  • 16 - 52 OCPU: Limit increased to 300,000 rows.

See Limits Delivering by Email (Classic Analyses and Dashboards).

User and role management enhancements

In the Console, the Users and Roles page has been redesigned so it's simple to navigate and easy to use. See Configure What Users Can See and Do.

There is an option to download membership data for users, groups, and application roles to a comma-delimited (CSV) file. This data is useful for auditing purposes and to find out exactly who has what access. See View and Export Membership Data.

Cache the dashboard list

Option to cache the list of available dashboards during each user session to improve performance.

See System Settings - Cache Dashboard Listing Dropdown Menu.

What's Fixed in the January 2022 Update

For a list of defects fixed in Oracle Analytics Cloud and Oracle Analytics Cloud Classic, see Doc ID 2832903.1.

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

October 2021 (Release 6.3)

What's New in 6.3

General

Feature Description

Projects renamed to workbooks

In the Oracle Analytics user interface and user assistance, "projects" have been renamed to "workbooks." Use workbooks to organize your visualizations just as you've done for projects. See Begin to Build a Workbook and Create Visualizations.

Increased limits when you send analyses and dashboards by email Increased limits on the number of data rows when you send analyses and dashboards by email.

Unformatted data limits (formats such as CSV, Excel, XML, and Tab Delimited):

  • 2-12 OCPUs: Limit increased to 100,000 rows.
  • 16 - 52 OCPU: Limit increased to 200,000 rows.

Formatted data limits (formats such as PDF, Excel, Powerpoint, and Web Archive/HTML):

  • 2-12 OCPUs: Limit increased to 50,000 rows.
  • 16 - 52 OCPU: Limit increased to 100,000 rows.

See Limits Delivering by Email (Classic Analyses and Dashboards).

Share feedback on Oracle Analytics Provide feedback on Oracle Analytics. From the user-profile menu, select Leave a Review, and on the resulting page share feedback with Gartner Peer Insights.

Visualization

Feature Description

Position tables and pivot tables

Format visualizations more easily with enhanced positioning of tables and pivot tables.

Data Preparation

Feature Description
Analyze the performance of visualization components Use built-in Performance Tools to analyze statistics such as query time, server time, and streaming time for visualization components in workbooks. See Developer Reference.
Compute machine learning model lift and gain values Evaluate prediction machine learning models more effectively using lift and gain statistics that you can visualize. See Evaluate Machine Learning Models Using Lift and Gain Charts.
Experience improved performance for datasets output to DSS. Improved Data Flow query performance for datasets written to Data Set Storage (DSS).

Oracle Transactional Business Intelligence and remote Oracle Analytics Server and Oracle Business Intelligence Enterprise Edition sources for datasets with multiple tables

Use the Oracle Applications connection to add tables from Oracle Transactional Business Intelligence and remote Oracle Analytics Server and Oracle Business Intelligence Enterprise Edition subject areas and reports to datasets containing multiple tables. See Create a Dataset from an Oracle Application's Subject Area and Create a Dataset from an Oracle Application's Analysis.

Administration

Feature Description

Export snapshots to storage in Oracle Cloud

Store your Oracle Analytics Cloud snapshots on Oracle Cloud. Especially useful if you manage large snapshots, experience issues downloading large snapshots to your local file system, or move snapshots between cloud environments. See Export and Import Snapshots.

What's Fixed in 6.3

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

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

August 2021 (Release 6.2)

What's New in 6.2

General

Feature Description
Support for Analytic Views Model and visualize data from Oracle Database Analytic Views. Leverage the advanced aggregation capabilities and high performance for voluminous data in the Oracle Database. See Build a Semantic Model from Analytics Views in Oracle Autonomous Data Warehouse (setup), Connect to Analytic Views (visualize).
Connect to Microsoft Azure Synapse Visualize data from Microsoft Azure Synapse data sources. See Supported Data Sources.
Expression filters for entities in datasets with multiple tables Use expression filters in datasets that contain multiple tables. See Apply a Filter to a Dataset Table.
Local subject areas in datasets with multiple tables Add local subject area data sources to datasets that contain multiple tables. See Create a Dataset from a Local Subject Area.

Refresh profile results and recommendations

Refresh profile results and enrichment recommendations after you add or update custom knowledge. See Accept Enrichment Recommendations.

Visualization

Feature Description
Annotations on canvases In Visualize, you can add notes to canvases and tie notes to specific data points. See Add Notes to a Visualization.
Enhanced map visualizations with Mapbox libraries Access smooth and powerful interactions with map visualizations through client-side libraries from Mapbox GL and WebGL.

Select multiple visualizations on a canvas

Multi-select visualizations on a canvas to easily change shared properties for groups of content. See Work with Multiple Visualizations on a Canvas.

Administration

Feature Description
System setting enhancements There's a new system setting in the Console.
  • Repeat Rows on Excel Exports for Tables and Pivots - Specifies whether cells that span rows or columns are repeated when exporting tables and pivot tables to Microsoft Excel. See Configure Advanced Options.

What's Fixed in 6.2

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

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

July 2021 (Release 6.1)

What's New in 6.1

General

Feature Description

Enable Oracle’s Redwood experience

Enable Oracle’s Redwood theme in Oracle Analytics before it becomes the default look and feel. Administrators can try out the Redwood design and optionally, switch Oracle Analytics to use this theme so everyone has the Redwood experience. See Try Out or Switch to Oracle's Redwood Theme.

Support for Back button in browsers Press the Back button in the browser to navigate within the interface such as between editors and the Home page.

Visualization

Feature Description

Conditional formatting

Use conditional formatting to highlight important data events in your visualizations so that you can take action. See Apply Conditional Formatting to a Visualization.

Null values in list filters

Indicate in a list filter whether to include null values in the results. See Apply List Filters.

Automatic refresh of list filters

When a list filter with a large number of values is displayed, the list is refreshed when the user pages and when all possible values in the current page are selected. See Apply List Filters.

Control interactivity for consumers

When defining a consumer experience in Narrate, you as the author can use the context menu to turn on and off the user interactivity options for the consumer. See Create a Story.

Sort data in visualizations by columns that aren't in the visualization

Sort data in a visualization by a column that's not included in the visualization. See Sort, Drill, Select Data, and Apply Statistics in Visualization Canvases.

Print visualizations on canvases with enhanced options

Print visualizations on canvases with logical default print sizes based on the printing target and enhanced options for various sources. See Print a Visualization, Canvas, or Story.

Export visualizations to CSV with the same limits as Classic

Increased limits on the number of data rows you can export to a CSV file from visualizations.
  • 2-12 OCPUs: Export limit increased to 2 million rows.
  • 16 - 52 OCPU: Export limit increased to 4 million rows.
Sort Null Values First Specify whether to sort NULL values before other values (On) or after (Off). Select the value that matches your database. See Sort Null Values First.

Data Preparation

Feature Description

Auto-join option in datasets with multiple tables

Use the Auto Join Tables option to turn off or on automatic join creation in datasets. By default, joins are created automatically when you drag and drop tables onto the Join Diagram. In some cases it's useful to turn auto joins off and build joins manually. See Disable Auto Joins in Data Sets.

Pixel-Perfect Reporting

Feature Description

Protect pixel-perfect PDF report files with AES256 encryption

Protect PDF files of pixel-perfect reports with AES-256 encryption that is FIPS 140-2 compliant. See Encrypt PDF Documents.

Administration

Feature Description
System setting enhancements Two new system settings in the Console.
  • Hide EPM Cloud members with No Access - Specifies whether users can view all EPM dimension members in a hierarchy list of values or when adding the hierarchy to a canvas even if they don't have data access to some of the members.
  • Preview Redwood Theme - Specifies whether to apply the Oracle Redwood theme on a global basis in Oracle Analytics.

See Configure Advanced Options.

What's Fixed in 6.1

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

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

May 2021 (Release 6.0)

What's New in 6.0

General

Feature Description

Reload datasets on a schedule

Schedule data reloads for any dataset with one or more tables set to automatically cache data. View information about the dataset reloads, such as history and schedule details. See Schedule a Data Set Reload and View a Data Set Reload Schedule's Details.

Hierarchy navigation for Essbase and EPM data sources

Navigate Essbase or Enterprise Performance Management (EPM) hierarchies when connecting to subject areas or datasets. You can drill up and down the hierarchy tree in pivot and table visualizations. You can't use hierarchies in filters but you can use a hierarchy level in a filter. See Sort and Select Data in Visualization Canvases.

Customize auto-refresh in visualizations

Set the frequency at which the data automatically refreshes in visualizations on a canvas. See Visualize Canvas Layout and Properties.

Visualization

Feature Description

On-canvas filter types

Select various on-canvas filter types such as Top Bottom N and Relative Time. See Create On-Canvas Filters and Apply Different Filter Types.

On-canvas  date filters

Use the on-canvas date selector and the relative time filter for date filters. See Create On-Canvas Filters and Apply Different Filter Types.

On-canvas  measure filters

Use the on-canvas measure selector and the top and bottom time filter for measures. See Create On-Canvas Filters and Apply Different Filter Types.

Tooltips on visualization titles

Enter your own tooltip text to display when you hover over a visualization title. See Visualize Properties.

Improved sort options

Use the Sort dialog to configure sorts and clearly see the sort order and any sort conflicts. See Sort and Select Data in Visualization Canvases.

Time series forecasting

Perform time series analysis forecasting directly from data flows. See Add a Time Series Forecast to a Data Flow.

Graph analytics

Enhance your visualizations of network graphs using powerful property graph analytics. For example, you can compute the shortest path between two vertices or identify connected vertices in the graph. See Add Graph Analytics to a Data Flow.

Improved home page search

Enter advanced search commands in the search bar to tailor your search results for exact matches, multi-term matches, and field-level matches. See Advanced Search Commands for Finding Content.

Map layers in non-joined datasets

Create map layers in a visualization where the data between the layers isn't joined. See Apply Multiple Data Layers on a Single Map Visualization.

Export individual visualizations

Export from an individual visualization in a project. Specifically, this allows data export from a visualization embedded in another application or web page. See Export a Visualization or Story.

Average aggregation in Waterfall visualizations

When you add a Detail to a Waterfall visualization, the weighted average is calculated and displayed in the Bridge report.

Data Sources

Feature Description

Connect to remote JDBC data sources

Analyze data from remote data sources using custom JDBC drivers (through Data Gateway). See Connect to Remote Data Using Generic JDBC.

Connect to Google BigQuery

Analyze data from Google BigQuery data sources. See Connect to Google BigQuery.

Data Preparation

Feature Description

Data sets with multiple tables

Perform self-service data modeling with datasets by adding multiple tables to a dataset from one or more relational data source connections. See Data Sources Available for Use in Data Sets Containing Multiple Tables and Create a Data Set from a Connection.

Custom knowledge

Extend the system knowledge in Oracle Analytics by adding your own enterprise-specific reference data. This increases Oracle Analytic's ability to automatically discover and classify semantic types of interest and to offer more relevant enrichment  recommendations. See Add Custom Knowledge for Data Enrichment.

Data quality insights

Explore your data, and use a visual overview of your content to assess and improve data quality. See Explore Your Data Using Quality Insights.

Frequent Item Set function supports association rules

Create more powerful Frequent Item Set analyses using enhanced algorithms. See Database Analytics Functions.

Oracle machine learning supports Feature Extraction

Apply a registered Oracle machine learning Feature Extraction model's view to a data flow. See Apply a Predictive or Oracle Machine Learning Model to a Data Set.

Pixel-Perfect Reporting

Feature Description

Deliver pixel-perfect reports to Object Storage

Administrators can configure Object Storage as a delivery channel for Publisher. In your scheduled jobs and bursting queries, you can choose to deliver reports to the configured Object Storage. See Add an Object Storage and Define the Query for Delivery XML.

Pixel-perfect reports support datasets with multiple tables

Report authors can use datasets with multiple tables to create pixel-perfect reports. See Use Self-Service Analytics.

What's Fixed in 6.0

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

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

January 2021 (Release 5.9)

What's New in 5.9

General

Feature Description

Clean Home page experience

The Home page is the entry point for users of different roles such as analysts, consumers, and administrators. The Home page is automatically optimized to show each user only the relevant artifact types and options and to remove clutter that might not be relevant or useful. See Access Oracle Analytics Cloud.

Data Action: Avoid passing duplicate filters

When you create a data action using multiple data points to filter another canvas, and you return to the original canvas and invoke the data action using different data points, the new expression filter replaces the previous filter on the target canvas. See Create Data Actions to Connect Visualization Canvases.

Data Action: Support single/multi selection

You can restrict the invocation of a data action to work only for a single value by setting Supports Multiple Selection to Off. You set this when the selection of multiple data points will result in an error (for example, with some third-party REST APIs). See Use Data Actions to Connect to Canvases, External URLs and External Containers.

Day by Day information included in snapshots

You can include Day by Day content such as the "For You" feed, bring backs, comments, and shared cards when you take a snapshot. This option allows you to migrate your Day by Day content from one Oracle Analytics Cloud environment to another. See Options When You Take a Snapshot.

Show database model full details in Oracle Analytics Cloud inspectors - Model Explainability

Oracle Analytics provides explainability about your registered Oracle machine learning models. Outputs describe how the Oracle machine learning model computes the predicted results for each record in the dataset and allow you to aggregate these results. See Inspect Registered Oracle Machine Learning Models.

Show database model full details in Oracle Analytics Cloud inspectors - Visualize Database Views

Visualize a registered Oracle machine learning model's views to better understand the model and iteratively improve the model's overall accuracy. See Visualize a Registered Oracle Machine Learning Model's View.

System Settings enhancements

Administrators can enable or disable data visualization brushing capabilities for datasets and subject areas, visibility of the Database Analytics node in data flows, and whether users can use request variables to override database features. See About Advanced Configuration.

Visualization

Feature Description

Ability to add new map backgrounds

You can add a map hosted on a web server as a map background using the Web Map Service (WMS) protocol and XYZ tile layers. See Add Map Backgrounds.

Apply no sort to data

In visualizations, data is always sorted by default. You can use the Sort By None option to "unsort" or return the data to its original order. See Sort Data in Visualizations.

Area chart visualization

In addition to the stacked area and 100% stacked area, you can visualize data in an area chart. See Change Visualization Types.

Improved chrome density in the data panel

The data panel across all visualization editors uses horizontal tabs instead of vertical tabs, and the density of the tree content is increased. See Build a Visualization by Adding Data from Data Panel.

Improved progress bar behavior

The blue bars that were previously visible across the screen when data was refreshed have been removed. The data refresh experience is more subtle. Hover the mouse pointer over a visualization to see refresh details or to cancel. See Refresh Data in a Project.

Increased limits on the number of data rows you can export from analyses and dashboards

The number of data rows that you can export from analyses and dashboards has increased. See Limits Exporting Data (Classic Analyses and Dashboards).

  • Unformatted reports (CSV, Excel, XML, and Tab Delimited): Limit increased to 2 million rows (2-12 OCPUs) and 4 million rows (16 - 52 OCPUs).
  • Formatted reports (PDF, Excel, Powerpoint, HTML): Limit increased to 200,000 rows (2-12 OCPUs) and 400,000 rows (16 - 52 OCPUs).

Increased limits on the number of rows returned when you query data for visualizations, analyses, and dashboards

The number of rows returned when you query data for visualizations, analyses, and dashboards has increased to 2 million rows (2-12 OCPUs) and 4 million rows (16 - 52 OCPUs). See Limits Querying Data (Data Visualization Projects, Classic Analyses and Dashboards).

Pass filters between the filter bar and visualizations

Filters for a canvas or project are defined on the top bar, and filters for a visualization are defined on the grammar. You can move a filter from one scope to another. See Change the Scope of Filters Between the Main Filter Bar and Visualizations.

Respect the canvas aspect ratio when exporting

You can select to maintain the canvas aspect ratio, ensuring that the outcome is closest to your intent. See Print a Visualization, Canvas, or Story.

Sort by multiple columns

You can select multiple sort columns for a visualization. You can create nested sorts based on a combination of the attributes and measures in the visualization. See Sort Data in Visualizations.

Trim spaces on text columns

You can easily trim or remove leading and trailing spaces on text columns using the transform options menu. See Transform Data Using Column Menu Options.

Data Sources

Feature Description

Impersonation for Kerberos connection

When creating a connection to Hive, you can include the Kerberos authentication type and impersonation details. See Create a Database Connection with Kerberos Authentication.

Data Preparation

Feature Description

Support for database text tokenization in data flows

An advanced text-analytics technique is applied to user data to identify and list the words most frequently appearing within a text data-column. See Support for database text tokenization in data flows.

Support for Database Frequent Item Set (Market Basket) in data flows

Discover relationships in your data by identifying sets of items that often appear together. This data mining technique is known as association rule learning, affinity analysis, and market basket analysis. See Support for database text tokenization in data flows.

Pixel-Perfect Reporting

Feature Description

Bursting for self-service analytics datasets

For pixel-perfect reports, you can burst reports of data from self-service analytics datasets. See Use a Visualized Data Set to Add a Bursting Definition to Your Semantic Model.

What's Fixed in 5.9

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

September 2020 (Release 5.8)

What's New in 5.8

Visualization

Feature Description
Consistent legend properties across visualizations

The following visualizations have properties (such as location and fonts) added to their legend: Sankey, Network, Tree Diagram, and Chord.

See Adjust Visualization Properties.

Image backgrounds for heat maps

Visualize data with heat map layers on your custom image maps.

See Apply Map Backgrounds and Map Layers to Enhance Visualizations.

Single header on all pages

The user interface in Oracle Analytics has been enhanced with a single header that helps to maximize your workspace. With the content density provided, you can realize the benefits of your viewing capability with a modernized user interface and improved navigation.

See Access Oracle Analytics Cloud.

Toggle "Use as Filter" on visualization

Oracle Analytics allows you to interact with content in a dashboard to filter analyses on an individual basis. You can use top-level filters and on-canvas filters to allow your users to decide which filters should be passed and to where. Using breadcrumb details, you can easily see which filters are being applied where.

See How the Number of Data Sets Affects Filters.

Data Sources

Feature Description
Enhanced Essbase database connections

You can connect directly to remote on-premise Essbase data sources, and you can connect through the .rpd file using Oracle Analytics Cloud Data Gateway (which is the recommended option).

See Connect to Essbase.

Enrichments for live datasets

You can leverage enrichments for live datasets along with cached or file-based datasets.

See About Data Preparation.

Query semantic models remotely

Query your Oracle Analytics Cloud semantic model from an external client using JDBC. See Query Semantic Models Remotely Using JDBC in either:

Pixel-Perfect Reporting

Feature Description
Additional semantic model validation messages

Additional rules and improved query validation messages incorporated in the semantic model help report authors follow best practices.

See Semantic Model Validation Messages.

XML data pruning

Data extraction from data sources often includes additional XML elements that aren’t used by the report layout. If you enable XML data pruning, Publisher removes the unnecessary data elements and builds the XML structure using only the data fields that are mapped to the layout fields. Data pruning improves performance, especially for extremely large data extractions.

See Semantic Model Properties and Set Output Options.

General

Feature Description
Customized time-zone setting

Properties that affect the date and time of the system are commonly used in analytics. These properties can drive functions such as rolling periods and date differences, and you can use them to determine when to send notifications. Oracle Analytics provides the ability to use these date-time properties in SQL functions. For instance, you can query for a value this minute and compare that same value to what happened 10 minutes earlier. The Default Time Zone for Date Calculations setting allows you to configure your time zone.

See Format Options.

Propagate shared folder permissions to associated artifacts

To allow you to effectively manage shared content among users, you can select whether to grant permissions to other users when saving content in shared folders or moving content among shared folders.

See Assign Shared Folder and Project Permissions.

Support for token based authentication for embedded Oracle Analytics content

You can use authentication tokens (which you obtain from APIs in Oracle Identity Cloud Service) with embedded canvases in Oracle Analytics.

See Use Token Authentication.

What's Fixed in 5.8

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

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

July 2020 (Release 5.7)

What's New in 5.7

Visualization

Feature Description
Spark charts within performance tiles You can liven up your visualizations with spark charts added to tiles. See Examine Trends with Spark Charts.
Responsive canvas layouts You can use controls for setting vertical and horizontal scrolling of canvas reports and automatic responsive design across screen resolutions. See Adjust the Visualization Canvas Layout.
On-canvas filters You can add on-canvas filters that allow users to choose, change, and apply filters to attribute columns within some or all of the visualizations on the canvas. See Add an On-Canvas Filter.
Oracle machine learning models and Oracle Analytics Cloud In Oracle Analytics Cloud, you can register and use Oracle machine learning models to model, score, and output large datasets on the database. You can register and use Oracle machine learning models from Oracle Database and Oracle Autonomous Data Warehouse connections. See How Can I Use Oracle Machine Learning Models In Oracle Analytics?.
Top/Bottom filters for attributes Add a Top/Bottom filter for an attribute and then pick the measure. Previously you could only add the Top/Bottom filter for a measure and then pick the attribute. See Apply Top Bottom N Filters.
Bridge reports You can use the Waterfall visualization to build a bridge report. A bridge report groups data by contributions of each member to the overall variation between values of categories. For example, show the respective contribution of various products to the total sales variation year by year. See Create a Project and Add Data Sets.
Content paging rows setting You can specify the maximum number of rows you want displayed for content paging in table and pivot table views in analyses and dashboards. See View Options.

Pixel-Perfect Reporting

Feature Description

Publisher auto-purges the old records of scheduled jobs

Job history data that's more than 180 days old is automatically and periodically purged. See View Report Job History and Saved Output.

Data Preparation

Feature Description
Database Advanced Analytics functions in data flows

You can consume advanced analytics functions from Oracle Autonomous Data Warehouse and Oracle Database. These include Dynamic Clustering and Dynamic Anomalies, Unpivoting of columns and rows, and Smart sampling. See Add Analytic Functions to a Data Flow.

What's Fixed in 5.7

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

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

May 2020 (Release 5.6)

What's New in 5.6

Visualization

Feature Description
Waterfall visualization enhancements You can do the following with waterfall visualizations:
  • Assign custom colors for increase and decrease values.
  • Configure data labels to show either actual values or variation values.
Improved usability of the Canvas Bar As you create a project, you have many different tabs of analyses. Explore the improved content density of canvas names for better visibility and quick duplication of a canvas for iterative report creation and testing. As you duplicate or copy canvas tabs, new canvasses are added next to the original and not at the end of the list for ease of accessibility.
Create digitized custom map layers

Easily create custom interactive visualizations from any image. Upload images and create map layers that support defining areas on the images with no-code polygon definitions bound to data interactively. See Use an Image as a Map Background and Draw Map Layer Shapes Onto the Image.

Enhanced map rendering and ability to disable gestures The performance of map rendering is enhanced including data truncation warnings when using large datasets. You can lock the display of a map and disable interactive gestures for a better experience.
Copy calculation expressions to the Clipboard

Access a simple menu option to copy an entire expression to the Clipboard without opening the formula editor.

Quicker calculations

Quickly copy and duplicate custom calculations to make backup copies, and to test syntax scenarios quickly.

Flexible and persistent cell sizing in tables and pivot tables Enhance the clarity of tables and pivot tables. You can control the size of columns and rows for specific data points that need more attention or more room for visibility.
Data Actions to Publisher reports

Create data actions to navigate easily to a Publisher report. See Use Data Actions to Connect to Oracle Analytics Publisher Reports.

Authentication methods for embedded analytics content

Configure login prompt or 3-Legged OAuth authentication for your web application or portal web page that contains embedded analytics content. See Add Authentication.

Connection

Feature Description
Microsoft Azure SQL Database Visualize data from Microsoft Azure SQL Database. See Supported Data Sources.
Remote MySQL database Access on-premise MySQL databases using self-service connections (requires Remote Data Gateway). See Supported Data Sources.

Pixel-Perfect Reporting

Feature Description
Remote connectivity support for data sources

Use Data Gateway to connect Publisher to remote Oracle Database, DB2, and SQL Server data sources. See Set Up a JDBC Connection to an On-premise Data Source.

Dynamic images from Content Server in reports Use the RTF and XPT templates to include dynamic images from Content Server. See About Images.
Property to affect leading and trailing spaces Configure the Trim Leading and Trailing Spaces From Parameter Value semantic model property to remove the leading and trailing spaces from parameter values. See Semantic Model Properties.
XML data chunking for large datasets

If you enable XML data chunking for processing large datasets, then:

  • You don’t need to specify page numbering in the template. The consolidated PDF output includes the page numbers.
  • You can use the XSL template.

See XML Data Chunking.

Data Preparation

Feature Description
Data preparation - enhanced search and replace Perform advanced search and replace and pattern matching using powerful regular expressions (also referred to as regex). See Transform Data Using Replace.
Additional Model Training Output for Clusters

Create more powerful cluster analyses using extended fields that assist in visualizing the output of your model with network charts to see your output (that is, Explainable AI). See Train a Clustering Model in a Data Flow.

Simplified Data Set Editor You can set properties for incremental data refreshes, caching rules, and flexible column management in a single page Data Set Editor.
Enhanced Oracle Enterprise Performance Management Cloud (EPM) semantic modeling

Take advantage of the preinstalled Analytic Data Modeling (ADM) driver to create enhanced reports. See Overview to Integration with Planning, Close and Tax Reporting on Oracle EPM Platform.

Deployment and Administration

Feature Description
Use access control rules to restrict access to Oracle Analytics Cloud with a public endpoint

If you deploy Oracle Analytics Cloud with a public internet accessible endpoint, you can restrict access through one or more rules.

See Restrict Access to Oracle Analytics Cloud Deployed with a Public Endpoint.

Deploy Oracle Analytics Cloud with a private endpoint

Restrict access to Oracle Analytics Cloud through a private endpoint. Private access means that traffic doesn't go over the internet. Private access can be from hosts within your virtual cloud network (VCN) or your on-premise network.

See Deploy Oracle Analytics Cloud with a Private Endpoint.

Discover important network and security information for Oracle Analytics Cloud instances more easily

A new tab in Oracle Cloud Infrastructure Console displays the host name, IP address and gateway IP address of your Oracle Analytics Cloud instance, plus useful information about the identity provider (Oracle Identity Cloud Service).

See Find the IP Address or Host Name of Your Oracle Analytics Cloud Instance.

General

Feature Description
Oracle Analytics Cloud available in Hyderabad and Jeddah

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in India South (Hyderabad) and Saudi Arabia West (Jeddah).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

Improved System Settings interface Explore the improved interface of the System Settings page for faster navigation. See Configure Advanced Options.
Administrator Mode in Day by Day to push content into feeds for suggested viewing With the Administrator Mode in Oracle Analytics Day by Day, you can add to the Recommended feed of all the users in your organization. See Perform Administrator Tasks.
User-assistance enhancements

We've introduced two new guides to make it easier to find user-assistance:

  • Connecting Oracle Analytics Cloud to Your Data - Collates connection information that we moved from Visualizing Data and Building Reports in Oracle Analytics Cloud and Preparing Data in Oracle Analytics Cloud.
  • Modeling Enterprise Data in Oracle Analytics Cloud - Collates modeling information that we moved from Visualizing Data and Building Reports in Oracle Analytics Cloud, Designing Pixel-Perfect Reports in Oracle Analytics Cloud, and Preparing Data in Oracle Analytics Cloud.

In addition, the Preparing Data in Oracle Analytics Cloud guide is renamed Configuring Oracle Analytics Cloud.

What's Fixed in 5.6

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

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

Recent Product Updates

Here’s an overview of new product deployment options for Oracle Analytics Cloud, including region availability updates.

February 2022

Update Description
Customer-managed data encryption

Use Vault services in Oracle Cloud Infrastructure to create and manage your own encryption keys for Oracle Analytics Cloud. See Encrypt Sensitive Information.

Custom encryption keys can be used as an alternative to Oracle-managed keys to encrypt data in Oracle Analytics Cloud, such as your file-based datasets, any data in datasets that's configured for caching, and any credentials that are used to connect to your data sources.

Available in Stockholm and Johannesburg

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Sweden Central (Stockholm) and South Africa Central (Johannesburg).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

January 2022

Update Description
Available in Milan

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Italy Northwest (Milan).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

December 2021

Update Description
Available in Abu Dhabi, Marseille, and Singapore

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in France South (Marseille), Singapore (Singapore), and UAE Central (Abu Dhabi).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

Usage and connection error metrics
In Oracle Cloud Infrastructure Console, you can use charts to monitor key usage and error metrics for Oracle Analytics Cloud:
  • Query capacity usage
  • Data source connection errors

See Monitor Metrics.

November 2021

Update Description
Identity domains in IAM

Oracle Cloud Infrastructure Identity and Access Management (IAM) now offers identity domains; a new way to manage users and groups.

Some Oracle Cloud regions have been updated to use identity domains. If you have a new cloud account in one of these regions, you will use identity domains to manage users and groups who perform tasks in both Oracle Analytics Cloud and Oracle Cloud Infrastructure. If your region hasn't been updated to use identity domains, your cloud account is federated with Oracle Identity Cloud Service.

To determine whether your cloud account offers identity domains or Oracle Identity Cloud Service, see About Setting Up Users.

Available in Jerusalem

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Israel 1 (Jerusalem).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

August 2021

Update Description
Available in Vinhedo

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Brazil Southeast (Vinhedo).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

April 2021

Update Description
Navigation in Oracle Cloud Infrastructure Console

The way that you navigate around Oracle Cloud Infrastructure Console has been updated to give you a better customer experience. To find out more, see Announcing Improved Navigation for the OCI Console.

Available in Santiago

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Chile Central (Santiago).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

February 2021

Update Description
Available in Cardiff

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in UK West (Newport).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

January 2021

Update Description
Connect to private data sources through a private access channel

Use a private access channel to connect Oracle Analytics Cloud to private data sources within your virtual cloud network (VCN) on Oracle Cloud Infrastructure or within other networks peered to the VCN such as your corporate network.

See Connect to Private Data Sources Through a Private Access Channel.

Configure a vanity URL

Customize the URL for your Oracle Analytics Cloud instance. Configure a vanity URL instead of the default URL that Oracle provides.

See Set Up a Custom Vanity URL.

November 2020

Update Description
Available in Dubai

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in UAE East (Dubai).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

September 2020

Update Description
Available in San Jose

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in US West (San Jose).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

August 2020

Update Description
Oracle Analytics Cloud available in UK Government region

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in UK Gov South (London) and UK Gov West (Newport).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

July 2020

Update Description
Number of users per month subscriptions New way to set up and size Oracle Analytics Cloud deployments. See What Sizing Options Are Available to You? .
Available in Chuncheon Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in South Korea North (Chuncheon). See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).
Discover important network and security information for Oracle Analytics Cloud instances more easily

A new tab in Oracle Cloud Infrastructure Console displays the host name, IP address and gateway IP address of your Oracle Analytics Cloud instance, plus useful information about the identity provider (Oracle Identity Cloud Service).

See Find the IP Address or Host Name of Your Oracle Analytics Cloud Instance.

Deploy Oracle Analytics Cloud with a private endpoint Restrict access to Oracle Analytics Cloud through a private endpoint. Private access means that traffic doesn't go over the internet. Private access can be from hosts within your virtual cloud network (VCN) or your on-premise network. See Deploy Oracle Analytics Cloud with a Private Endpoint.
Use access control rules to restrict access to Oracle Analytics Cloud with a public endpoint If you deploy Oracle Analytics Cloud with a public internet accessible endpoint, you can restrict access through one or more rules. See Restrict Access to Oracle Analytics Cloud Deployed with a Public Endpoint.

June 2020

Update Description
Available in Hyderabad

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in India South (Hyderabad).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

May 2020

Update Description
Available in Jeddah

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Saudi Arabia West (Jeddah).

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

April 2020

Update Description
Available in Amsterdam, Melbourne, Montreal, and Osaka

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in several more regions:

  • Australia Southeast (Melbourne)
  • Canada Southeast (Montreal)
  • Japan Central (Osaka)
  • Netherlands Northwest (Amsterdam)

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

March 2020

Update Description
Available on Oracle Cloud Infrastructure Gen 2 in London, Frankfurt, and Zurich

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in several more regions:

  • Germany Central (Frankfurt)
  • UK South (London)
  • Switzerland North (Zurich)

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

The way you deploy and manage Oracle Analytics Cloud on Oracle Cloud Infrastructure Gen 2 is different to the current deployment process in London and Frankfurt. If your Oracle Cloud account started before 2nd March 2020 and you currently manage Oracle Analytics Cloud environments in EMEA, this roll-out introduces a new administrative user experience. That is, there is a new way to perform administrative tasks such as create, start, stop, scale, and delete services.

  • Administrators can create and manage their Oracle Analytics Cloud environments using the new administration pages offered with Oracle Cloud Infrastructure Gen 2.

  • Administrators can continue to create and manage their Oracle Analytics Cloud environments using the current administration pages.

For details, see FAQs - Managing Services in North America and EMEA.

February 2020

Update Description
Available on Oracle Cloud Infrastructure Gen 2 in North America (Ashburn, Phoenix, and Toronto)

Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in several more regions:

  • US East (Ashburn)
  • US West (Phoenix)
  • Canada Southeast (Toronto)

See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

The way you deploy and manage Oracle Analytics Cloud on Oracle Cloud Infrastructure Gen 2 is different to the current deployment process in North America. If your Oracle Cloud account started before 14th February 2020 and you currently manage Oracle Analytics Cloud environments in North America, this roll-out introduces a new administrative user experience. That is, there is a new way to perform administrative tasks such as create, start, stop, scale, and delete services.

  • Administrators can create and manage their Oracle Analytics Cloud environments using the new administration pages offered with Oracle Cloud Infrastructure Gen 2.

  • Administrators can continue to create and manage their Oracle Analytics Cloud environments using the current administration pages.

For details, see FAQs - Managing Services in North America and EMEA.

January 2020

Update Description
Oracle Analytics Cloud – Essbase

Statement of Direction

Oracle Analytics Cloud – Essbase Edition is no longer available in Oracle Cloud accounts created after 12th December 2019. Instead, Oracle Essbase is now available on Oracle Cloud Marketplace. See: https://docs.oracle.com/en/database/other-databases/essbase/19.3/index.html

Any Oracle Cloud account created before 12th December 2019 that includes Oracle Analytics Cloud – Essbase Edition, remains unchanged.

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.