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 2023

Exploring, Dashboarding, and Storytelling

Feature Description

Add your own custom table headers

Add your own custom headers for tables and pivot tables. See About Visualization Properties.

Apply conditional formatting to performance tiles

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

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.

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.

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 Align Visualizations Using 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.

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.

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.

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.

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.

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.

Enable or disable saving of the XML data of Publisher report

Deselect the XML for Republishing property of the report if you don't want to save the XML data of report. See Advanced Options.

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.

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.

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.

Go Noto font is the default fallback font for PDF output

Oracle recommends that you test the use of Go Noto font as the fallback font in your analyses, dashboards, and pixel-perfect reports. See About the Classic Administration Page, PDF Output Properties, and Open-Source Fonts to Replace Licensed Monotype Fonts.

In March 2024, open-source fonts will replace the Albany Monotype fonts currently available for analyses, dashboards, and pixel-perfect reports in Oracle Analytics Publisher and Classic. You can use the open-source fonts available in the current release with your existing reports and edit the layouts as appropriate.

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

Keep the Publisher report output private

Disable the Make Output Public option for the report job to keep the job output private. See Advanced Options.

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.

Overlay charts

Use overlays to build multi-layered visuals in several 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.

Parameters enhancements

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.

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.

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.

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.

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

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.

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.
Connect to Google BigQuery Analyze data from Google BigQuery data sources. See Connect to Google BigQuery.
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.

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.

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

Augmented Analytics and Machine Learning

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

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.

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.
Invoke 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.
OCI Vision AI integration in data flows Register OCI Vision AI models in Oracle Analytics 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. See Perform Object Detection, Image Classification, and Text Detection Analysis.

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.

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.

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 Console if required. In earlier updates, the Auto Insights feature was disabled by default. See Tips on Using Auto Insights.

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

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.

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.

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

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.

Documentation Accessibility

Access to Oracle Support