L2022.6 Release Notes

For a list of release dates and Sisense's end of support schedule, see Sisense Life Cycle.

Release Overview

Release L2022.6 provides a number of new features and significant improvements to Sisense for Linux.

Feature Impact Summary

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.

What's New

This release includes the following new features:

• Analytical Engine - Mode, Variance (Population), Variance (Sample) Support
• Analytical Engine - Fiscal Year for Live Models
• Filter Relationship
• Time-level Support
• Disabling Lazy Loading in Blox
• EmbedSDK Generic Event for Navigation
• Dynamic Live Connections
• New Connectors Framework for Google Sheets

Analytical Engine - Mode, Variance (Population), Variance (Sample) Support

The Mode, Variance (Population), and Variance (Sample) statistical functions can be used on live models. This is available with the Analytical Engine Overview that supports Snowflake, Redshift, BigQuery.

Analytical Engine - Fiscal Year for Live Models

You can change the beginning of the fiscal year for the live data model. The fiscal calendar affects how time is calculated on your dashboard. You also receive an indication, for example when filtering your widgets and dashboards by time, via the FY tag.

For further detail, see Changing Your Fiscal Year.

Filter Relationship

• Dashboard designers can create and manage complex analytical cases independently, without the need to create custom columns in the model, by building relationships between the dashboard filters.
• Use the Filter Relationship editor to change the filter relationship statement
• Filter blocks in the Filter Relationship statement provide a textual representation of the currently applied dashboard filter in the editor view.
• See Filter Relationship Editor.

Time-level Support

Dashboard designers can select the date representation of the widget as a Continuous or Aggregated timeline, and can set the date granularity to 1 hour or 15 minutes. For example when you want to analyze hourly income over a week.

For further details, see Date and Time Fields.

Disabling Lazy Loading in Blox

The new disableLazyLoading Blox property enables you to show all of the widget's results simultaneously. This is useful when you need to overcome the 10 column limit of Blox Transpose Pivot, or other similar cases. See BloX Reference.

EmbedSDK Generic Event for Navigation

There is a new event that fires when navigating from one page to another. You can subscribe to it and build additional logic for your application as required.

Example:

    sisenseFrame.app.on(enums.ApplicationEventType.STATECHANGED, (args) => {
    if (args.toState.startsWith('home')) {
    window.location = 'https://example.com/analytics/home';
    }
    });
  

Dynamic Live Connections

The new POST /api/v1/user-parameters/{id}/values end-point was added to update a subset of user parameter values. For the API details, in Sisense, navigate to Admin > REST API > parameters.

New Connectors Framework for Google Sheets

Starting from L2022.6, use of the new connectors framework for Google Sheets is enforced. Use of the old connectors framework may cause build failures.

1. Make sure that you are using new connectors framework: Admin > System Management > Configuration > Manage Connectors > Google Sheets > Toggle ON > Save.
2. At the bottom of the Google Sheets connector configuration, make sure to toggle on useOAuthSettingsFile.value.
3. Navigate to File Management > Connectors > Connectors folder and delete the Google Spreadsheets folder entirely. This folder will be re-created automatically.

What's Improved

• The ability to add custom labels to Sisense pods was added to Installing Sisense using Provisioner and Helm.

What's Fixed

Embedding Sisense

• Sisense.v1.js no longer affects the parent application's styles.
• The default iFrame styles are no longer overwritten after calling the sisenseFrame.hide and sisenseFrame.show EmbedSDK methods.

Live Connector

Dynamic Live Connections:

• The PATCH /api/v1/user-parameters/{user_id} REST API now works, even if the optional 'description' field in the payload is empty.

Video

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