What’s New for Oracle Analytics Desktop
Here’s an overview of the new features and enhancements we’ve added recently to improve your Oracle Analytics Desktop experience. It's organized by the update in which a specific feature or capability became available.
March 2022 Update (6.5)
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. |
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. |
Earlier Updates
January 2022 Update (6.4)
Exploring, Dashboarding, and Storytelling
Feature | Description |
---|---|
Redwood Design |
Oracle Analytics fully adopts the new Oracle Design Concepts code-named Redwood. Product look and feel, as well as default colors and fonts will follow the Redwood guidelines created over years of research with close attention to usability and accessibility. |
My Calculations Properties |
Custom calculations in workbooks show similar properties to other measures. |
Consumer Mode Navigation: Bottom Tabs |
Authors have a new Bottom Tabs presentation style for curating the consumer navigation experience. Authors can select this style from the Presentation property panel. See Capture Insights. |
Change Settings for Multiple Columns |
Save time when changing settings for multiple columns. Multi-select columns in the Metadata view to change the Data Type, the Treat As setting, the aggregation type, and the hide setting for more than one column at once. See Configure Columns Properties in a Dataset. |
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. |
October 2021 (Release 6.3)
Feature | Description |
---|---|
Oracle Transactional Business Intelligence and remote Oracle Analytics Server and Oracle Business Intelligence Enterprise Edition sources for datasets with multiple tables |
Use the Oracle Applications connection to add tables from Oracle Transactional Business Intelligence and remote Oracle Analytics Server and Oracle Business Intelligence Enterprise Edition subject areas and reports to datasets containing multiple tables. See Create a Dataset from an Oracle Application's Subject Area and Create a Dataset from an Oracle Application's Analysis. |
Position tables and pivot tables |
Format visualizations more easily with enhanced positioning of tables and pivot tables. |
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. |
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. |
August 2021 (Release 6.2)
Feature | Description |
---|---|
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. |
Refresh profile results and recommendations | Refresh profile results and enrichment recommendations after you add or update custom knowledge. See Accept Enrichment Recommendations. |
Annotations on canvases | In Visualize, 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. |
July 2021 (Release 6.1)
Feature | Description |
---|---|
Enable Oracle’s Redwood experience |
Use the preview dialog to enable Oracle’s Redwood theme in Oracle Analytics before it becomes the default look and feel. |
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 |
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. |
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 presentation mode interactivity for stories |
When defining a story in Narrate, you can use the context menu to turn on and off the user interactivity options for the story in presentation mode. 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. |
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. |
May 2021 (Release 6.0)
Feature | Description |
---|---|
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. |
On-canvas filter types |
Select various on-canvas filter types such as Top Bottom N and Relative Time. See Create On-Canvas Filters and Apply Different Filter Types. |
On-canvas date filters |
Use the on-canvas date selector and the relative time filter for date filters. See Create On-Canvas Filters and Apply Different Filter Types. |
On-canvas measure filters |
Use the on-canvas measure selector and the top and bottom time filter for measures. See Create On-Canvas Filters and Apply Different Filter Types. |
Tooltips on visualization titles |
Enter your own tooltip text to display when you hover over a visualization title. See Visualize Properties. |
Improved sort options |
Use the Sort dialog to configure sorts and clearly see the sort order and any sort conflicts. See Sort and Select Data in Visualization Canvases. |
Time series forecasting |
Perform time series analysis forecasting directly from data flows. See Add a Time Series Forecast to a Data Flow. |
Graph analytics |
Enhance your geospatial visualizations using powerful spatial analytics functions. 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. |
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. |
Connect to Google BigQuery |
Analyze data from Google BigQuery data sources. See Connect to Google BigQuery. |
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 Create a Dataset from a Connection. |
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 Dataset. |
January 2021 (Release 5.9)
Feature | Description |
---|---|
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, Oracle Analytics Publisher Reports, and in Embedded Content. |
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. |
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. |
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. |
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. |
September 2020 (Release 5.8)
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. |
Enrichments for live datasets |
You can leverage enrichments for live datasets along with cached or file-based datasets. See About Data Preparation. |
July 2020 (Release 5.7)
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 Desktop | In Oracle Analytics Desktop, 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 Datasets. |
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. |
May 2020 (Release 5.6)
Feature | Description |
---|---|
Connect to Microsoft Azure SQL Database | Visualize data from Microsoft Azure SQL Database. See Supported Data Sources. |
Create digitized custom map layers | Easily create custom interactive visualizations from any image. Upload images and create map layers that support defining areas on the images with no-code polygon definitions bound to data interactively. See Use an Image as a Map Background and Draw Map Layer Shapes on the Image. |
Create data actions to Publisher reports | Create data actions to easily navigate to a Publisher report. See Create Data Actions to Connect to Publisher Reports. |
Enhanced color in Waterfall visualizations | Assign custom colors for increase and decrease values in a waterfall visualization. |
Copy calculation expressions to the Clipboard | Access a simple menu option to copy an entire expression to the Clipboard without opening the formula editor. |
Create calculations more quickly | Quickly copy and duplicate custom calculations to create derivatives of calculations, to make backup copies, and to test syntax scenarios quickly. |
Improved usability of the Canvas | As you create a project, you have many different tabs of analyses. Explore the improved content density of canvas names for better visibility and quick duplication of a canvas for iterative report creation and testing. As you duplicate or copy canvas tabs, new canvasses are added next to the original and not at the end of the list for ease of accessibility. |
Enhanced map rendering and ability to disable gestures | The performance of map rendering is enhanced including data truncation warnings when using large datasets. You can lock the display of a map and disable interactive gestures for a better experience. |
Flexible and persistent cell sizing in tables and pivot tables | Enhance the clarity of tables and pivot tables. You can control the size of columns and rows for specific data points that need more attention or more room for visibility. |
January 2020 (Release 5.5)
Feature | Description |
---|---|
Butterfly visualization | You can select the Butterfly visualization to present two sets of data series side by side and organized by a specific metric. |
Spacer visualization | You can add spacers to the canvas to provide filler space between visualizations. |
Assign a map layer to a column | You can use the Location Details option to assign a map layer to a column. See Assign a Map Layer to a Data Column. |
Auto focus in map layers | When you've added filters to your map visualization, you can use the Auto Focus on Data option to automatically focus on a particular map area. See Auto Focus on Data for a Map Visualization. |
Enhance grand totals in pivot tables and tables | For pivot tables and tables, use the Property tab to control the formats and positions of grand totals and subtotals. |
Canvas and project background configuration | You can add background colors and images to canvases and projects. |
Hierarchical coloring | You can select the Hierarchical Coloring option to ensure consistent coloring for each metric's attribute values. |
Reference line in Explain | In Explain's Key Drivers results for attribute columns, a constant reference line is displayed in 100% stacked charts. See Analyze Data with Explain. |
Oracle NetSuite Connection Type | Visualize data from Oracle NetSuite data sources. |
Oracle Database Advanced Connection Options | Connect to an Oracle Database configured on multiple clusters using a Single Client Access Name (SCAN) ID. In the Create Connection dialog, you select Advanced to configure the Single Client Access Name (SCAN) ID. See About Specifying Connections to Databases. |
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle Analytics What's New for Oracle Analytics Desktop
E76890-28
March 2022
Copyright © 2016, 2022, Oracle and/or its affiliates.