Release Notes 2022.10.0

Release Highlights

In this 2022.10.0 cloud release, Incorta is introducing multiple new features and enhancements that aim to have a great impact on your business and improve your user experience.

Incorta is introducing Blackline as a new data destination along with a new data application "Blackline Reconciliation for Oracle E-Business Suite (EBS)". The new BlackLine data application enables business users to quickly resolve reconciliation issues.

In addition, this release has a new password reset policy for Incorta authenticated users, which enables you to manage password resets for one or all users in your Incorta cluster.

This release also enhances the user experience in different areas, such as uploading data files while adding a new data source and the usage of the between filter for dates in dashboards.

Note

The 2022.10.0 release is available for newly created clusters and new trial users. For already existing customers upgrading from a prior release, please contact Incorta Support to schedule the upgrade.

Important

This release uses the Data Agent version 5.1.0. If you have not already, make sure to upgrade to the data agent version available on the Cloud Admin Portal.

Warning

The default password policy has changed starting 2022.10.0. The default policy will be applied only to newly created passwords, whether for new users creating their first passwords or existing users changing their passwords. However, this will not require existing users to change their passwords. The new password policy mandates the following:

The password length must be between 12 and 32 alphanumeric characters.
A password must contain at least one uppercase letter, one lowercase letter, one special character, and one digit.
A password cannot include the user login name or email address.

New Features

Want More Details...

Refer to What's New in Incorta Cloud 2022.10.0 for more details and examples.

BlackLine data destination and data application

Oracle E-Business Suite (EBS) data application for Account Reconciliation now supports BlackLine as a data destination. The data application integrates Oracle EBS with BlackLine including packaged data templates for BlackLine Account Reconciliations. You can push the data in the pre-built templates to a BlackLine data destination via a secure FTP site. You can schedule more frequent data transfers to support month-end close activities and access detailed transaction data, which enables business users to quickly resolve reconciliation issues.

Refer to Concepts → Data Destination, for instructions on configuring BlackLine as a data destination. And for more information about the BlackLine data application, refer to Data Applications → BlackLine.

Enhancing file upload connector

Incorta has improved the upload file and folder connector. The new enhanced connectors are more informative throughout the entire work flow. Also, you can now upload a folder or multiple files seamlessly. The Local Data Files tab now shows the files/folders uploaded ordered with the last modified files/folders on top.

Dashboard delivery support for bookmarks

You can now create scheduled jobs to deliver a dashboard as PDF or HTML to export folders or via email while applying a selected bookmark. You can also select to reveal the bookmark name and the values of the applied filters.

For more information, refer to Guides → Analyze → Manage Dashboard Bookmarks.

Enhanced Between filter for dates

Now you can filter your insights in a dashboard using the between operator based on dates. Incorta now enables you to use System Variables to specify a date range by typing in the dollar sign $ in the search field.

Important

You must enter the dollar sign $ so you can list the available system variables.

The tooltip tray introduced in the Incorta Cloud 2022.8.0 release is now supported in bubble visualizations. You can drag and drop any column type either measure or dimension to the tooltip tray.

Note

Incorta treats all column types added to the tooltip tray as measures.

Query methods added to Notebook

The Incorta Notebook now gives data engineers and data scientists the ability to author SQL and PostreSQL queries directly inside the Notebook. Previously, users were required to read an entire table into Notebook and write additional code to parse the extracted data.

For more information, refer to Concepts → Materialized view.

Password reset policy for Incorta authenticated users

This release introduces two ways to enforce a password reset policy for Incorta native authenticated active users:

As a User Manager or a Super User, you can use the resetPasswords public API endpoint to instantly reset the password of all Incorta authenticated users. For more information, refer to Public API → Reset Passwords Endpoint.
As the Cloud Admin user, you can enable password expiration so that each Incorta authenticated active user will have to change the password at a scheduled cadence. For more information, refer to Guides → Configure Tenants → Incorta Authentication.

Advanced session cookies security options

As a Cloud Admin, you can now use the Cluster Management Console (CMC) to secure your session cookies by setting the SameSite attribute to restrict sending cookies to a first-party (same-site) context only and prevent the browser from sending cookies along with cross-site requests. You can also specify the Secure attribute to allow sending cookies to the server only when a request is made using an HTTPS scheme.

For more information, refer to Guides → Configure Server → Security.

Additional enhancements and fixes

In addition to the new features and major enhancements mentioned above, this release introduces some additional enhancements and fixes that help to make Incorta more stable, engaging, and reliable.

Issue resolved	Area
Insight panel could not be dragged to expand or reduce in size.	Analyzer
Cascaded filters were not applied if a prompt field was sorted using another column.	Analyzer
max() and min() functions in some cases incorrectly converted data types.	Analyzer
Business schema formula columns did not display in a view after upgrade.	Business Schemas
When creating a cloud cluster back up, the back up creation would not complete and remain in progress.	Cluster Management Console
Incorrect Zookeeper URL was displayed in the cluster details.	Cluster Management Console
Tables based on Google Sheets could fail to load.	Connectors
Custom CDATA connector failure when using Data Agent with data sources.	Connectors
Google Drive, Box, and Dropbox authentication tokens periodically expired.	Connectors
Fusion Connector could freeze during extraction.	Connectors
Sorting groups on a dashboard could cause an error.	Dashboards
Duplicate formulas in a dimension column could result in a thread lock when rendering a dashboard.	Dashboards
Insights with a non-alphanumeric schema source name could not be edited.	Dashboards
Columns in an insight could not have width adjusted when the dynamic layout was enabled.	Dashboards
A dashboard title containing special characters displayed incorrectly in an email.	Dashboards
Insight render failure after dynamic measures were removed.	Dashboards
Interruption in loading insights could cause insights to not render on a dashboard.	Dashboards
Emailed dashboards were not displayed correctly in Outlook 2016.	Dashboards
Tables with incremental load and incremental queries still required a full load to update.	Physical Schemas
Scheduler indicated that a schema load occurred twice when only one was requested.	Physical Schemas
User’s authentication type was not successfully updated when performing authentication changes.	Miscellaneous