Explore New Features in Oracle Analytics Cloud Release 6.1

June 29, 2021 | 6 minute read
Text Size 100%:

Oracle Analytics Cloud (OAC) introduces a new and modern user experience with the Redwood theme as well as offering a rules engine that enables flexible conditional formatting. You’ll also appreciate the easy on/off toggle for automated joins for multiple-table data sets, and the expanded features for formatting, filtering, sorting, exporting, and printing visualization data.  All these combine to simplify and streamline working with Oracle Analytics, so you spend less time preparing and formatting data and dashboards and more time sharing insights with your organization.


What’s New in Release 6.1

Data modeling and preparation

Turn off automatic join in multiple-table data sets
When you create a data set from a database source, by default, tables are automatically joined when you add them to the Join diagram.  It can be helpful to create joins manually, for example to help improve performance, and now you can easily disable automatic joins in these circumstances.

Watch a video on the Auto Join Tables option

Data Visualizations

Sort by Outside Columns
This option allows you to sort by additional columns not included in the original visualization grammar, in addition to sorting by sequence.  For example, a bar chart report that shows revenue by sales rep may not include tenure, which would allow you to see if seasoned reps were generating more business.  This capability enables you to sort by tenure, offering you greater insight into rep performance.

Watch a video on sorting by outside columns


User experience

Redwood experience
Oracle’s Redwood design system updates the entire user experience, from colors to spacing to interactions and more.  It’s an exciting update that enhances the entire analytic lifecycle, from loading data to dashboard design and presentation delivery. If you love it and want to provide the Redwood experience for all your users, you can switch it over for everyone right now.  With this update you can also move between Redwood and the current look, to help your team become familiar with it before it becomes the default experience in the future.

Watch a video about how to use Redwood, the new face of Oracle Analytics


Conditional Formatting
Use conditional formatting rules to visually pinpoint significant data events in your visualizations to help you to make swift business decisions. You can also create alerts and notifications tied to these data events that trigger business processes to help ensure that important incidents are highlighted and handled appropriately.

Watch a video on conditional formatting


List filter option includes Nulls
By default, nulls aren’t included in list filter results in visualizations. There are times when having nulls included is useful, for example in a time series where there may be no data for a particular month or to show continuity in a bin when one of the values is empty. Now you can select the Null option in list filters to achieve that.

Automatic list filter refresh
This capability helps you navigate long lists in filters. For example, if you have over 1,000 products to filter and you select the first 500, the next 500 possible records automatically display for you to continue with the selection.

Additional project interactivity control for consumers
Sometimes your audience needs to click, drill, and interact with the data to get the most out of the analytics you provide.  Other times, that can create information overload. Report authors now have more control over how people experience and interact with their analytics, including restricting visualization filtering and drill downs.

Watch a video on additional project interactivity control for consumers


Back button support in browser history
In addition to Oracle Analytics Cloud navigation options, the browser Back button will also provide a consistent experience within the interface, enabling easy navigation between tasks such as between editors and the Home page.

Watch a video on page navigation support in the browser history


Consistent export limits for CSV Files
Limits for export to CSV are now standardized across Oracle Analytics Cloud.  For data visualization, this means export limits have increased: to 2 million rows if you have 2 to 12 OCPUs; and to 4 million rows for 16 to 52 OCPUs.

New print control options
New options allow more precise control over printing, so you can size your output to be exactly what you see on the screen, or size it based on resolutions that make the most sense for what you’re printing and where.  This release adds customizable visualization print options for analytic canvases, offering you logical default print sizes, as well as enhanced options for various sources.

Security and governance

AES256 PDF Encryption
Oracle Analytics Publisher enables you to encrypt PDF documents. This enhancement adds a new level of security, “highest” to the available choices, which include low, medium, and high. Selecting “highest” will deliver your PDF via the FIPS 140-2 compliant AES256 (Advanced Encryption Standard) algorithm.


  1. What’s New in Oracle Analytics Cloud 6.1
  2. OAC 6.1 Select Feature Playlist
  3. Oracle Analytics Blog
  4. OAC Tech Talks
  5. OAC Public Roadmap
  6. Submit product ideas at the Oracle Analytics Idea Lab

Suzanne Gill

Previous Post

Analytics in Finance – Where do YOU stand?

Mitch Campbell | 4 min read

Next Post

Oracle Analytics demonstrates value across financial business processes and industries

Jake Krakauer | 5 min read