What’s New for Oracle Analytics Cloud

Here’s an overview of new features and enhancements that we’ve added recently to improve your Oracle Analytics Cloud experience.

Topics:

• September 2023
• July 2023
• Earlier Features

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

September 2023

• What's New in September 2023
• Features Desupported in September 2023
• Top User-Assistance Enhancements
• Issues Addressed in September 2023

What's New in September 2023

Exploring, Dashboarding, and Storytelling

Feature	Description
Add descriptions to tile visualizations	Annotate tile visualizations with descriptions to guide workbook consumers. See About Visualization Properties.
Create data actions from tiles	Create data actions directly from tile visualizations in workbooks. See Use Data Actions.
Create data actions from measures on composite tiles	Create data actions directly from measures on composite tile visualizations in workbooks. See Use Data Actions.
Pass parameter values to embedded workbook content	Use the <oracle-dv> embedding tag to pass parameter values to Oracle Analytics content embedded in applications. See Pass Parameters to the HTML Page.
Filter workbooks using a list box	Use the List Box filter type in dashboard or visualization filters to provide a simplified list filter selection experience. See About the Dashboard Filter.
Locate invalid filters	Quickly identify and understand any invalid filters in a workbook. An icon indicating an invalid filter is displayed and you can hover over it to learn why the filter is invalid and how to fix it.
Format dates and times for subject area items	Format dates and times in subject area-based columns and calculations in workbooks. See About Visualization Properties.
Visually demarcate sections with line spacers	Format canvases using line spacers in workbooks. See Filter and Other Visualization Types.
Curate compelling workbooks with Present enhancements	Use Present enhancements to easily curate compelling user workbooks. See What Is a Presentation Flow?
Show details on geometries on maps	Display descriptions or other information (such as metric and attribute values) on top of geometries on map visualizations in workbooks.
Control validation of parameter values in workbooks	Specify whether to validate a parameter's initial and available values when saving the parameter and opening a workbook that uses the parameter. See About Parameter Properties.
Validate SQL statements for parameter values	Validate and find any errors in the SQL statements used to populate a workbook parameter's available and initial values. See About Parameter Properties.
Select a data column for parameter values	Choose a data column to populate a workbook parameter's available values. See About Parameter Properties.
Bind double-column parameters to double-column list filters	Create a double-column parameter and bind it to a double-column list filter in a workbook. See Create and Bind a Parameter to a Double Column Filter.
Use Go Noto as the default font for PDF output	Analyses, dashboards, and pixel-perfect reports now use Go Noto as the default font for PDF output. Oracle recommends that you test the Google Noto font in your reports and dashboards. See About the Classic Administration Page, PDF Output Properties, and Open-Source Fonts to Replace Licensed Monotype Fonts. See also Albany fonts in analyses, dashboards, and pixel-perfect reports in Features Planned for Desupport in Future Updates.
Share workbook links with options including QR code	Share workbooks using links with various options such as QR codes.
Preview: Personalize workbook filters as a consumer	(Enterprise Edition only) Consumers can personalize workbooks by selecting values for dashboard filters, visualization filters, 'Use as filters', and parameters. See Preview Options and Personalize Filter Values (Preview)

Data Connectivity, Modeling, and Preparation

Feature	Description
Configure a usage tracking database in Semantic Modeler	Configure your usage tracking database in Semantic Modeler using a self-service data connection. See Specify the Usage Tracking Database Using Semantic Modeler.
Connect to a usage tracking database using a data connection	Track usage in your Oracle Database or Oracle Autonomous Data Warehouse through a data connection. See Prerequisites For Usage Tracking.
Improve profiling of datasets based on local subject areas	Improve profiling of datasets based on local subject areas with a simple Top N sample. See Data Profiles and Semantic Recommendations.
Preview: Manage connections programmatically	Create, update, and delete a range of data source connections programmatically using REST APIs. For example, you might want to create a script that creates (or modifies) the same set of connections in both your test and production environments. See Manage Connections Using REST APIs (Preview).

Performance, Compliance, and Administration

Feature	Description
Deliver pixel-perfect reports securely using RFC8268 new key exchange methods	Deliver pixel-perfect reports through SFTP using these RFC8268 Diffie-Hellman key exchange methods: diffie-hellman-group14-sha256 diffie-hellman-group16-sha512 diffie-hellman-group18-sha512 See SSH Options for SFTP.
Control form actions in safe domains	Allow or restrict form submissions in safe domains. See Register Safe Domains.
Delete mail server configuration	Clear mail server settings with a single click. See Set Up an Email Server to Deliver Reports.
Sign out inactive users automatically	Automatically sign out users when the inactivity timeout is reached. See Security System Settings - Sign Out Inactive Users Automatically.
Scale between 1 and 8 OCPUs	Scale up non-production environments (1 OCPU) more easily; no need to migrate your content to a production environment. Scale up and down between 1, 2, 4, 6, 8 OCPUs. See Scale a Service.
Preview: Manage system settings programmatically	Manage system settings using REST APIs. For example, you might want to create a script that sets (or modifies) multiple system settings in both your test and production environments. See Manage System Settings Using REST APIs (Preview).

Features Desupported in September 2023

When a feature is desupported, Oracle no longer fixes bugs related to that feature and may remove the code altogether. Support Requests can't be filed for the feature.

Feature	More information
Tile Deprecated	The classic tile (named Tile Deprecated in workbook editor) will still work in existing workbooks, but will no longer be available for new workbooks. To add one or more metrics to a visualization, use Tile instead.

Top User-Assistance Enhancements

New or enhanced content	Audience	More information
Access token generation for REST API and CLI payloads	Administrators Developers	You need an access token to create an Oracle Analytics Cloud instance using the command line interface (CLI) or REST API. First you need to set up a confidential application to generate the required access tokens, and then you specify the tokens in your CLI and REST API payloads. See Generate Access Tokens for the REST API and CLI.
Custom encryption permissions	Administrators	More details about the permissions required to manage custom encryption keys for Oracle Analytics Cloud are available. See Prerequisites for Custom Encryption.
Workaround for request header or cookie too large error	Administrators Users	Users accessing Oracle Analytics Cloud with a vanity URL might report the error "400 Bad Request - Request Header Or Cookie Too Large". See Users accessing the vanity URL report the error "400 Bad Request - Request Header Or Cookie Too Large". How do I resolve this?

Issues Addressed in September 2023

For a list of issues addressed in Oracle Analytics Cloud, see Doc ID 2919336.1.

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

July 2023

What's New in July 2023

Exploring, Dashboarding, and Storytelling

Feature	Description
Bind parameters to list filters	Bind a parameter to a workbook's list filter to pass a selected filter value to the parameter. Binding a parameter to a workbook's list filter enables content authors to dynamically accept, store, and manipulate the parameter’s stored values. See Bind a Parameter to a Filter.
Use data actions to pass parameter values bound to filters to external workbooks	Enhance workbook navigation by passing parameter values bound to a list filter to a data action. See Use an Analytics Link Data Action to Pass Parameter Values.
Create parameters with a single click	Use a single click in a workbook's list filter to create a parameter and bind it to the list filter. See Create and Bind a Parameter to a Filter.
Auto Apply setting for parameters on filter bars	Specify if filter values selected from parameters on the filter bar are automatically applied to the workbook or if users need to manually apply them. See About Automatically Applied Filters.
Provide custom label names and set the selection mode	Specify label names for filters in visualizations in workbooks and set the filter controls for either single or multiple selection. See Customize the Label of Visualization Filters, and Disable Multiple Select for Visualization List Filters.
Create data actions that use the PATCH method	Create HTTP request data actions that use the PATCH method in workbooks. See Create HTTP Data Actions.
Display or hide the visualization toolbar	Show or hide the visualization toolbar in Present for workbook users when curating a dashboard experience. See Specify How Users Can Interact With a Canvas.
Include spark charts in tile visualizations	Configure spark charts in tile visualizations easily using a new grammar panel for workbooks. See Use Spark Charts to Examine Trends.
Go Noto Font available as a fallback	Generate analyses, dashboards, and pixel-perfect reports as a PDF file using the Go Noto font. Configure the Go Noto font as a fallback font to use when the default PDF fonts (such as Helvetica, Times-Roman, and Courier) can’t display non-Western characters included in the data when generating PDF output. Oracle recommends that you test the use of Google Noto fonts as a fallback font in your reports and dashboards. See About the Classic Administration Page, PDF Output Properties, and Open-Source Fonts to Replace Licensed Monotype Fonts. See also Albany fonts in analyses, dashboards, and pixel-perfect reports in Features Planned for Desupport in Future Updates.

Data Connectivity, Modeling, and Preparation

Feature	Description
Connect to an Oracle Analytic Views instance	Use an Oracle Analytic View as a data source for workbooks. See Connect to Oracle Analytic Views.
Connect to Snowflake	Use a Snowflake database as a data source for pixel-perfect reports. See Set Up Connection to a Snowflake Data Warehouse.
Connect to Vertica	Use a Vertica database as a data source for pixel-perfect reports. See Set Up Connection to a Vertica Data Warehouse.
Share data flows and sequences	Share data flows and sequences with other Oracle Analytics users, who can then use them to prepare data for workbooks. Sharing enables you to collaborate on data preparation projects and reuse Oracle Analytics assets and resources. See About Sharing Data Flows and Sequences.
Specify permissions to share semantic models	Assign permissions to allow other developers to access and modify semantic models. See Use Permissions for Collaborative Semantic Model Development.
Enhanced search with synonyms	Make workbook content easier to search from the Home page by specifying synonyms for columns in your datasets. See Make Analytics Content Easier to Search.
Secure delivery of pixel-perfect reports using the RFC8332 RSA keys	Deliver pixel-perfect reports through SFTP using the RFC8332 RSA keys (SHA-256 or SHA-512). See SSH Options for SFTP.
Preview: OAuth2 authentication for connection to REST endpoints	(Enterprise Edition only) Use OAuth2 authentication to connect to data sources with REST endpoints so that you can create analytics content in workbooks. See Create a Connection to a Data Source with REST Endpoints (Preview).

Performance, Compliance, and Administration

Feature	Description
Preview: Workbook Email Scheduler	(Enterprise Edition only) perAs an administrator, share up-to-date visualizations from workbook canvases by scheduling recurring emails for intended recipients containing the visualizations in PDF files or PNG format image files. See Share Visualizations Using Workbook Email Schedules (Preview).

Augmented Analytics and Machine Learning

Feature	Description
Settings Pane available on all tabs in Explain	Use more comprehensive settings in workbooks to control the columns being used in all categories of Explain to fine-tune insights suggested for you (for example, basic facts, key drivers, or segments). See Use Explain to Discover Data Insights.

Issues Addressed in July 2023

For a list of issues addressed in Oracle Analytics Cloud, see Doc ID 2919336.1.

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

Earlier Features

• May 2023
• March 2023
• January 2023
• November 2022
• September 2022
• July 2022
• May 2022
• March 2022
• January 2022 (6.4)
• October 2021 (6.3)
• August 2021 (6.2)
• July 2021 (6.1)
• May 2021 (6.0)
• January 2021 (5.9)
• September 2020 (5.8)
• July 2020 (5.7)

May 2023

What's New in May 2023

Exploring, Dashboarding, and Storytelling

Feature	Description
Conditional (rule based) annotations	Annotate data when it meets specified condition rules. See Add Conditional Formatting to Data.
Copy and paste grammar columns (accessibility)	Copy and paste grammar columns more easily using keyboard shortcuts. See Accessibility Features and Tips for Oracle Analytics Cloud.
Custom labels for tile secondary measures	Add a custom label to a tile visualization's secondary measures. See About Visualization Properties.
Enhanced data action rules	Use data actions to provide filter context values to target workbooks. See Use Data Actions.
Enhanced scatter visualization properties	Create more powerful scatter visualizations using custom color for points, point outline and border, transparency, and connecting related points. See Scatter Graphs.
Maps conditional formatting	Highlight important data events in your map visualizations along with other visualization types. See What Can I Do With Conditional Formatting?.
Parameter enhancements	A parameter no longer requires an initial value, and can use the first possible data value as the initial value. Workbook authors can include a parameter on a tile visualization's secondary measure label. Use a Parameter in a Tile Visualization's Measure Label.
Print all pages in classic dashboards	Print all pages in a dashboard in a single action. See Print Dashboards.

Data Connectivity, Modeling, and Preparation

Feature	Description
Advanced database connection information	Specify the identifier type for database table names and column names, for example, single quotes '', double quotes "", or square brackets []. See Connect to Data With Upper, Lower, or Mixed-case Characters.
Reorder columns in data flows	Reorder columns when you prepare data using a data flow. See What Steps Can I Use to Organize and Integrate My Data?.
Role-based filters	Create filters for datasets based on application roles to ensure that consumers of the datasets in workbooks see only data that's relevant to their roles. See Apply Role-Based Filters.
Semantic Modeler	Semantic Modeler is a browser-based data modeling tool with a modern user interface. It provides a streamlined user experience for creating semantic models (governed data models) and is fully-integrated with Oracle Analytics Cloud. See Get Started with Semantic Modeling.
Transform data using replace	Enhance your data in the transform editor by entering replacement strings for multiple values with a single transform. See Transform Data Using Replace.

Performance, Compliance, and Administration

Feature	Description
Connect to OCI resources using a resource principal	Connect to OCI Language, Data Science, Machine Learning, or Functions using a resource principal as an alternative to an API key. See Create a Connection to Your OCI Tenancy.
Control the user inactivity timeout	Option to customize the length of time that users are inactive before their browser or mobile connection must be re-authenticated. See System Settings - User Inactivity Timeout.
Restrict data export and delivery	Option to limit the maximum number of rows that users can export or deliver by email in formatted and unformatted content. See System Settings - Restrict Data Export and Delivery.

Issues Addressed in May 2023

For a list of issues addressed in Oracle Analytics Cloud, see Doc ID 2919336.1.

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

March 2023

What's New in the March 2023

Exploring, Dashboarding, and Storytelling

Feature	Description
Conditional formatting - rule blending	Blend rule styles. For example, allow one rule to color a cell and another rule to make the cell's font bold. See Add Conditional Formatting to Data.
Parameters for reusable values	Create parameters in a workbook to use like variables to store and manage reusable values. You can use parameters as selectors that allow users to change their view of the data. You can also use parameters as controls, in a visualization's properties, in logical SQL expressions, expression filters, calculations, and in data actions and workbook navigation. See What Are Parameters? and Create a Parameter.
Support for multiple digital signatures	Register multiple digital signatures and choose a digital signature for a PDF report. See Apply a Digital Signature.
Show or hide the filter bar on dashboards	When designing a dashboard in the workbook's Present page, you can chose to show or hide the filter bar in the dashboard. See Show or Hide the Filter Bar on the Dashboard.
Time filter for deliveries	Use "last day" and "last 7 days" filters to quickly see your most recent deliveries. See Track the Reports You Distribute by Email or Through Agents.
Watchlists for easy access to content	Provide targeted links to analytics content from the Home page more easily and effectively. See Create a Watchlist.

Data Connectivity, Modeling, and Preparation

Feature	Description
Connect to MySQL Heatwave	Create analytics content based on MySQL Heatwave databases. See Supported Data Sources.
Connect to Vertica	Create analytics content based on Vertica databases. See Supported Data Sources.

Augmented Analytics and Machine Learning

Feature	Description
AutoML mode in data flows	Let Oracle Analytics create a prediction model for you using the AutoML capability in Oracle Autonomous Data Warehouse. See Train a Predictive Model Using AutoML in Oracle Autonomous Data Warehouse.
Auto Insight type selector	Fine tune your insights by selecting the types of visualization to suggest. See Specify the Visualization Types that Auto Insights Displays.

Issues Addressed in March 2023

For a list of issues addressed in Oracle Analytics Cloud, see Doc ID 2919336.1.

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

January 2023

What's New in the January 2023

Exploring, Dashboarding, and Storytelling

Feature	Description
Assign a map background to map layers	Configure map backgrounds and layers to make it easier for workbook designers to build map visualizations. See Update Custom Map Layers.
Configure the grid spacing between visualizations on the canvas	Configure the spacing of visualizations on the grid on the canvas. Use the Grid Guidelines property when the canvas is in Freeform mode. See About Canvas Grid Guidelines.
Control bubble sizes on maps	Use bubbles to represent dots on a map. Set a minimum and maximum size in pixels for these bubbles, to control how cluttered the map looks depending on its zoom level and the density of the dots. See Apply Multiple Data Layers on a Single Map Visualization.
Control data refresh overlays in visualizations	Control how overlays are shown in visualizations using the Visualization Overlay property of workbooks. See Set Visualization Loading Overlay Opacity.
Display rows and columns of null values in in pivot tables	Control how rows and columns of null values are displayed in pivot tables. This is especially useful when the top member of a hierarchy has a null value in Oracle Fusion Cloud Enterprise Performance Management or Oracle Essbase. See About Visualization Properties.
Improved experience for the Grammar and Property panels	Easily navigate on the Property panel, which is now adjacent to the Grammar panel on all workbooks. You see a message alerting you to the workbook being in authoring mode.
Improved Explain experience and segmentation algorithm	Try the improved user experience and enhanced algorithm supporting the Segmentation tab in Explain. Easily configure input for segmentation and export identified segments to use them directly on canvases. See Use Explain to Discover Data Insights.
Improved Home page	Easily navigate on the redesigned and styled Home page and take advantage of customization options. See Explore Your Content.
Improved tile visualization	Try the improved tile visualization that allows you to add metrics to the tile while providing the layout and positioning of labels and values of the primary and secondary measures. See Filter and Other Visualization Types.
Treemap and horizontal bar chart for Auto Insights	Add variety to your workbooks with the treemap and horizontal bar charts for Auto Insights. See Choose the Best Visualizations for a Dataset Using Auto Insights.

Data Connectivity, Modeling, and Preparation

Feature	Description
Automatically calculate time durations such as year, month, and day	Employ recommendations to automatically calculate time durations by comparing the system date to years, months, and days. See About Data Enrichment and Transformation in Oracle Analytics.
Support for Spark 3.0 connections with Kerberos authentication	Configure connections to Spark 3.0 sources with Kerberos authentication with or without SSL. See Connecting to Data Sources Using Kerberos Authentication.

Augmented Analytics and Machine Learning

Feature	Description
Integrate machine learning models from OCI Data Science	Add machine learning capabilities to your visualizations by consuming OCI Data Science models in your data flows. See Apply an OCI Data Science Model to a Dataset.
Invoke artificial intelligence models from OCI Language	Add artificial intelligence capabilities to your visualizations by consuming OCI Language models in your data flows. See Apply an OCI Language Model to a Dataset.

Performance, Compliance, and Administration

Feature	Description
Email Publisher reports as a URL	Send Publisher reports as URLs. Configure report delivery at the system level or at the report level. See Set Up Delivery Destinations and Advanced Options.
Post-logout redirect	Direct users to a specific web page when they log out from Oracle Analytics Cloud. For example, display a company web page, or display the Oracle Analytics Cloud Classic home page login. See Security Options.
Support for wallet-less connections to Oracle Autonomous Data Warehouse	Connect to an Oracle Autonomous Data Warehouse that allows wallet-less connections. You can use the Delete Wallet option to remove a wallet file that you previously uploaded and no longer need. See Connect to Oracle Autonomous Data Warehouse.

Issues Addressed in January 2023

For a list of issues addressed in Oracle Analytics Cloud, see Doc ID 2919336.1.

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

November 2022

What's New in the November 2022

Exploring, Dashboarding, and Storytelling

Feature	Description
Filter data using a slider	Filter visualizations using a slider dashboard filter. You can visualize how your data changes interactively by selecting a measure value, or by playing through the measure automatically to display an animation. See Overview to Filtering and Animating Visualizations Using a Slider Dashboard Filter.
Control workbook filter interactions from the filter bar	Control how all workbook filters interact from the workbook's filter bar. From the filter bar you can limit all related filters as specified for each filter, or turn off the limit by functionality. See Enable or Disable the Limit By Setting from the Filters Bar.
Customize the appearance of the workbook header bar	Authors can show or hide the header bar, and customize the background and the text. Consumers can view the header bar configured by the author. See Create a Story.
Thumbnails blurred to hide data	Workbook thumbnails displayed on the home page are blurred to hide sensitive content. For additional security, there’s also a global setting for administrators to disable workbook thumbnails altogether. See Security Options – Save Workbook Thumbnails. When thumbnails are allowed, content authors can hide the thumbnail for individual workbooks as required. See Set Workbook Thumbnails.
Preview: Export table visualizations to Microsoft Excel	Export table or pivot table visualizations in Microsoft Excel spreadsheet format. See Export Formatted Data from a Visualization to Excel (Preview).

Data Connectivity, Modeling, and Preparation

Feature	Description
Improved methodology of dataset semantic profiling	Enhancements to the random sampling depth and methodology that drives augmented features such as quality insights and recommendations. See What are Quality Insights?.
Toggle sample data previews in metadata views	Allow users to switch off sample data previews in Metadata view to improve their user experience when previews aren't required. See Configure Columns Properties in a Dataset.
Transform data with Convert to Date recommendations	Transform unrecognized dates more easily using single-click Convert to Date recommendations. See Accept Enrichment Recommendations.
Support for non-SSL, Kerberos connections to Hive	Connect to Hive databases with or without SSL. See Connect to a Hive Database Using Kerberos Authentication.
Preview: Semantic Modeler	Use the Semantic Modeler to create governed semantic models from relational data sources. The Semantic Modeler is a fully-integrated Oracle Analytics Cloud component that you access from the Oracle Analytics Home page. Developers can use the Semantic Modeler user interface or the Semantic Model Markup Language (SMML) to create models. The Semantic Modeler's integration with GIT source control tracks changes to semantic models and enables multiuser model development. See What is the Oracle Analytics Semantic Modeler?. Administrators enable this feature in Console. See Make Preview Features Available.

Augmented Analytics and Machine Learning

Feature	Description
Select columns for Auto Insights	Fine-tune the insights that Oracle Analytics generates for you by selecting which data columns to use for Auto Insights. See Tips on Using Auto Insights.

What's Fixed in the November 2022

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.

September 2022

What's New in the September 2022

Exploring, Dashboarding, and Storytelling

Feature	Description
Add your own custom table headers	Add your own custom headers for tables and pivot tables. See Change Headers in Tables and Pivot Tables.
Create composite card style tile visualizations	Create composite card style tile visualizations to include up to three measures, and define the layout and sizing properties of each measure. See Filter and Other Visualization Types.
Create personalized no-data messages	Create your own message to display when no data is found in a visualization. See Create a Custom Error Message for Visualizations with No Data.
Filter data more easily	Filter your data more easily using a new compact filter bar giving quick access to popular filters such as Top-Bottom N and Exclude or Include. See Filter Data in a Workbook.
Provide personalized tooltips for calculations	Provide additional information for My Calculations by entering a description for a calculation. The description displays in the tooltip of a calculation. See Create Calculated Data Elements in a Workbook.

Data Connectivity, Modeling, and Preparation

Feature	Description
Convert data to AM and PM format more easily	Convert data to AM and PM format more easily in the dataset editor. See Convert Text Columns to Date or Time Columns.
Prepare data more quickly	Prepare your data immediately while Oracle Analytics Cloud profiles the data quality in the background. See About Data Enrichment and Transformation in Oracle Analytics.
Prepare multiple data columns more easily	Prepare multiple data columns at the same time in the dataset editor. See Configure Columns Properties in a Dataset.
Preview: Connect to REST API enabled data sources	Create a dataset with data accessed via the REST endpoint of a SaaS or PaaS application. See Create a Dataset from a Data Source with REST Endpoints (Preview).
Preview: Semantic Modeler	Use the Semantic Modeler to create governed semantic models from relational data sources. The Semantic Modeler is a fully-integrated Oracle Analytics Cloud component that you access from the Oracle Analytics Home page. Developers can use the Semantic Modeler user interface or the Semantic Model Markup Language (SMML) to create models. The Semantic Modeler's integration with GIT source control tracks changes to semantic models and enables multiuser model development. See What is the Oracle Analytics Semantic Modeler?. Administrators enable this feature in Console. See Make Preview Features Available.

Performance, Compliance, and Administration

Feature	Description
Manage snapshots programmatically	Manage your snapshots (BAR files) using REST APIs. For example, you might create a script that takes regular backups (snapshots). See Snapshot REST Endpoints.
Preview: Reload datasets programmatically	Reload data for your datasets and monitor progress using REST APIs. Suitable for datasets based on connections where the data access mode of one or more tables uses automatic caching. See Datasets REST Endpoints.

What's Fixed in the September 2022

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.

July 2022

What's New in the July 2022

Exploring, Dashboarding, and Storytelling

Feature	Description
Overlay charts	Use overlays to build multi-layered visuals in serveral more chart types, such as stacked bar charts with line, area, and category. You can also control the transparency of each layer. See Bar Graphs.
Open workbooks in view mode	Workbooks open in view mode by default. Turn off the Open Workbooks as Viewer setting in the user profile to open workbooks in edit mode. You can use the workbook-level setting to override the default user profile setting. See Configure Workbooks to Open in Edit Mode.
Auto Insights map visualization for latitude and longitude data columns	Auto Insights recognizes latitude and longitude data types in any dataset and automatically renders map visualizations as part of suggested insights. See Choose the Best Visualizations for a Dataset Using Auto Insights.
OCI Vision AI integration in data flows	Register OCI Vision AI models in Oracle Analytics Cloud and execute them directly in data flows using your own set of images. OCI Vision can perform object detection, image classification, and text recognition on your images and return the results directly as datasets in Oracle Analytics Cloud. See Perform Object Detection, Image Classification, and Text Detection Analysis.
Simplified login for mobile devices	Download and install Oracle Analytics mobile apps and simply enter your Oracle Analytics Cloud URL or corresponding vanity URL. Oracle Analytics Cloud is pre-configured for mobile access, so no longer requires a separate configuration step (which was formerly known as Magic URL). See View Content on Mobile Devices.

Data Connectivity, Modeling, and Preparation

Feature

Description

Preview: Semantic Modeler

Use the Semantic Modeler to create governed semantic models from relational data sources. The Semantic Modeler is a fully-integrated Oracle Analytics Cloud component that you access from the Oracle Analytics Home page. Developers can use the Semantic Modeler user interface or the Semantic Model Markup Language (SMML) to create models. The Semantic Modeler's integration with GIT source control tracks changes to semantic models and enables multiuser model development. See What is the Oracle Analytics Semantic Modeler?. Administrators enable this feature in Console. See Make Preview Features Available.

Performance, Compliance, and Administration

Feature	Description
Auto Insights enabled by default	Auto Insights are enabled by default, and administrators can turn them off in Oracle Analytics Cloud Console if required. Previously, the Auto Insights feature was disabled by default. See Tips on Using Auto Insights.

What's Fixed in the July 2022

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.

May 2022

What's New in the May 2022

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. See Create a Dataset from a File Uploaded from Your Computer.
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. See Create a Dataset from a File Uploaded from Dropbox or Google Drive.

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. See Create a Calculation Based on a Cluster or Outlier.
Increased limit size for Auto-Insights datasets (Oracle Database)	By leveraging random sampling techniques, Auto-Insights generates pertinent insights from datasets of any size provided that they're sourced from an Oracle Database. See Choose the Best Visualizations for a Dataset Using Auto Insights.

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. See Track Progress of Catalog Uploads (Unarchive).

What's Fixed in the May 2022

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.

March 2022

What's New in the March 2022

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

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 (6.4)

What's New in the January 2022

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.
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

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 (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 a Subject Area in Fusion Applications Cloud and Create a Dataset from an Analytics in Fusion Applications Cloud.

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 (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 Analytic 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 (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 (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 What Steps Can I Use to Organize and Integrate My Data?.
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 (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 (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: Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2) Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure

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 (5.7)

• What's New in 5.7
• What's Fixed in 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.

Recent Product Updates

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

July 2023

Update	Description
Oracle Analytics Cloud available in Monterrey	Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Monterrey, Mexico. See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

April 2023

Update	Description
Oracle Analytics Cloud available in Serbia	Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Jovanovac. See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

March 2023

Update	Description
Oracle Analytics Cloud available in US Government regions	Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in US Gov East (Ashburn) and US Gov West (Phoenix). See Using Oracle Analytics Cloud on Government Cloud.

January 2023

Update	Description
Usage and diagnostic logging	View and manage usage and diagnostic logs for Oracle Analytics Cloud in the Oracle Cloud Infrastructure Logging Service. See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

December 2022

Update	Description
Available in Chicago	Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Chicago. See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

September 2022

Update	Description
Available in Madrid	Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Spain Central (Madrid). See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).
Control access using networks security group rules	Use network security groups to control incoming traffic (ingress) to private Oracle Analytics Cloud instances and outgoing traffic (egress) to private data sources. See Use Network Security Groups to Control Access.
Connect to a private data source with a SCAN host name	Oracle Analytics Cloud can connect to private Oracle Databases configured with a Single Client Access Name (SCAN). See About Private Data Sources.
Allowlist Oracle Services	Allow Oracle services to access your Oracle Analytics Cloud instance. See Control Incoming Traffic for a Public Endpoint (Ingress).

August 2022

Update	Description
Available in Queretaro	Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in Mexico Central (Queretaro). See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).

June 2022

Update	Description
Available in Paris	Oracle Analytics Cloud rolls out on Oracle Cloud Infrastructure Gen 2 in France Central (Paris). See Administering Oracle Analytics Cloud on Oracle Cloud Infrastructure (Gen 2).
Preview: Oracle Analytics Cloud Connector for Microsoft Power Bl	Connect to Oracle Analytics Cloud from Microsoft Power BI and visualize Oracle Analytics content. See Connect to Oracle Analytics Cloud from Microsoft Power BI Desktop (Preview).

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.

Features Planned for Desupport in Future Updates

Here's an overview of features planned to be desupported in future updates of Oracle Analytics Cloud. When a feature is desupported, Oracle no longer fixes bugs related to that feature and may remove the code altogether. Support Requests can't be filed for the feature.

Feature	Planned Desupport	Alternative Functionality
Albany fonts in analyses, dashboards, and pixel-perfect reports	January 2024 Update	Open-source fonts will replace the Monotype fonts currently available for analyses, dashboards, and pixel-perfect reports. You can use the open-source fonts available in the current release with your existing reports and edit the layouts as appropriate. Instead of Albany fonts, use the Go Noto fonts that are available in the Oracle Analytics Cloud July 2023 Update. See About the Classic Administration Page and What do I need to know about fonts in reports?
BI Composer Wizard	January 2024 Update	Instead of BI Composer Wizard in Classic, use workbooks in Oracle Analytics for an easy-to-use and full-featured authoring experience, with many more capabilities than those offered with Business Intelligence Composer Wizard. Workbook authoring will replace the existing "Accessibility mode" in the analysis editor.
Catalog Manager Graphical User Interface	January 2024 Update	Catalog Manager graphical user interface is provided as part of Oracle Analytics Client Tools. You can use the Catalog Manager in either a graphical user interface or command line to manage objects in the catalog. The Catalog Manager graphical user interface provided as part of Oracle Analytics Client Tools will be desupported. Instead of the Catalog Manager graphical user interface, use the Catalog Manager command line interface to manage objects in the catalog. Some functionality in the current desktop interface will be available through a browser-based user interface.
Dashboard Styles (Fuse, Skyros, SkyrosCloud, blafp, and FusionFX)	January 2024 Update	In Classic, dashboard styles Fuse, Skyros, SkyrosCloud, blafp, and FusionFX won't be supported. You can migrate dashboards to the modern Redwood or Alta styles. By default, dashboards will use Redwood.
Data Modeler	January 2024 Update	Data Modeler won't be available in Oracle Analytics Cloud. Use Semantic Modeler instead of Data Modeler. For data sources that Semantic Modeler doesn’t support, use Model Administration Tool.
Manage Favorites	January 2024 Update	The Manage Favorites option will be removed from the Favorites menu in Classic. You can continue to add and remove favorites, which will be displayed in an unstructured list in the Favorites menu.

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.

---

Title and Copyright Information

Oracle Cloud What’s New for Oracle Analytics Cloud

F75998-22

September 2023

Copyright © 2017, 2023, Oracle and/or its affiliates. 

Primary Author: Pete Brownbridge