What’s New for Oracle Analytics Server

Here’s an overview of new features and enhancements added recently to improve your Oracle Analytics Server experience.

What's New in Oracle Analytics Server 2022 (6.4)

Data Connectivity, Modeling, and 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.

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

Connect to Microsoft Azure Synapse Visualize data from Microsoft Azure Synapse data sources. See Supported Data Sources.

Connect to Oracle Transactional Business Intelligence 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.

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.

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.

Datasets 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 Datasets Containing Multiple Tables and Create a Dataset from a Connection.

Frequent Item Set function supports association rules

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

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.

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.

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.

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 Dataset Reload and View a Dataset Reload Schedule's Details.

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 Data Model from Analytics Views in Oracle Autonomous Data Warehouse (setup), Connect to Analytic Views (visualize).

Exploring, Dashboarding, and Storytelling

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.

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.

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.

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.

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.

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.

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.

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.

Enhanced map visualizations with Mapbox libraries Access smooth and powerful interactions with map visualizations through client-side libraries from Mapbox GL and WebGL.

Export individual visualizations

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

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.

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.

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.

Inner radius of a donut chart

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

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.

My Calculations Properties

Custom calculations in workbooks show similar properties to other measures.

Null values in list filters

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

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 filter types

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

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.

Position tables and pivot tables

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

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.

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.

Refresh profile results and recommendations

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

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.

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.

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

Time series forecasting

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

Tooltips on visualization titles

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

Augmented Analytics and Machine Learning

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

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.

Support for 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 Dataset.

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

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.

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.

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.
System setting enhancements New system settings 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 Other Options.

User and role management enhancements

There's a new 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.

Deployment on Oracle Cloud

Feature Description
Oracle Analytics Server 2022 available on Oracle Cloud Marketplace

Use Oracle Cloud Marketplace to quickly deploy Oracle Analytics Server 2022 on Oracle Cloud Infrastructure.

When you deploy Oracle Analytics Server on Oracle Cloud Infrastructure using Oracle Cloud Marketplace, Oracle Analytics Server provides the same functionality, scalability, security, and support as in on-premise. See Deploy Oracle Analytics Server on Oracle Cloud.

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.