v7.x Release Notes

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

In This Document

This document contains release notes for the following Linux versions:

7.4.3

7.4.3.301 - Selected bug fixes and security issues were handled - October 3, 2019

The following issues were fixed:

• Security issues were resolved
• Sisense Narratives is now available
• Selected issues related to plugins were resolved:
  • The metadata plugin did not display the correct widget filter translation after a dashboard was refreshed
  • Crashes related to plugin file manipulation

7.4.3.244 - Selected bug fixes and security issues were handled - September 4, 2019

7.4.3.237 - Selected bug fixes- August 26, 2019

7.4.3.231 - Selected bug fixes- August 19, 2019

7.4.3.215 - Official release of Sisense V7.4.3 - August 4, 2019

New Features and Enhancements

• For Live data models, Administrators can enable/disable creating relationships between tables. Support for relationships in Live models was added for Oracle, MySQL and PostgreSQL databases (Creating Relationships between Live Tables)
• PostgreSQL users can now connect to specific databases in PostgreSQL (Connecting to PostgreSQL)
• Administrators can define account lockout thresholds for their users including the number of failed attempts and how long users are locked out for (Account Lockout Thresholds)
• Dashboard responsiveness was significantly improved when navigating between dashboards
• New informative tooltips for ElastiCube and Live tiles in the Data page
• The “return to” parameter for SSO via JWT is now configurable in the Configuration Manager
• Sisense installation now prevents installations on servers with less than 8GB RAM

More Supported Deployment Options

Version 7.4.3 is certified for the following deployment options:

(*) The following OS versions are certified:

• Ubuntu 18.04 LTS
• RHEL 7.x
• CentOS 7
• Amazon Linux 2.0

Expanded Support for Add-ons

All certified add-ons are now supported except for the following:

• Histogram Widget
• Embed Images
• K-Means Clustering

The following add-ons may work, but are not fully functional:

• Dynamic ElastiCube
• Filtered Measures

Every version upgrade will update all certified add-ons to the version compatible with the release.

Pivot Enhancements:

The Pivot widget now supports export to PDF. The first 1000 rows of the pivot are exported. To export the full pivot result set, use the Export to Excel feature

Connectors

The following additional connectors are now supported on Linux:

• Google Ads
• MemSQL

Other

• Usage Analytics is now supported on Linux
• You can now import and export ElastiCubes and Live data models only to a local machine or to the Sisense server

Selected Bug Fixes

• Some security issues were resolved
• Emails from systems configured to use SSL will be generated correctly
• The password recovery feature now works correctly when SSL is configured
• Unsupported functions for Live data sources were removed including, running sum, running average, and rank functions
• Add-ons:
  • When the Dynamic ElastiCube add-on was enabled, other add-ons didn’t operate correctly
  • When the Accordion and Aggregated add-ons were enabled, dashboards didn’t return results
  • The JAQLine add-on displayed a blank window
• Accumulative builds on Snowflake didn’t always work correctly
• The “Add Build Alert” action added alerts to ElastiCubes that were not selected
• Data Security:
  • Defining data security over REST API is now supported
  • Data security attributes are now applied without delay
• The Pulse page is now translated to Italian as expected

Limitations

Widgets

• Linux supports the latest version of the Pivot widget, replacing the previous Pivot widget available on Windows. All existing widgets using the Windows Pivot widget are migrated automatically to the new Pivot widget.
• The following features are not yet supported on Linux Pivot widgets:
  • Add-ons on pivots (front-end add-ons)
  • Sisense Narratives
  • Changing the “First day of week” doesn’t affect all the weeks in a pivot table
• The Scatter Map widget isn’t fully functional Linux
• Pie and Scatter charts do not highlight filtered slices

ElastiCubes

• ElastiCubes imported from Windows must be fully built on Linux after importing them. Afterwards, you can perform accumulative builds

Connectors

• Excels with static ranges cannot be built
• In PostgreSQL, CSV, and MySQL, you need to import time fields as text, and then convert them to a time field
• When importing an ElastiCube that was exported from Windows, the file paths are not automatically converted to Linux paths ("/opt/storage/sisense/..."). You need to change the connectivity settings for each table to a valid CSV file
• Sisense Live is supported on MySQL, excluding MySQL 8.0
• Accumulative build by date using SalesForce connector fails
• Google Ads and Google Analytics connectors’ table customizations are not supported

Admin Page

• Data Designers cannot see their own Live models in the Admin page.
• Session inactivity timeout always uses the system global parameter and doesn’t enforce separate Admin inactivity configuration values

Data Security

• Following importing an ElastiCube, you must open the ElastiCube on the data page at least once, before you can add row-based data security rules

Add-ons

• The Jump to Dashboard add-on functions on Linux, but once you associate the add-on with a dashboard, you cannot edit it. You need to delete it and redefine it

Other

• Sisense Narratives is not supported on this version
• Pre/post build add-ons (This is planned for a future release)
• After upgrading from Sisense Linux beta, you need to restart the management service using the CLI command:
  kubectl -n sisense delete pods $(kubectl -n sisense get pods | grep management | awk '{print $1}')

7.4.1

7.4.1.571 - Selected bug fixes - July 11, 2019

7.4.1.564 - Selected bug fixes and security hardening - June 25, 2019

7.4.1.561 - Selected bug fixes - June 19, 2019

7.4.1.555 - Official release of Sisense V7.4.1 - June 11, 2019

Announcing Breaking Changes

• The ElastiCube Set concept is not supported on Linux, and therefore the API /elasticubes/sets is not supported. The “Data Group” entity can be used for ElastiCube resource management.

New Features and Enhancements

• Dashboard responsiveness was significantly improved when navigating between dashboards
• Google BigQuery connector supports worldwide query location for improved performance
• New informative tooltips for ElastiCube and Live tiles in the Data page
• The “return to” parameter for SSO via JWT is now configurable in the Configuration Manager
• Scheduled reports are sent even if some of the widgets are not loaded in the dashboard (Sending Dashboards as Email Reports)
• Find functions quickly in the Formula Editor by name or syntax (Working with Functions)
• Non-Admin Redshift users can now connect to specific databases in Redshift (Connecting to Redshift)
• Performance improvements for Live models on top and bottom ranking filters. This is relevant for all databases and MySQL from v5.8 and above

Exclusionary Data Security

• You can exclude certain rows of data through your row-based security definitions. This feature is available through the REST API only (Data Security)

New and Improved Connectors

• MemSQL: Import data into Sisense or connect directly with a live connection (Connecting to SingleStore)
• Google BigQuery: The Google BigQuery connector is now fully available with unique capabilities for supporting nested columns and partitions (Connecting to Google BigQuery)
• Generic JDBC: The JDBC connector now supports accumulative builds
• Time resolution is supported for Live models

Supported Connectors
The following data source is now supported in this Linux release:

• Google Analytics

Deprecated Features

• The PSM.exe functionality has been replaced by the REST API
• The desktop ElastiCube Manager has been replaced by the Data page available in the Sisense web application

Limitations

ElastiCubes

• ElastiCubes imported from Windows must be fully built on Linux after importing them. Afterward, you can perform accumulative builds
• You cannot import ElastiCubes over REST API

Widgets

• Linux supports the new Pivot widget, replacing the previous Pivot widget available on Windows. All existing widgets using the Windows Pivot widget are migrated automatically to the new Pivot widget.
  The following features are not yet supported on Linux Pivot widgets:
  • Add-ons on pivots (front-end add-ons)
  • Sisense Narratives
  • Export to PDF (Export to excel and CSV is supported)
• The Scatter Map widget isn’t supported on Linux

Connectors

• Excels with static range cannot be built
• In Postgres, CSV, and MySQL, you need to import time fields as text, and then convert to a time field
• When importing an ElastiCube that was exported from Windows, the file paths are not automatically converted to linux paths ("/opt/storage/sisense/..."). You need to change the connectivity settings for each table to a valid CSV file
• Sisense Live is supported on MySQL, excluding MySQL 8.0

Data Security

• Defining data security over REST API is not supported
• Data security attributes are applied only after a 5 minute delay
• Data security values are not populated correctly for a live connection with direct query toggled off

Add-ons

• All of the certified add-ons are supported on Linux, except for the following add-ons which are not yet supported on the Linux release:
  • Sisense BloX
  • Insight Miner
  • Embed Images
  • Histogram
  • JAQLine
• The Jump to Dashboard add-on functions on Linux, but once you associate the add-on with a dashboard, you cannot edit it. You need to delete it and redefine it

Other

• Usage Analytics is not currently supported for Linux (planned to be introduced in a future release)
• After upgrading from Sisense Linux beta, you need to restart the management service using the CLI command: kubectl -n sisense delete pods $(kubectl -n sisense get pods | grep management | awk '{print $1}')

7.3.1

7.3.1.632 - Initial release of Sisense Linux V7.3 - March 31, 2019

New Features and Enhancements

• Monitor your Sisense Linux deployment with Promoetheus, Grafna, and FluentD bundled with Sisense

Supported Connectors

The following data sources are supported by the Linux release:

• MySQL
• SQL Server
• PostgreSQL
• Redshift
• Oracle
• Google BigQuery
• Snowflake
• Generic JDBC (ElastiCube models only, no live models)
• CSV (ElastiCube models only, no live models)
• Excel (ElastiCube models only, no live models)
• SalesForce (ElastiCube models only, no live models)
• Google Sheets (ElastiCube models only, no live models)

Limitations

ElastiCubes

• ElastiCubes imported from Windows must be fully built on Linux after importing them. Afterward, you can perform accumulative builds
• You cannot import ElastiCubes over REST API

Widgets

• Linux supports the new Pivot widget, replacing the previous Pivot widget available on Windows. All existing widgets using the Windows Pivot widget are migrated automatically to the new Pivot widget.
  The following features are not yet supported on Linux Pivot widgets:
  • Add-ons on pivots (front-end add-ons)
  • Sisense Narratives
  • Export to PDF (Export to excel and CSV is supported)
• The Scatter Map widget isn’t supported on Linux

Connectors

• Excels with static range cannot be built
• In Postgres, CSV, and MySQL, you need to import time fields as text, and then convert to a time field
• When importing an ElastiCube that was exported from Windows, the file paths are not automatically converted to linux paths ("/opt/storage/sisense/..."). You need to change the connectivity settings for each table to a valid CSV file
• Sisense Live is supported on MySQL, excluding MySQL 8.0

Data Security

• Defining data security over REST API is not supported
• Data security attributes are applied only after a 5 minute delay
• Data security values are not populated correctly for a live connection with direct query toggled off

Add-ons

• All of the certified add-ons are supported on Linux, except for the following add-ons which are not yet supported on the Linux release:
  • Sisense BloX
  • Insight Miner
  • Embed Images
  • Histogram
  • JAQLine
• The Jump to Dashboard add-on functions on Linux, but once you associate the add-on with a dashboard, you cannot edit it. You need to delete it and redefine it

Other

• Usage Analytics is not currently supported for Linux (planned to be introduced in a future release)
• After upgrading from Sisense Linux beta, you need to restart the management service using the CLI command: kubectl -n sisense delete pods $(kubectl -n sisense get pods | grep management | awk '{print $1}')

Pre/post build add-ons (planned to be introduced in a future release)