v8.x Release Notes
  • 21 Aug 2022
  • 46 Minutes to read
  • Dark
    Light

v8.x Release Notes

  • Dark
    Light

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:

8.2.6

L8.2.6.SP4.34 - Service Pack - January 10, 2021

Announcing Breaking Changes

  • Exported files with names containing unicode characters will not include these characters and will instead show a "-" in the file name
  • Sisense implemented a new log server. You can no longer ship your logs to your private Logz.io account from Sisense

Selected Bug Fixes

  • When viewing the date a Pulse alert was created, “Invalid date” was displayed instead
  • Pulse alerts redirected users to dashboards instead of the Pulse alert when they were not logged in
  • You could not cancel Live queries when adding or removing filters from the Widget Editor

L8.2.6.SP3.31 - Service Pack - December 30, 2020

Announcing Breaking Changes

  • This service pack introduces Helm 3 and requires that you have Kubernetes version 1.17. Sisense Helm 2 charts will be upgraded to Helm 3. As part of this requirement, you cannot upgrade until Kubernetes version 1.17 is installed.

    You can check your version of Kubernetes with the command:

    kubectl version
    

    Upgrading to this service pack requires a few additional steps, for more information, click here.

    Important:

    This procedure might cause downtime of an hour or more. Sisense recommends you install this service pack side-by-side with your production version and switch your DNS IP after validating that the upgrade was successful.

  • Dashboard Time Frame filtering by Hours was removed from the filter options and any filters that uses the Hours option must be removed or updated to one of the supported time frame options (Years, Quarters, Months, or Weeks)

New Features and Enhancements

  • Improved security features for dashboards and font support
  • The Sisense translator now supports formulas used for row-level aggregation such as sum(quantity*price) and the aggregation can be over inputs from different tables.
  • Relationships between tables in Live models for Azure Synapse are now supported by default

Selected Bug Fixes

  • It is not possible to add a USER and include it into GROUPs via one API call
  • Columns are exposed despite the API command to hide a table
  • The jobs service crashes because the jobs collection queue were never cleared
  • The endpoint /api/v1/elasticubes/cubeShares fails to accept the Elasticube ID
  • The Jump to Dashboard add-on creates from performance, dashboard, and widget issues
  • The dashboard list does not load in certain cases due to a memory issue
  • When a session timeout occurs, the redirection URL is wrong for the embedded dashboards

8.2.6.582 - Service Pack - December 22, 2020

Announcing Breaking Changes

  • The Limit Auto-Complete add-on no longer displays the "Everyone" group when sharing a dashboard
  • When using a Column chart with a break by, Sisense only displays the top 50 categories. Relative percentages will not be calculated for each slice as it only represents the percentage of the visible slices. Sisense recommends you reduce the number of categories to break on to less than 50

New Features and Enhancements

  • You can ship event logs to your ElasticSearch engine (Read More)
  • Improved the rendering and performance for Pivot tables

Selected Bug Fixes

  • You could not open dashboard in a new tab from the navigation pane
  • Columns in Pivot tables were not displayed as expected after migrating from Windows to Linux
  • In some scenarios, PastX functions, for example Past Year, did not return the expected results
  • Live queries could not be cancelled after leaving the Analytics page to other pages in Sisense
  • Grand Totals values in Pivot tables were not the same when exported to Excel

8.2.6.503 - Service Pack - December 9, 2020

Improvements

  • Usage Analytics now records how many widgets were successfully loaded in a dashboard
  • Support added for Helm 3 CLI tool
  • Centrale Sans font was added as a predefined font when customizing Sisense
  • Users can configure Sisense to forward events to any destination (Read More)
  • The pre/post-build plugins directory is now displayed in the File Manager so you can easily deplo add-ons

Selected Bug Fixes

  • The total number of Viewers was incorrectly calculated after changing a dashboard’s owner
  • When using the MSSQL connector, N/A values were displayed in date-time columns
  • When converting text columns to date-time columns, builds took longer than expected
  • Security issues were resolved
  • Temp tables in the Sisense BigQuery connector with no expiration date were created in the same dataset as the data tables (see Connecting to Google BigQuery)
  • CSRF protection caused an error when the Session Management > Session Inactivity option was selected
  • The Analytical Engine service restarted unnecessarily
  • Table relationships were lost when editing a custom table query in a Live model
  • In some scenarios, you could not scroll through the dashboard filter after opening the Edit menu
  • A custom field with the “_key” suffix could not use the same characters as another custom field
  • In some scenarios, builds with data from Google BigQuery timed out before completion
  • No results were displayed for Pie Charts when “Show x slices” and “Others'' was enabled
  • The “Go to Last Page” arrow was hidden in tables when the Table With Aggregation add-on was applied
  • Connector Fixes
    • Unable to connect to a PostgreSQL database if the password included the '%' character
    • An ElastiCube with data from PostgreSQL failed to build after upgrading Sisense
    • Google sheet names that contained an apostrophe caused a connector error
    • A preview of tables failed for the default query generated by the generic JDBC driver
  • Pivot Table Fixes
    • Exporting a dashboard failed when a dashboard included a Pivot Table with no results
    • Safari and Chrome browsers on Apple Mac computers did not display Pivot2 widget correctly
    • Disabled columns in a Pivot Table negatively affected the sorting behavior
    • The Grand Totals option did not appear in the menu on Pivot tables after drilling down
    • The Linux Pivot widgets Grand Totals auto-returned a unique ID instead of the SUM of values
  • Add-on Fixes
    • Sisense BloX did not support proxy URLs
    • The Jump-to-Dashboard add-on did not behave as expected when there was only one dimension/group in a row
    • The Jump-to-Dashboard add-on did not work when Sisense was configured to be accessed through a reverse Proxy
    • The Jump-to-Dashboard add-on did not pass all date-time dashboard filters
    • Jump to dashboard did not work on Pivot tables when "Widget affects dashboard filters" was enabled
    • When using the Dynamic ElastiCube add-on, widgets failed to load if there was a NULL value in the filters

8.2.6.400 - Official release of Sisense V8.2.6 - November 20, 2020

Announcing Breaking Changes

  • The endpoint PUT /elasticubes/{server}/{elasticube}/permissions now validates if the ElastiCube exists or not. If it does not, an error is returned. Previously, no validation was performed and this led to new ElastiCubes being created that could not be deleted
  • Sisense will soon upgrade to a newer, faster, and more detailed implementation of Scatter Maps. This enhancement means that from December 15, old scatter map versions will not display properly. To avoid any issues, you can either upgrade your Sisense deployment, or make a simple configuration change. Instructions for both options will be sent to you within the next few weeks as well as be published here

New Features and Enhancements
Introducing Explanations

Use the Explanations feature to automatically identify the most probable key drivers for a given change in a time series. This is particularly useful when investigating the cause of a spike or sudden decrease in your data (Read More)

Optimized Query Translation

  • Improved dashboard performance with optimized and readable SQL queries
  • Dashboard Designers can look “under the hood” to view optimized queries and validate the logic behind the visualizations
  • View and understand optimized queries to the following data sources with the new translation service:

Sisense Forecasting Enhancements

  • When viewing forecasts in Sisense, you can now quickly and easily change the forecast period and the forecast settings directly from the graph. The new forecast options are applied instantly so that you get immediate results
  • You can now set your forecasts to ignore the specific time periods in your historical data. This is useful if those periods do not represent your regular data behavior (for example, Holidays and COVID-19 time) (Read More)

Extend Connector Functionality

  • Add custom behavior and expand the functionality of existing data connectors to Sisense using custom plugins. You can manipulate generated SQL query on the fly, and allow row level data manipulation. Sisense’s custom plugins give you additional flexibility for your analytics (Read More)

Improved Data Connectors

  • Sisense now offers improved memory consumption for Data Connectors and eliminates inconsistencies on upgrades for Oracle and Google BigQuery (Read More)

Analytics Improvements

  • When you have "Simply Ask" (NLQ) on your dashboard, and you ask a question in natural language and receive a widget, you can easily click to add that widget directly to your dashboard
  • SQL syntax is highlighted when importing queries

Selected Bug Fixes

Language and Translation Issues:

  • Folders and dashboard names were not translated when using the Metadata Translation add-on
  • The Change Language icon was not available on the Login page
  • Strings in Arabic were cut off in Indicator widgets
  • Labels were missing for Pie charts when the 'Categories' were in Arabic
  • English language translation files could not be modified

SSO Issues:

  • In some cases, when using SSO, sharing a dashboard displayed a blank screen, instead of the Share dialog box
  • OpenID Cconnect SSO authentication failed with the error "Cannot read property 'devices' of undefined
  • Sisense did not import groups from OpenID Connect group claim when the claim name was in a URL format

Embedding Issues:

  • In some scenarios, dashboards embedded with Sisense JS failed to open with console errors due to webkit
  • Embed SDK without an initial dashboard loaded with an error
  • In some scenarios, the embed SDK ignored UI settings, for example, "showLeftPane=false"
  • Embed SDK did not reject promises when an error occurred
  • Issues related to Data Models:Table previews failed when a column name contained a close square bracket "]"
  • The ElastiCubes list was not available on the Data Model page in Internet Explorer
  • The Manifest.json file for Google connectors was overwritten when upgrading, which led to credentials and Oauth information being deleted
  • You could not access an ElastiCube in Sisense and the error message: Error loading model: "Relation "..." contains invalid Table "...".
  • Milliseconds was not supported for accumulative builds when using Google BigQuery

Analytics Issues:

  • When using Pivot Tables and the Jump to dashboard add-on, two windows were opened
  • In some cases, multiple large Pivot Tables would delay navigating to another dashboard while these Pivot Tables were loading in the current dashboard
  • Conditional coloring for Pivot Table values did not work properly when applied on formulas based on string fields
  • The error "An item with the same key has already been added" appeared in the browser console whenever the same field was used in a Pivot Table's 'Values and 'Columns', and filtering by that same column was applied using a widget filter or a dashboard filter
  • For Usage Analytics, dashboards with Pivots Tables were not logged with the action 'loaded'
  • The Clear Selection feature did not work with time frames and calendar filters

Other Issues:

  • Custom logos were not displayed when the system was configured to use a base URL

Limitations

  • Dashboard filters on Live custom columns are not working correctly and cannot be updated after a datatype change
  • Options statement is not supported on Live models in old translator

8.2.4

8.2.4.467 - Service Pack - November 13, 2020

  • Selected bug fixes

8.2.4.446 - Service Pack - November 4, 2020

The following bugs were fixed:

  • Some builds based on PostgreSQL failed due to memory issues
  • ElastiCube MetaData API Endpoints returned data slower than expected or timed out
  • API calls could result in Zookeeper pods crashing
  • In some cases, Subtotals and Grand Totals were not presented as expected
  • Sisense crashed after adding new domains to the whitelist in security embedded domains
  • The GET /app_database/encrypt_database_password endpoint returned a 500 error
  • Concurrent calls to the DELETE /api/v1/groups endpoint caused Sisense to crash
  • When backing up Sisense while including the data farms, the data farms were imported before the backup job was complete
  • Autoscaler scaled down nodes and deleted pods before builds were complete
  • Builds based on Salesforce occasionally failed

8.2.4.434 - Service Pack - October 28, 2020

Breaking Change:

  • When a user downloads a CSV file from the dashboard, exported numbers did not take into account browser localization

The following bugs were fixed:

  • When NLQ Live was enabled, the Jobs pod crashed in certain scenarios
  • In some scenarios, an error occurred when changing the data provider of a data model
  • In some scenarios, the Jobs pod crashed
  • The RabbitMQ Metrics dashboard did not return data in Grafana
  • Scheduled Reports were sent according to the timezone of your Linux machine and not the timezone set in Sisense
  • When changing a database at the data source level to tables with same name but different schemas, an error was returned
  • The Share and Duplicate options were displayed in the navigation pane for folders where they should not be displayed
  • In some scenarios, for Column charts with continuous timelines the error "access denied. No permissions for datasource replacement:403" was returned
  • When changing language preferences, null was returned as the value for localeId for some languages
  • The Save button did not work when creating custom actions

8.2.4.411 - Service Pack - October 21, 2020

The following limitation was added for this version and earlier versions:

  • In Linux, when using Advanced filters with anchors, the query will fail

The following bugs were fixed:

  • Sisense Licenses could not be activated in IE11
  • In some scenarios, Pivot widgets would hang after updating a filter
  • Pivot widgets failed when filters excluded NA values in formulas or widgets
  • Tables that have been renamed could not be redirected to matching tables with the original table name when changing the connectivity settings
  • In environments with SSL enabled, the URL of shared dashboards used HTTP and not HTTPS
  • In some scenarios, dashboards embedded with SisenseJS V1.0 would not open and the console error “sisenseWebpackJsonp is not defined” was returned
  • In some scenarios, when exporting Line charts to CSV, the values were not the same
  • Semicolons at the end of queries to Postgres did not return results in Sisense Linux V8.2.4
  • Parsing and previewing custom queries in Google BigQuery failed when allowLargeResult was enabled
  • Some widgets could not be loaded when interceptors were present
  • The API /api/datasources/localhost/EC_NAME/fields/search did not return the Fields list when an ElastiCube table has "" in its name

8.2.4.370 - Service Pack - October 13, 2020

New Features and Enhancements

  • Sisense automatically assigns users to Sisense groups when working with OIDC SSO
  • Multiple changes were implemented to improve user experience when working with Sisense NLQ

The selected bugs were fixed:

  • Dashboard reports were sent even after the template was deleted
  • When Sisense NLQ is not enabled for NLQ customers, opening the Data page returned a 404 error
  • The EC-Query log was larger than expected due to all copy operations being recorded
  • No rows were displayed when previewing data from Google Sheets
  • In certain scenarios, an error occurred when using the OPTION statement in a custom query
  • In environments with hundreds of thousands of users, publishing a dashboard took longer than expected
  • In certain scenarios, Sisense crashed after adding or changing whitelist security rules in embedded domains
  • When using a top ranking widget filter with a custom JAQL, an "unexpected end of input" error was displayed when rendering a pivot table
  • In some scenarios, builds did not complete as expected
  • Requests timed out when calling the authentication/getUserDetails_v1 endpoint

8.2.4.307 - Official release of Sisense V8.2.4 - September 30, 2020

Announcing Breaking Changes

  • In a future version of Sisense, support for Internet Explorer 11 will be discontinued, aligned with Microsoft’s end of support for this browser
  • Following several improvements made in Sisense, widgets built on nondeterministic models may display different results than in previous versions of Sisense
  • Starting from this release, Sisense no longer supports the MongoDB trace collection

New Features and Enhancements

Introducing Audit Logs

  • Sisense now supports generating audit logs
  • You can now monitor which users are adding, editing, or deleting entities, including users, groups, row-based data security, access permissions (models and dashboards), and system configuration (Documentation)

Support added for Pre/Post-Build Add-ons

  • Run bash scripts before and after you build an ElastiCube to automate processes for cleansing your data or exporting it (Documentation)

Improved Governance for Data Models

  • Sisense has enriched the Data Model permissions and now enables you to configure which users can only view dashboards on the model. This is in addition to the existing options to configure which users can edit models, and which users can create dashboards on models.
  • All existing model permissions are automatically modified when upgrading as follows:
    • “Can Edit” permissions are changed to: “Can Edit Model”
    • “Can Query” permissions are changed to “Can Create & View Dashboards”
    • A new permission level: “Can View Dashboards” is added (Read More)

Improved Data Connectors

Sisense now offers improved memory consumption, inconsistencies on upgrades for Snowflake, Redshift, Postgres, MySQL (Read More)

Added Drill Hierarchies for Live Models

You can now simplify how your Viewers explore their data with predefined drill hierarchies in widgets for Live models (Read More)

Data Wizard Improvements

  • Hover over tables in the Data Wizard to display an icon that opens a preview of your table and its settings
  • Quickly select all schema tables with a select-all checkbox
  • A table loading progress bar was added
  • After parsing tables, before they are imported, you can update the connection settings for tables that could not be validated (Documentation)

Support for Kubernetes 1.17

Version L8.2.1 introduced support for Kubernetes version 1.17. If you have not yet upgraded to Kubernetes version 1.17, you must upgrade to Kubernetes 1.17, to upgrade to Sisense version 8.2.4. If you have already upgraded to Kubernetes 1.17, no special process is required with this upgrade.

Process for upgrading Kubernetes:

As upgrading to Kubernetes 1.17 is a Kubernetes upgrade of more than a single version, it cannot be done automatically by the Sisense upgrade process.

If you have a single node deployment, you have two options:

  1. You can uninstall the deployment including Kubernetes and keep the data. Then install a new deployment on the same machine. This will continue using the previously existing data from the local storage. Note that with this method, your build schedules will not be retained. You will need to reschedule your builds following the upgrade.

  2. You can backup your existing deployment, install a fresh deployment, and restore to the new one.

If you have a cluster deployment, you cannot upgrade in place. Instead, backup your existing cluster, deploy a new cluster, backup your existing cluster, and restore from your backup to your new installation. (Documentation)

Improvements to the Trend Line

  • You can now modify trend lines directly by right-clicking the trend line itself. You can quickly change the trend line type and add a trend line of a previous period to help you compare past and current trends
  • You can now add trend lines to forecasted values
  • Exported CSV files now include values from Trend lines
  • New advanced algorithms are used to detect anomalies on the trend line so that you can set Sisense to ignore them (Documentation)

Improvements to Sisense Forecast

  • Forecast Boundaries are added to enable you to prevent Forecasts from displaying unreasonable values. For example, if your measure can't be negative, a fraction, or over 100%
  • Exported CSV files now include values from Sisense Forecast
  • Missing values are now represented as “0” for continuous line charts (Documentation)

New UI Customization Features

This version introduces two new Admin pages: “White Labeling” and “Look and Feel” to easily customize your Sisense experience from the Admin User Interface

  • Look and Feel: You can customize how your Sisense environment looks by setting fonts, colors for dashboards, widgets, backgrounds, and more. You can achieve stunning results using an intuitive user interface and preview your changes before applying them (Documentation)
  • White Labeling: Depending on your license, you can now control your white labeling experience by adding your own logos and displaying custom favicons to Sisense. You can also customize the marketing banner displayed at the top of the Data and Analytics pages. These options were previously only available using the REST API, but are now easily available to all Administrators (Embedding, White Labeling, and Rebranding)

Improvement to Chart Widgets with Break-by Fields

  • In chart widgets, you can sort the results (for example, to appear in ascending or descending order), even though a break-by field is applied. If you apply a break-by field after sorting, the sort order is maintained

Improved SSO User Management

  • Administrators can now control whether SSO authentication can create new users, or only authenticate existing users. This gives the Administrator more control over Sisense license allocation (Using Single Sign-On to access Sisense).

Other

  • Automatically queue multiple ElastiCube builds that are triggered simultaneously (Documentation)
  • Your DNS name can only be defined when installing or upgrading Sisense. After defining this value, you can view it on the Admin page under General Settings.
  • Sisense now supports the Chromium-based Edge browser (starting from Edge version 79)
  • You can now configure Sisense to only allow uploads of CSV and Excel files from specific paths
  • A transaction ID is added to all product logs to simplify troubleshooting issues
  • The Sisense patents link is now available in the Admin page, under General Settings
  • You can now configure which port is used for Grafana (Documentation)

Updated Libraries

  • The fluentD library was updated to version 1.11
  • The fluent-Bit library was updated to version 1.4.6
  • The bson library was updated to version 1.1..4
  • The handlebars library was updated to version 4.7.6
  • The node-sass library was updated to version 4.14.1
  • The jackson-databind library was updated to version 2.11.1

Selected Bug Fixes

  • Pivot Table Subtotals and Grand Totals did not work in Auto mode
  • The inability to increase memory for the Pivot Table service intermittently caused large Excel files exports to fail
  • Pivot Tables did not always realign their size correctly upon collapsing panels or manually changing the widget size
  • Administrators and Data Administrators now receive Pulse notifications for Pulses they are subscribed to, regardless of their explicitly configured permissions to access a specific data model
  • Republishing a dashboard with 10k+ users caused an application freeze or an Error 500 screen
  • Open ID Connect Improvements:
    • After login via OpenID Connect, users were redirected to the Home page, instead of the requested URL
    • OpenID Connect did not work correctly in embedded use cases
  • A Data designer was not able to add data security values
  • After removing a user’s the group association, the old group was still visible
  • If the reverse proxy was used in combination with a Base URL in Sisense, then the Configuration page under Admin > System Management did not load
  • Query proxy pod memory limits have been extended to 4GB memory
  • The following plugins were updated so they work correctly when a Sisense server was configured to support CSRF protection:
    • Aggregated Table - version 1.0.1 or later
    • Comments - version 1.0.4 or later
    • Dynamic Buckets - version 1.1 or later
    • Dynamic Elasticubes - version 2.3.8 or later
    • Embed Images - version 1.0.5 or later
    • Filtered Measure - version 1.0.1 or later
    • Funnel Widget - version 1.0.6 or later
    • Limit Autocomplete - version 1.0.11 or later
    • Print Widget - version 1.0 or later
    • Switchable Dimensions - version 1.0.5 or later
    • Tabber - version 1.0.9 or later

8.2.1

8.2.1.435 - Service Pack - September 16, 2020

  • Selected bug fixes

8.2.1.421 - Service Pack - September 8, 2020

  • Selected bug fixes

8.2.1.366 - Service Pack - August 11, 2020

  • Sisense for Linux is now certified for deployment on OpenShift 4.3.19, 4.4, and 4.5
  • Selected bug fixes

8.2.1.328 - Service Pack - July 28, 2020

  • Support for the Warehouse tab is added
  • Selected bug fixes and security hardening

8.2.1.306 - Official release of Sisense V8.2.1 - July 19, 2020

Announcing Breaking Changes

  • The Content-Security-Policy was updated. The following add-ons do not work as expected unless you configure the new security policies for these add-ons as described in the readme file for each add-on:

    JAQLine
    Sisense BloX
    Embedded Images
    Comments

For more information, click here.

  • This version includes changes to the web interface header components that affect add-ons (plugins). If you implemented custom add-ons that affect the web application header UI, Sisense recommends that you review your add-ons code and make any required updates (Documentation)
  • Designers cannot make any changes to Sisense dashboards and widgets that are embedded in your websites or applications in View mode. To make changes to dashboards and widgets, the host environment must be set to Edit mode (Embedding Dashboards and Widgets)
  • Sisense now displays Nulls by default in all widgets in all dashboards unless filtered out (Documentation)
  • In report subscriptions, the user-level settings now overrides the group-level settings. This means that in cases when the user is subscribed to the report both as an individual user and as part of a user group, if the user unsubscribes from the report, the system will stop sending the user email reports (ignoring that the user is still subscribed as part of the group)
  • Text filters applied to date fields that were converted to text format will no longer work
  • Recently, Google announced that Google Sheets API V3 and Google Drive API V2 are documented for legacy purposes only. These APIs will be shut down on September 30, 2020 and will eventually be deprecated (extended from March 3, 2020 - due to COVID-19).
  • These API versions are used by Sisense on the Google Sheets connector in versions earlier than Windows 8.2.0/Linux L8.0.4.
  • Sisense for Windows V8.2.0/Linux V8.0.4 were upgraded to use Google Sheets API V4 and Google Drive API V3.
  • The effect of Google's API changes is that users now have access to their shared drive, but need to re-authenticate after upgrading their Sisense version to use the connector.
  • Google sheets with column headers that contain text and special characters in the column's headers are now supported. After upgrading, if you refresh the schema, your dashboard will not work as expected and you will need to update it with the newly supported column names. If you do not refresh the schema, Google Sheets will continue to work as before

New Features and Enhancements

More Deployment Options

  • Install Sisense on your Kubernetes environment using Helm charts (Helm version 2.16) (Documentation)

  • Install the Sisense application on Linux in offline environments. This deployment includes the Sisense application only, and allows installing it within existing Kubernetes clusters. (Documentation)

  • Install Sisense single node deployment into an existing highly available Kubernetes cluster

  • Support for Kubernetes 1.17 (Documentation)

    • This version adds support for Kubernetes version 1.17. Upgrading Kubernetes is strongly recommended. The new Kubernetes version includes many bug fixes for issues encountered by Sisense customers, including network issues related to Calico usage. You can choose to upgrade Sisense only, without upgrading Kubernetes, but Sisense recommends you do not.

    • As the Kubernetes version upgrade is large, it cannot be done automatically by the Sisense upgrade process. You must specify update_k8s_version=false in the deployment script.

    • When upgrading Kubernetes, if you have a single node deployment, you have two options:

    • You can uninstall the deployment and keep the data. Then install a new deployment on the same machine. This will continue using the previously existing data from the local storage.

    • You can backup your existing deployment, install a fresh deployment, backup the old one, and restore to the new one.

    • If you have a cluster deployment, you cannot upgrade in place. Instead, backup your existing cluster, deploy a new cluster, backup your existing cluster, and restore from your backup to your new installation.

    • When deploying on Google Cloud GKE, the minimum required version of the GKE cluster is 1.15.

    • Sisense version L8.2.1 provides updated versions of Prometheus and Grafana components (used for Sisense monitoring functionality), which include upgrades to Kubernetes custom resources (CRD). This has the following effect on Sisense deployments upgraded from an earlier version:

      • Loss of persistence storage for monitoring data - Due to the upgrade to the new CRD, the old data from Prometheus is not retained. Upgrading to version 8.2.1 will delete all existing monitoring data. This affects the monitoring data only, not the Sisense application data.
      • The new monitoring components require Kubernetes version 1.15 and above and will not work on managed Kubernetes (AKS, EKS, GKE) running version 1.14 or below.
      • Customers using Kubernetes 1.14 will be able to upgrade to Sisense version L8.2.1 but must disable the monitoring stack, that is deploy using internal_monitoring: false.

Introducing Forecasting

  • Sisense enables your users to apply advanced machine learning-powered forecasting techniques to easily forecast future values based on historical data (Read More)
  • The AI engine driving the forecast uses an ensemble of forecasting models to create the most effective forecast

Introducing Trend Lines

  • Get deeper insights faster and automatically by adding trend lines based on advanced analytic models on supported widgets (Read More)

More Sisense Natural Language Queries (NLQ)

  • Ask sophisticated questions in natural language on Live models
  • NLQ support for Forecasting and Trends (Read More)
  • Embed NLQ into your dashboards (Read More)

Embedded Dashboards and Widgets

  • Embed your Sisense dashboard or widget quickly with code snippets prepared in the new Embed Code Generator with no coding required (Embedding Dashboards and Widgets)

Analytics

Widget Improvements

  • Added support for changing data sources of individual widgets (Read More)
  • The option to display null values as zeros is added to the Values panel when creating or editing a widget (Read More)
  • In chart widgets, you can sort the results (for example, to appear in ascending or descending order), even though a break-by field is applied. If you apply a break-by field after sorting, the sort order is maintained.

Pie Chart Improvements

  • Dashboard Designers can now control which value members are included in the "Others" slice by changing the default from 3% (Read More)
  • The Pie Chart widget now supports sorting in two directions: Clockwise and Counter- Clockwise

Scheduled Reports and PDF Improvements

  • Unsubscribe from your dashboard reports (Read More)
  • Dashboard users, including Designers and Viewers, can now choose a monthly schedule for receiving email reports (Read More)
  • Sisense PDF reports now support A0, A1, and A2 page sizes
  • Sisense highlights the Share icon on your dashboard so you can see when changes you made to a dashboard are not visible to users you shared the dashboard with (Read More)
  • Restoring filters on your dashboard does not reset filters in your PDF report settings

Dashboard Improvements

  • Sort your dashboards when displayed in the List view on the Analytics page (Read More)
  • Duplicate multiple dashboards with a single click (Read More)
  • Support for equal distribution of widgets across a row in a dashboard added (Read More)
  • The background color and text spacing in the Formula Editor were changed to make elements more readable
  • Designers can now view hierarchies on dashboards that have been shared with them
  • Performance improvements for queries on Live models

Administration and Configuration Enhancements

  • Manage system settings easier from the Admin page where the System Settings were reorganized into three new sections, General Settings, Security Settings, and Feature Management
  • Configure custom email servers directly from Sisense through an Admin screen (Read More)
  • Change your Sisense password from within the User Profile area (Read More)
  • Sisense’s patents link is now available in the Admin page, under General Settings, instead of the User Profile menu
  • The Plugins section within the Admin page was renamed Add-Ons. The functionality remains the same
  • Sisense Administrators can control whether to update dashboards on every filter change (Read More)
  • You can now configure the thrift timeout limit for the Galaxy service, which controls the web server logic. The default value is three minutes, but you can now change that using the Configuration Manager.

Row-based data security rules:

  • You can define the scope limitations for row-based data security rules to determine when the data security rules should be applied (Data Access Security)
  • Exclusionary row-based data security rules can now be created from the user interface in addition to inclusionary data security rules. This functionality was previously available only over API

SSO Enhancements

  • Administrators can now control whether SSO authentication can create new users, or only authenticate existing users. This gives the Administrator more control over Sisense license allocation. (Introduction to SSO)
  • Users created by SSO over SAML can now be associated with all roles of the system, except Administrator and Data Administrator
  • SSO users who do not have a Sisense password defined for them will not be able to use the Forgot Password functionality to define a Sisense local password
  • When accessing Sisense directly from the Login page, a new option allows users to choose to log in using their SSO provider, instead of using Sisense local authentication

Security Enhancements

  • All services are run as a non-Root user (Read More)
  • You can now configure Sisense to only allow uploads of CSV and Excel files from specific paths.
  • Added security headers for controlling the application caching: "Cache-Control: no-store" and "Cache-Control: must-revalidate"
  • Removed support for weak cipher suites

Data Connectors

  • Significant improvements to Oracle and Snowflake connectors performance
  • New native connectors were added enabling connections to Athena (Read More)
  • Performance improvements for Sisense ElastiCubes (Read More)
  • The library of certified data connectors was substantially expanded with new data connectors, including Jira, Facebook, LinkedIn, Instagram, Shopify, Teradata, MariaDB, and more (Read More)
  • You can now connect to Google Big Query with a service account and can use the Google Big Query Storage API to handle large result sets much faster (up to X10 faster) and more efficiently (Read More)
  • You can now add additional parameters to the connection string in the guided (basic) connection configuration for Salesforce, Google BigQuery, MemSQL, Oracle, Snowflake
  • Columns that use the ] delimiter are now handled as expected
  • Significant improvements were made to Sisense builds reducing build failures
  • More support for table queries when changing connections was added

Data Modeling

  • Define the positions of tables in your schema on the model-level, not the user level. Any changes to the model and the positions of the tables are reflected to all users who look at the model in the Data page
  • Creating relationships between tables in live models is enabled by default
  • Perform bulk changes to columns including showing, hiding, dropping and restoring from the navigation pane (Read More)
  • Perform bulk operations on tables including dropping and restoring multiple columns (Read More)
  • Export and Import data models (Read More)
  • Support added for live custom columns (Read More)
  • Support for Group similar is now supported such that Sisense for Linux can identify similar strings and group them into a single attribute (Read More)

Other

  • The SisenseJS library has been optimized with the following improvements:
    • Isolated scope: SisenseJS will not override any globals on the window and can work alongside other versions of the aforementioned libraries
    • Isolated CSS classes: SisenseJS will not override or collide with any of your CSS classes or rules (Read More)

Software Library Updates

  • The Sisense application database (MongoDB) was upgraded to V3.6.8
  • Sisense has been upgraded to Angular 1.7.8
  • JQuery library was updated V3.4.1
  • Sisense was upgraded to use Bootstrap version V3.4.1

Limitations

  • L8.2.1 build 306 does not support the Warehouse tab. The Warehouse tab is supported starting from L8.2.1 build 328.
  • Generic JDBC query to table with special symbols in columns names fails occasionally
  • Google Big Query ODBC: Unable to Build 50G table
  • You cannot connect to Hubspot through the Generic JDBC connector. You should use the native connector instead
  • The JDBC connector does not support files with special characters
  • Custom column names that are wrapped in square brackets "[ ]" may break a query
  • Multiple Past Value calculations in a single widget based on Google BigQuery Live can fail due to insufficient memory resources
  • Empty spaces are displayed on Stacked Area Chart Splines with null values
  • Sorting mixed data types in Pivot tables where the data is split into groups does not work as expected

8.0.5

8.0.5.361 - Service Pack - September 21, 2020

  • Selected bug fixes

8.0.5.354 - Service Pack - September 08, 2020

  • Selected bug fixes

8.0.5.314 - Service Pack - August 6, 2020

  • Selected bug fixes and security hardening

8.0.5.301 - Service Pack - July 30, 2020

  • Kubernetes and Calico versions were upgraded

8.0.5.278 - Service Pack - July 20, 2020

The following issues were resolved:

  • Add-ons and customized branding file were restored with root ownership
  • CSVs with Russian characters were not displayed as expected in Preview
  • Widgets were duplicated after using the API v1 POST /dashboards/replace endpoint
  • Shared dashboard changes are not published after using the API v1 POST /dashboards/replace endpoint
  • Applying data security through the REST API /elasticubes/live/{title}/datasecurity endpoint did not apply your changes
  • In some scenarios, the Calico pod restarted many times

8.0.5.270 - Service Pack - July 12, 2020

  • In some cases, importing specific dashboards failed
  • Pivot Table widgets are not displayed when they include escaped characters (“\” appears in string)
  • Email reports were not sent when the dashboard contained a Pivot Table widget
  • Builds on OpenShift failed due to connection errors
  • Changes to data models were reverted following scheduled builds
  • Some unnecessary internal resources were not removed after building ElastiCubes using data groups causing the Data page to timeout
  • Imported ElastiCubes through the Sisense CLI did not work as expected when sample ElastiCubes did not exist
  • Grafana dashboards were not displayed and returned the error “Datasource name Prometheus not found”

8.0.5.245 - Service Pack - June 24, 2020

Features and Enhancements

  • Natural Language Queries are now supported on multi-node (cluster) deployments
  • Display HTML in Pivot 2 table cells as plain text or HTML (Documentation)
  • Rebranded files are now restored when restoring Sisense
  • Sisense backs up add-ons when you back up Sisense

Limitations

  • Google Sheets builds failed with previous authentication credentials. The credentials need to be re-entered
  • After upgrading from L8.0.3 to L8.0.5 the Dynamic ElastiCube stops toggling between Groups and ElastiCubes. To work around this limitation, Sisense recommends you copy the configuration file before upgrading and then restore the file after upgrading. For more information, see Dynamic ElastiCubes

Selected Bug Fixes:

Pivot 2 Fixes:

  • Resizing Pivot 2 widgets in a row with a second widget does not resize the Pivot 2 widgets as expected
  • In some scenarios, web socket messages were duplicated and this led to some Pivot 2 rows being duplicated
  • When attempting to export a dashboard with a Pivot widget that has no results, the exported failed
  • When a Pivot widget with enough columns to make a horizontal scroll bar visible is created and takes up a whole column and another widget is placed in the same row as the Pivot widget, the horizontal scroll bar remained the same length

Jump to Dashboard Add-on Fixes:

  • Designers could not define the dashboard to jump to in the Jump to Dashboard add-on
  • In some cases, the Jump to Dashboard add-on did not work in Internet Explorer

Other Fixes:

  • Builds occasionally failed with the message “Failed to resolve class for column”
  • XSRF-Token is now generated when using SAML SSO and CSRF is enabled
  • In some scenarios, the Sisense log directory (logs /var/log/sisense/sisense/) was not created
  • Personal information was removed from log files generated on the Info level
  • Sisense added resource limits on the node-exporter via the Prometheus chart and created a namespace limitation on kube-system for kube-proxy pods
  • In some scenarios, the Viewer role drill down did not work as expected
  • When Sisense NLQ was enabled from the Admin page, not all the required services were enabled on the cluster
  • Cookies were not always recognized as valid, which led to users being occasionally logged out
  • Security issues were resolved

8.0.5.212 - Service Pack - June 11, 2020

  • Data designers can use SQL to define materialized views on Snowflake data warehouses to prepare data to enable analysts to create crucial business logic transformations for analysis and to speed up data model builds and live dashboards (Documentation)
  • The MongoDB driver was updated

The service pack includes the following fixed issues:

  • Security issues were resolved

  • You could not connect to your external Logz.io account

  • Analytics

    A duplicate dashboard is created after opening a shared dashboard by a direct link and changing filters
    In some scenarios, widgets' filters became corrupted when a user opened a dashboard

  • Add-Ons
    The Dynamic ElastiCube add-on did not work in some scenarios
    Restarting BloX pods removed custom actions

  • Data, Builds and Connector issues were resolved:

    In some scenarios, you could not build ElastiCubes with hidden custom tables

  • Data Warehouses

    When viewing a preview of your data in the Warehouse page, the preview was not labeled as truncated until the full query was complete
    In the Warehouse page, an empty view was created when you chose "Don't Save"

8.0.5.188 - Service Pack - June 2, 2020

The service pack includes the following fixed issues:

  • Security issues were resolved

  • Sisense Monitor did not display data for some fields (hosts)

  • In some scenarios, the Session table showed inaccurate session durations

  • Multiple issues related to builds were resolved including:
    Accumulative builds failed when using local storage with S3
    Accumulative builds failed on the Initialize step
    Builds failed after renaming a table and changing the connection
    Building the Usage Analytics model failed in some cases

  • Analytics:

    Failed to download a CSV from a widget whose title included Japanese characters
    Dashboards failed to display data from Live widgets on MySQL, when communicating over SSL

8.0.5.156 - Service Pack - May 25, 2020

  • In some scenarios, exporting to Excel failed due to out of memory exceptions
  • Some API responses returned a 403 instead of 401
  • In some scenarios, the application database configuration was not applied in single node deployments
  • The monitoring dashboard for the configuration database did not display data when a deployment had multiple namespaces

8.0.5.150 - Official release of Sisense V8.0.5 - May 20, 2020

Announcing Breaking Changes

  • Following security changes to Sisense, if you are using the Dynamic ElastiCube add-on, you must download and install the latest version again

New Features and Enhancements

Introducing In-Warehouse Data Prep

  • Data designers can use SQL to define materialized views on Redshift data warehouses to prepare data to enable analysts to create crucial business logic transformations for analysis and to speed up data model builds and live dashboards (Documentation)
  • Materialized views are automatically kept up to date on a schedule that you can define
  • Includes a Materialize View editor and a data profiling Statistics tab that automatically calculates descriptive statistics and distributions for the query preview results
  • In-Warehouse Data Prep uses Sisense Cloud features and requires a signed DPA to leverage its capabilities

Embed SDK

  • Developers now can use a suite of new JavaScript APIs to programmatically embed Sisense dashboards into host apps and effortlessly handle complex embedded integrations (Documentation)

Other

  • Support was added for accumulative builds on BIGINT values
  • Turkish and Korean languages are now supported in the Sisense interface
  • Build logs include more details and additional information about the build process

Selected Bug Fixes

  • In some scenarios, you could not change the connections for ElastiCubes based on MSSQL
  • Previewing data in BigQuery tables did not work as expected
  • When downloading a widget as an Excel file, characters enclosed in single quotes were not always formatted as expected
  • In some cases, ElastiCube tables with long strings could not be previewed
  • In some cases, JDBC DB2 connections failed during the building, but not while previewing
  • When changing connections on the data source level, in some cases, a table was not shown and the error ‘Cannot read property 'toLowerCase' of null’ was returned
  • While connecting to NetSuite through the JDBC connector, default queries did not work as expected if there was a space in the table/column qualifier and default separator was used
  • In some scenarios, scheduled accumulative builds failed
  • When parsing and customizing MySQL queries and clicking Done, the entire query was executed instead of only returning the schema and metadata

8.0.4

8.0.4.278 - Service Pack - May 20, 2020

The following issues were resolved:

  • In some scenarios, builds based on Google Analytics and Google Ads finished with empty tables (details)
  • Some Live queries to Snowflake with data filters returned an error
  • FSx driver images are now maintained in the Sisense repository to control the version used, and are not automatically downloaded from the AWS repository
  • The Docker-ce-cli's version was updated to version 19.03.9 in all distributions due to Docker production changes

8.0.4.273 - Service Pack - May 17, 2020

The following issues were resolved:

  • Added support for BigInt
  • Issues related to accumulative builds
  • Optimization for a very large ECM model in case of sub-tree
  • Issues related to PostGres custom queries
  • Local storage CP command issues
  • System backup with data issues

8.0.4.258 - Official release of Sisense V8.0.4 - April 23, 2020

Announcing Breaking Changes

  • Sisense has added support for FSx types Scratch 2 and Persist. To support these new types, the cloud_config.yaml file was updated and the parameters fsx_file_system_id and fsx_region were changed to fsx_dns_name and fsx_mount_name (Documentation)
  • This version does not support downgrading to previous versions, therefore:
    • Before upgrading to V8.0.4, Sisense recommends backing up your current deployment
    • If downgrading to a previous version is required, deploy a fresh installation of the desired version, and restore it from your pre-update backup
    • Documentation for backing up and restoring on Linux
  • This version does not support restoring from a backup created in a previous version. If you need to restore a backup of a previous version you should:
    • Deploy a fresh installation of the original version, and restore from your pre-update backup
    • Upgrade the fresh installation to V8.0.4
    • Documentation for backup and restore on Linux is available here
  • If you are using Sisense provided Kubespray, in Sisense Linux V8.0.3, the Kubespray components were upgraded. If you are upgrading from a version earlier than version 8.0.3 to this version, you will not be able to add nodes to a cluster. If you do want to scale your deployment, after upgrading to Linux 8.0.3 or Linux 8.0.4, create a system backup. Install a new Kubespray cluster using the new version, and then perform a system restore using the backup you created. Following that, you can add additional nodes to the deployment.

New Features and Enhancements
Introducing Sisense Natural Language Queries (NLQ)

  • Ask sophisticated questions in natural language directly from your dashboard
  • Go beyond pre-defined widgets to get more insights without knowing the underlying data
  • Get automatic suggested questions and recommended visualizations (Documentation)

New Data Models APIs

  • Create and modify Sisense data models programmatically, enabling complex data workflows that require automated creation and management of data models and data flows (Documentation)

New Pivot Table Cell APIs

  • Change the formatting and manipulate the content of Pivot Table cells with a few lines of code. (Documentation)

Sisense Live Improvements

  • Create Pulse data alerts for widgets based on Live data sources (Documentation)
  • Add tables from multiple schemas in Live data models (Documentation)

OpenID Connect SSO

  • Use OpenID Connect to allow your users to authenticate once and access your dashboards (see Single Sign On (SSO))

Deployment Improvements

  • Added support for integration with the Amazon EKS autoscaler. The EKS autoscaler communicates with Amazon to add or remove nodes automatically (Documentation)
  • Added support for SSL for the AWS Load Balancer
  • Build and store ElastiCubes on S3 storage (Documentation)
  • Sisense validates that you meet the minimum requirements during installation with a CPU that has at least 8 cores and 1st disk with at least 150 GB in storage

Selected Bug Fixes

  • Security issues were resolved
  • Area Charts in stacked mode displayed the wrong tooltip when hovering over the widget
  • Sisense load balancer communicated over port 8456, after the listening port was changed to 443
  • Embedding Pivot widgets did not work as expected
  • The Pivot2 service crashes after sorting operations
  • Create and Cancel buttons were not displayed as expected when creating widgets on small screen resolutions
  • In some scenarios, opening a data model from the Data Model row returned a 404 error
  • Resizing the browser resolution on a dashboard when Auto Heighted was enabled could overload the browser with requests
  • API calls to dashboards took longer than expected when there were many dashboards
  • Japanese abbreviations (T, B, M, K) were empty when exported in PDF and PNG
  • Google BigQuery Live did not filter dates as expected as it treated the fields as date-time fields
  • After rebuilding the JumpToDashboard add-on in Linux, it was not displayed in Sisense
  • The JumpToDashboard add-on could not open, the destination dashboard in the same window if Sisense was embedded in the frame.
  • In Sisense on EKS, the default Load Balancer is created as a classic load balancer instead of the application load balancer
  • Installation issues due to errors where packages could not be matched:
  • In some scenarios, pods were stuck on 'ImagePullBackOff'

Limitations

  • When Migrating from Windows environments to Linux environments, you need to import all the relevant ElastiCubes for the schema to be loaded fully
  • When using the Join settings add-on, you cannot edit joins for widgets
  • In some scenarios, the application database does not work as expected when a system is turned off
  • "Failed to Fetch logs" error message is displayed when attempting to download or view sample ElastiCube log files
  • Builds fail for ElastiCubes based on Redshift that are 200GB or larger.
  • Builds for tables with special characters fail when using the Sisense ElastiCube to ElastiCube connector
  • When the application database folder is too large, it can result in standard database processes taking too long, causing a timeout in starting its pod

8.0.3

8.0.3.148 - Service Pack - March 17, 2020

  • Security issues were resolved
  • Build failures:
    • Resolved an issue where a build failed with “generic error BE#521691”, when building a custom table
    • Resolved an issue where a full build failed with error: "tbb Exception: No chunkerMap entry for file"
  • Implemented memory management improvements related to ElastiCube builds
  • Fixed deployment failure with error message: "Could not match packages: failure: repodata/repomd.xml from docker-engine: [Errno 256] N o more mirrors to try.\nhttps://yum.dockerproject.org/repo/main/centos/7/repodata/repomd.xml error"

8.0.3.133 - Service Pack - February 24, 2020

  • Issues that led to accumulative build failures were resolved

8.0.3.131 - Service Pack - February 19, 2020

  • Security issues were resolved

  • The following issues were resolved:

    Cases of duplicate connection entities in the application database were handled
    Improved Kubernetes readiness and liveness check

8.0.3.127 - Official release of Sisense V8.0.3 - February 11, 2020

Announcing Breaking Changes

  • If you are using Sisense provided Kubespray, in Sisense Linux V8.0.3, the Kubespray components were upgraded. If you are upgrading from a version earlier than version 8.0.3, you will not be able to add nodes to a cluster. If you do want to scale your deployment, after upgrading to Linux 8.0.3 or Linux 8.0.4, create a system backup. Install a new Kubespray cluster using the new version, and then perform a system restore using the backup you created. Following that, you can add additional nodes to the deployment.

New Features

  • MongoDB connector is now supported (Connecting to MongoDB)

  • New Admin setting, Support Cross Site Cookies for Embedding. This setting is relevant for embedded dashboards and SisenseJS. The attribute can be configured to support the “none” value, which is required by Chrome version 80. (Documentation)

    For more information about Sisense and Chrome version 80, see this Community Post

Selected Bug Fixes

  • Custom table queries that include EXEC commands did not work on the Microsoft SQL Server connector
  • Adding more than one Excel file through the Input file path field in the Data Wizard only displayed one file
  • When adding multiple Excel files, some previews were not displayed as expected
  • When canceling a build, future builds may not behave as expected
  • In some scenarios, filtered results were not highlighted
  • Occasionally, the dashboard Starts With filter did not work as expected

Limitations

  • MongoDB Connector:

    You can not connect to MongoDB with SSL when adding the certificate outside of connectors folder in Sisense Linux V8.0.3
    When connecting to MongoDB, your credentials are cached when SSL is enabled
    When creating a union from the Data Wizard while working with the MongoDB connector, no preview is displayed. You can import both tables individually and then perform a build. The next time you open the Data Wizard the preview is displayed as expected

8.0.2

8.0.2.231 - Service Pack- January 13, 2020

  • The configuration database (ZooKeeper) did not run as expected when the namespace was not Sisense
  • Selected general bugs were fixed

8.0.2.223 - Selected bugs were fixed - December 31, 2019

8.0.2.222 - Official release of Sisense V8.0.2 - Dec 29, 2019

New Features and Enhancements

Note:

Configuration settings for EFK were removed from the default configuration files.

Selected Bug Fixes

  • Security issues were resolved
  • The MongoDB/Zookeeper/ Rabbit pods were loading on the wrong node
  • Emails generated by Sisense included wrong URLs (IP address of the Kubernetes node, instead of the host external IP address
  • Default deployment configuration files didn’t include EFS and FXs storage options
  • Errors while installing Sisense on AWS EC2 with FSx storage were resolved
  • Issues related to MongoDB log file inflation were resolved
  • Importing a large ElastiCube of 10GB or larger could lead to a cluster failing
  • Connectors:
    • Google BigQuery:

      • Accumulation didn’t support milliseconds
      • Builds and previews failed when using a service account
      • Live service accounts did not work
    • Redshift:

      • Redshift Spectrum tables are missing in the data model
    • Live:

      • Changing isLiveRelationsSupported did not work

Limitations

  • Using the “Copy to server” feature for copying dashboards between clusters (different namespaces) is not supported if the two clusters have the same IP addresses
  • When using GlusterFS, if a node is shut down not according to Sisense instructions, you may need to recover your storage. For instructions, see here (Troubleshooting GlusterFS Pods)

8.0

8.0.0.724 - Selected bugs were fixed - December 25, 2019

8.0.0.714 - Selected bugs were fixed - December 1, 2019

8.0.0.709 - Selected bugs related to build failures were handled - November 24, 2019

8.0.0.707 - Official release of Sisense V8.0 - November 15, 2019

New Features and Enhancements

Introducing AI Exploration Paths

  • Sisense’s AI Exploration Paths automatically generates visualizations and insights that anticipate the next question from a business user without the involvement of a business analyst
  • It leverages AI to instantaneously deliver new answers to the questions most users have in mind when looking at the data to facilitate new and deeper insights directly within the context of a dashboard (Read More)

End-User Report Management

  • Any dashboard user now has full autonomy to control when they receive reports to their inbox, to coincide with the right analytic moment in their day
  • Dashboard users can manage their report subscriptions and determine the frequency, format, and contents of emailed reports, without the assistance of a dashboard owner (Read More)

New Certified Connectors

  • Users can leverage Sisense certified connectors to easily import data from a wide range of databases, web-based apps and file types
  • The library of certified data connectors was substantially expanded with new data connectors (Read More)
  • Ready-to-use, full-license versions of the drivers are available from here

User Management Enhancements

Improved Active Directory Integration

  • Increased Active Directory scale. Sisense supports many more users and groups while reducing the time to synchronize AD users
  • Associate your Sisense users with AD users while your Sisense users retain their dashboards and other assets (Read More)

More Flexibility for Managing Users in Groups

Rebranding Improvements

  • The Additional Connectors section is no longer displayed when adding a new data source for customers who rebrand Sisense
  • Documentation links were removed from the Google BigQuery connector interface

Other

  • Export and Import ElastiCube and Live models (Read More)
  • For SQL Server, Redshift and PostgreSQL connectors, you can now manually add additional parameters to the connection string
  • Google BigQuery connector supports worldwide query location for improved performance
  • To save resources, you can preview your changes to custom tables and columns only when you want to by clicking Preview

New Deployment Options Supported

  • Version V8.0 is certified for deployment on OpenShift 3.11 and 4.0, together with the following storage options: GlusterFS, NFS, and Trident
  • All supported deployment options are listed below

     

Single/MultiLocation(Cloud Provider)KubernetesOS(*)StorageNote

Single Node

All

Sisense kubespray

Ubuntu , RHEL, Centos, Amazon Linux 2

Local second disk

 

Multi-Node

All

OpenShift

RHEL

GlusterFS/NFS/Trident

 

On Prem

Sisense kubespray

Ubuntu, RHEL, Centos

GlusterFS/NFS

 

AWS

Sisense bundled kubespray

Ubuntu, RHEL, Centos, Amazon Linux 2

GlusterFS/NFS/EFS/FSx

FSx uses EBS for Mono ZK

Amazon Elastic Kubernetes Service (EKS)

Ubuntu, RHEL, Centos, Amazon Linux 2

EFS/FSx

 

Azure

Sisense kubespray

Ubuntu, RHEL, Centos

Gluster/ Azure file share

 

Azure Kubernetes Service (AKS)

Ubuntu, RHEL, Centos

Azure Files

 

Google Cloud Platform (GCP)

 

Sisense kubespray

Ubuntu, RHEL, Centos

GlusterFS/NFS/Google Cloud Filestore

 

Google Kubernetes Engine (GKE)

Ubuntu, RHEL, Centos

Google Cloud Filestore

 
  • Sisense has increased the minimum requirements for multi-node clustered deployments from 16GB to 32GB of RAM
  • Configuring an external load balancer is now supported as part of the cloud-native deployment (Setting Up a Load Balancer)
  • The format of labels assigned to the nodes has changed, and now includes the name of the namespace (Sisense and Autoscaling)

Multiple Build Nodes now Supported

  • Sisense supports multiple build nodes when deploying Sisense: you can choose which of the build nodes to be used per data group

Other

  • Export and Import ElastiCube and Live models (Exporting and Importing Models)
  • WHERE clauses were optimized for live queries
  • The Histogram and Filtered Measures certified add-ons are now supported on Linux

Selected Bug Fixes

  • Security issues were resolved
  • Secure flags for cookies are now enforced
  • Sisense Narratives is supported, except for the Pivot widget
  • Some Admin tabs were hidden when the system was configured to use a base URL
  • Issues related to rebranding were resolved
  • Issues with hyperlinks within Pivot widgets were resolved
  • The SSL certificate was not updated during an upgrade process that replaced the SSL certificate

Known Limitations
Widgets

  • Linux supports the new 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 plugins)
    • 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 in Linux
  • Pie and Scatter charts do not highlight filtered slices

ElastiCubes

  • When importing an ElastiCube through the POST /api/v2/elasticubes/import endpoint, the ElastiCube must be 100MB or smaller in size

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
  • Accumulative builds by date using the SalesForce connector fails
  • Google Ads and Google Analytics connectors’ table customizations are not supported
  • Postgres builds may fail due to inaccessible tables

Admin Page and System settings

  • Docker ulimits limit a program's resource utilization to prevent a run-away bug or security breach from bringing the whole system down. The default limit for Amazon AWS is 1024, which is not enough for Sisense to run properly. See Increasing Docker ulimits for more information on how to increase the limit from 1024 to 1024000.
  • If you change the your Sisense DNS name, the Alias, you need to change it in the UI as well and not just in the configuration yaml file
  • Base URL:
    • When using the Base URL configuration, Grafana monitoring is available only after setting it via SSH connection, using the command kubectl -n sisense set env deploy/grafana-sisense F_SERVER_ROOT_URL=<put_url_address_here>/app/grafana
  • 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

  • After 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
  • The following certified add-ons are not supported on Linux:
    • Insight Miner
    • Embed Images

Other

  • Pre/post build plugins are not supported (This is planned for a future release)

Was this article helpful?