L2023.1 Release Notes

For a list of release dates and Sisense's end of support schedule, see Sisense Version Release and Support Schedule.

Release Overview

Release L2023.1 provides a number of new features and significant improvements to Sisense for Linux.

What's New

This release contains several new features. The following table lists the high-level impact (or potential impact, if any) of each of these features, and how to handle it if upgrading to this version. Continue reading the Release Notes below the table for a detailed explanation of each feature.

Feature	Issues and Actions to Consider
Creating a Custom Connector	The JDBC drivers used must support at least Java 17 (or higher). You cannot create new connections to old JDBC connectors using Recent connections.
Explanations	N/A
Import Data Model with Assets	N/A
Query ElastiCubes from Notebooks - Beta	N/A
Build Retry	Note the new parameters. Default: No retries.

Creating a Custom Connector

The procedure for creating custom connectors from the Admin tab has changed.

Creating a Custom Connector (also known as a JDBC Connector) to ElastiCube models is now more flexible and customizable for administrators, and much easier to use by data modelers. For further details, see Deploying a Custom Connector.

Administrators can configure a custom connector and set:

• JDBC Drivers - using CDATA or other vendor drivers, (see Connecting to Custom Connectors with JDBC Drivers).

• Look and Feel - how the connector will look when consumed by data modelers in the Data tab.

• Centralized connector definition - the defined connector can be used to create connections in multiple data models. See New Connectors Framework.

Explanations

“Explanations” is part of analyzing your data. Use Explanations to find possible explanations for the biggest contributors of phenomena in your data.

Explanations now:

• Supports insights for indicator widgets. Starting from a measure, Explanations will automatically break by your measure by different fields and return a ranked set of biggest contributors.

• Returns a textual insight on the biggest contributors.

• Has improved error handling.

For more information about Explanations, see Explanations: Identify Reasons for Changes in Your Data.

Import Data Model with Assets

The import data model feature enables you to import a data model together with additional related assets.

This feature is complementary to the L2022.10 "Export Data Model with Assets" feature.

These assets include:

• Data Security (All Data Security rules and emails are encrypted)

• Formulas ("Shared Formulas")

• Hierarchies

For all related assets, the following options are available when overwriting an existing model:

• Overwrite - Erases all related data items from the existing model, then imports the content form the new model.

• Merge New - Merges all related data items from the new model. If there is a conflict, the old model's data items are overwritten from the new model.

• Merge Old - Merges all related data items from the new model. If there is a conflict, the new model's data items are overwritten from the existing model.

• Skip - Keeps the current model's data content.

For more information, see Exporting and Importing Data Models.

Query ElastiCubes from Notebooks - Beta

Contact your CSM to get early access.

This functionality enables Notebook users to use shared connections to connect a Notebook to an ElastiCube and query it using SQL.

For more information see Connecting Notebooks to a Data Source.

Build Retry

A new configuration was added at the Environment level for ElastiCube builds, which enables builds to retry upon failure.

This feature enables customers to automatically retry builds after failures, without manual user involvement.

Parameters:

• NumberOfBuildRetries - The number of automatic retries to be attempted after build failure. By default, NumberOfBuildRetries is 0 (no retries).

• WaitTimeAfterBuildFailedBeforeRetry - The amount of time between attempted builds in seconds. The default value is 60 seconds.

Configuration Parameter Changes

Name	New	Description	Location	Default
NumberOfBuildRetries	Y	The number of automatic retries to be attempted after build failure	Build	0
WaitTimeAfterBuildFailedBeforeRetry	Y	The amount of time between attempted builds	Build	60 seconds

What's Improved

Dashboards

Added a validation to the v0.9/shares/dashboard/{id} and v0.9/dashboard/{id} endpoints in order to prevent errors when loading dashboards (that are shared using these REST APIs) in the navigation pane.

Drill Hierarchies

The ability to rename and change hierarchy fields has been restored, and is available through hierarchy management in the Admin tab, as well as in the Data tab.

Dynamic Connection Strings

The Athena, Custom Connector and Databricks dynamic settings were added. See Managing Live Dynamic Connections.

Filter Relationship

The Filter Relationship editor:

• The Filter Relationship toggle is found in the Feature Management section of the Admin tab and is disabled by default.
• Now, when shared users are given the permission 'Can View' to the dashboard, they will be restricted from changing the filter relationship statement.

For more information, see Filter Relationship Editor.

Pivot Tables

Users can now choose to also include subtotals for single records in pivot tables. This can be helpful when data will be downloaded for additional analysis and a consistent table structure is required.

To use this option, toggle on ‘Show subtotals for single rows’ in the Pivot Table section of the System Configuration page. (Admin tab > Server & Hardware > System Management > Configuration button in top-right corner > System Configuration page.)

For more information, see Pivot Tables.

SisenseJS

SisenseJS now supports language (“lng”) claims received from Web Access Tokens​​:

• When the “lng" claim is included in a token (and has a valid value) it overrides the native application language and the user’s selected language for the assets which are embedded using SisenseJS.

• When the “lng” claim is not included or invalid, then the default language settings will be used.

This update applies to all types of embedding, including Iframe and Embed SDK.

Widgets

• Application libraries were updated to newer versions. This might cause minor UI changes in the TreeMap widget.

• Widget scripts were improved so that error handling no longer prevents them from executing correctly.

• The handling of time offsets was improved when processing dates in the widgets.

• Along with the existing capability to drill-down in the hierarchies, it is now also possible to navigate to the upper levels within the defined hierarchy path.

Analytical Engine Connectors

Microsoft SQL Server Data Connector

The Microsoft SQL Server live connector is now supported by the Analytical Engine by default.

For more information, see Analytical Engine Overview.

Microsoft Azure Synapse Data Connector

The Azure Synapse live connector is now supported by the Analytical Engine by default.

For more information, see Analytical Engine Overview.

What's Fixed

Admin

• The ability to create a number of users via SSO which exceeds the license limit has been removed. You now cannot create more users than the license limit allows.

BloX

• The BloX action "Filters" now works as expected.

EmbedSDK

• The “beforequery” JavaScript widget event now works properly in EmbedSDK.

Filters

• Fixed several issues for the 'Break by' box when filter is applied. Now, the ‘Break by’ section:

  • Resizes appropriately so there is no longer an empty space at the bottom when the number of items in the list is reduced.

  • If there is a scroll bar, it is removed when the number of listed items is reduced and the scroll bar is no longer needed.

  • Will no longer stay empty after items are dragged to it from the category data panel.

• The last day of the month is now displayed correctly for all months in the new filters interface for DateTime filters.

Pivot Tables

• Conditional formatting allows you to change the color according to conditions defined in the Conditional tab. (See Defining Conditional Coloring - Conditional Tab). Now the defined conditions can be dragged up and down in the list without unexpectedly jumping to a different line.

Pulse

• Pulse alerts for Line charts are now created according to the applied filters.

REST APIs

• The GET /api/v1/authentication/logout endpoint correctly returns status 401 and the message 'Missing or invalid token' when invoked without a valid token, (instead of status 403).

Simply Ask (NLQ)

• The ambiguity text for the “contains” filter now states the name of the field.

• The word "per" was matched incorrectly to an indexed field. It is now recognized as a special break-by word.

• The word “average” is now recognized as a mathematical key word.

• Fields names that are made of concatenated words, such as “issueType”, are now recognized as two distinct words and can be matched using synonyms.

• The NLQ model editor under the Simply Ask > Modify NLQ settings no longer scrolls upward when trying to reach the end of the page.

Widgets

• Widgets are no longer getting refreshed unnecessarily when changing a dashboard filter that is disabled on the widget level.

• The SDK widget's event 'widget.unloaded' is now triggered as expected when a widget is being unloaded from an iFrame, such as when navigating to a different widget or transitioning to a different state.

• The 'updatedfromeditor' event is now triggered and executed as expected when the end user clicks on the Apply button in the widget edit mode to save widget changes.

• Area Map widgets embedded via the Embed SDK are now exported to PNG as expected - with all of the content included and displayed.

• The legends for line, bar and column charts now display the category names as expected.

Web Access Token

• The PDF export process no longer fails (by timeout) when it is used in the Web Access Token flow.

Limitations

Admin

• In the new Admin UI, the search functionality searches for pages and sections, but not for specific configurations within each page.

Filters

• In the new filter editors UI, (currently in beta) use of the 'Not Between' Filter on Measure throws an error.

Video

Watch this video for an overview of selected features from this release: