Release Notes

Before You Upgrade

Sisense is continually making improvements to the Sisense infrastructure to provide a more robust and scalable system.

Before you upgrade, you should back up your Sisense installation, and review the following topics for a complete explanation of the changes and what features and functionality were impacted:

8.0

8.0.0.10134 - Official release of Sisense V8.0 - August 12, 2019

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 (Documentation)

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 (Documentation)

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 (Documentation)
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 (Documentation)

More Flexibility for Managing Users in Groups

Add users to multiple groups from the Edit User dialog (Documentation)

Security

This version fixes a few security issues and contains some security hardening

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

Limitations

When The AI Exploration mechanism ignores changes applied to background filters over the original Indicator widget from which the exploration is triggered. This means that the end user can see members in the break-by that were filtered out in the base indicator by using a background filter

Selected Bug Fixes

Previews of CSV files with fields of types "Float" or "Real" did not show data as expected
When using custom email servers for Sisense emails, the PDF attachments were not visible in the iPhone native Mail App
In some scenarios, when a user was logged out, SSO JWT did not allow them to log back in
For certain widgets, left-clicking on a value in the widget sent the wrong values to Pulse
When the same table name exists under multiple schemas, in certain scenarios the wrong schema name was displayed in the table settings
In some cases, attempting to duplicate or delete a model returned the “Failed to delete ElastiCube unauthorized” error
In some cases, row counts in Live models did not work for table queries
In a Column chart, when there is a secondary line chart visualization, the Stack & Stack100 options were disabled
In some cases, changing a connection in Live models reset the query timeout and caused dashboards not to load
In some cases, the table positions in the Schema Editor changed unexpectedly after builds
When the application was white-labeled, the Pulse screen displayed some Sisense-specific information
Sharing dashboards with a large number of users (around 200K) failed due to timeouts in some scenarios
The Column chart did not show values when the Continuous Timeline was turned on

7.4.4

7.4.4.10068 - Official release of Sisense V7.4.4 - July 16, 2019

Announcing Breaking Changes

SQL Server windows authentication via the Sisense web application was deprecated. This option is no longer supported while using the web interface. You should use an alternative authentication configuration
If you connected to Google Sheets from the Desktop ElastiCube Manager from Sisense V7.4 and above, and experience build failures in Sisense V7.4.4, redo your connectivity settings in the Desktop ElastiCube Manager for Google Sheets with the same settings to build your ElastiCube successfully

Introducing Augmented Text Deduplication

Accelerate time to insight by streamlining data preparation workflows by automatically deduplicating incorrect or misaligned data
Automatically group similar strings to create custom columns through Sisense’s machine learning algorithms (Documentation)

Other

Export and Import ElastiCube and Live models (Documentation)
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

Selected Bug Fixes

When Sisense was translated to other languages, some items were not displayed as expected
In Sisense V7.2.1, running manual Orchestrator tasks with gulp did not work as expected
In some cases, when importing ElastiCubes using the Psm.exe, the PSM reported the import as successful, even if the import failed
Pivot widgets exported to CSV did not open in Excel or exhibited some issues with missing or doubled data
In Pivot widgets, when subtotals were displayed as the first row on the page, some columns and values disappeared
In Pivot widgets, the Grand Totals disappeared when the table was filtered to display only one dimension
Changes to the ElastiCube that were performed from the desktop ElastiCube Manager were not reflected in the "Last Modified Time” tooltip on the Data page
In some cases, after a session expired, users were redirected to the default Login page instead of the SSO Remote URL
When using the Salesforce connector in the online Sisense Web Application, data was not imported to the table "DatedConversionRate"
In some cases, when using the Snowflake connector, and performing accumulative builds set by a Date column, duplicated records were imported
Export to Excel was not working for users belonging to a group with a name written in Japanese
When the Sisense.ECMS service was down, the status of the Query Proxy service was not displayed correctly
In Pivot widgets, after removing the Sub-totals, the last page of records was not displayed
In Sisense V7.4, in certain scenarios, builds failed due to a short timeout period for custom columns and tables

Limitations

Google Sheets Connector

Sisense does not support special characters in table names when the same ElastiCube was built in both the desktop ElastiCube Manager and the Sisense Web application

7.4.3

7.4.3.10110 - Official release of Sisense V7.4.3 - June 20, 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 (Documentation)
PostgreSQL users can now connect to specific databases in PostgreSQL (Documentation)
Administrators can define account lockout thresholds for their users including the number of failed attempts and how long users are locked out for (Documentation)
The header "X-Frame-Options: sameorigin" on Sisense web pages, which was mandatory on previous versions starting from 7.4.1, has now been made an optional header (Documentation)

Selected Bug Fixes

In some scenarios, the table preview failed for tables with custom columns
Formula parsing in custom queries did not work properly in JVM connectors
PostgreSQL numeric values were not imported to the ElastiCube in all cases
Accumulative builds for Google BigQuery did not work as expected
In some scenarios, scheduled builds defaulted to using legacy connectors
Pivot tables were not displayed correctly when using a break by month with a fiscal year
Export to CSV did not work in Internet Explorer 11 in all cases
The System Configuration page was not displayed as expected when viewed in Internet Explorer 11
In some cases, the dates imported to Sisense were not rendered correctly
When using SSO and a session expired, the user was returned to the default Login page instead of the SSO Remote URL
Pulse alerts were not displayed in Sisense when there was no Internet access
Previews of Excel tables were not displayed correctly for files of 100K or more rows
Some connectors timed out when importing large amounts of data
This version fixes a few security issues and contains some security hardening, including removing the CKEditor library (version 4.4.6) which is no longer used

7.4.2

7.4.2.10063 - Official release of Sisense V7.4.2 - May 27, 2019

New Features and Enhancements

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 (Documentation)
Sisense installation now prevents installations on servers with less than 8GB RAM

Selected Bug Fixes

Previews of tables were not displayed when the table name contained a slash or a backslash
The Custom SQL editor did not recognize slashes
The Custom SQL editor displayed “Query Error” when filtering a column by quotation marks (")
In some scenarios, accumulative builds timed out before completion
In certain connectors, builds in the Sisense Web Application failed after running a build in the desktop ElastiCube Manager
The CSV connector did not import rows with cells containing quotes
Cross-domain embedded iFrames did not work in Internet Explorer when using iFrame white lists
Generic JDBC connections did not show tables when there was no schema defined in the data source
Data alerts were not sent when SSL was enabled
In some scenarios, ElastiCube to ElastiCube connections did not work as expected when SSL was enabled
Special characters were not supported for passwords in the Multi-Node Deployment Wizard
The Pulse page was not translated into Italian
Branded emails were not translated into the chosen language

7.4.1

7.4.1.10044 - Official release of Sisense V7.4.1 - May 5, 2019

Announcing Breaking Changes

Starting from version 7.4, the header: "X-Frame-Options: sameorigin" is added to Sisense web pages. This option is mandatory, and affects users of the embedded IFrame feature. In future releases, this option will be configurable. The header has been made optional starting from Sisense V7.4.3 version.
In rebranded Sisense automated emails, the <%= user %> token is no longer supported. You should remove this token from your templates to ensure your emails appear as expected

New Features and Enhancements

Scheduled reports are sent even if some of the widgets are not loaded in the dashboard (Documentation)
Find functions quickly in the Formula Editor by name or syntax (Documentation)
Non-Admin Redshift users can now connect to specific databases in Redshift (Documentation)
Performance improvements for Live models on top and bottom ranking filters. This is relevant for all databases and MySQL from v5.8 and above

Selected Bug Fixes

Static Access users could not open several sessions simultaneously
Some connectors failed to connect and returned the error "Exception while reading from stream"
Google Sheet tables that contain a date did not display the dates correctly
ElastiCube to ElastiCube connections over SSL did not work as expected
In some scenarios, Indicator widgets appeared blurry in PDF reports
Text values in Table widgets could not be selected or copied
When publishing a dashboard through the REST API, in some scenarios, widgets disappeared from dashboards after republishing
In some cases, logging out of Sisense did not invalidate SSO cookies
New Administrators were not added to the Admin group until after logging out of Sisense

7.4

7.4.0.10158 - Official release of Sisense V7.4 - April 11, 2019

New Certified Models for Multi-Node Deployments

Sisense has certified four multi-node models that can be easily deployed through the Multi-Server Deployment Wizard. Deployment models range from best fit for scale, security, high availability, server redundancy, and fail-safes/load balancing for critical server errors (Documentation)

New and Improved Connectors

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

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 (Documentation)

Other

Designers can locate dashboards according to who they have shared them with (Documentation)
You can now cancel running builds from the Model Editor
The values in Stacked Column charts have been enriched to include:
- Presentation of the contribution of negative values within a stacked column
- Total of values in each column
- Percentage labels on each value in a Stack 100 Column chart

Limitations

In a multi-server deployment, the distribution of ElastiCubes stops after the build node is restarted. The Sisense.Orchestrator service needs to be manually restarted
The Google BigQuery connector supports importing nested data and querying partitioned tables only in ElastiCube models
Oauth is not available when working with the generic JDBC connector that was defined as system user (Documentation)
The Salesforce connector has a different naming convention for custom objects compared to older versions of the Salesforce connector. To avoid any unexpected name changes when updating to the new connector, the Sisense connectivity settings cannot be changed, and you must click Add Data to update your model
The old version of the Aggregated Table add-on does not work as expected in Sisense V7.4 and should be upgraded to the latest version here

Selected Bug Fixes

In some scenarios, the Un-select option in Pie Chart filters did not work as expected
When writing a custom query with a database with a very large number of tables, Sisense responded very slowly
In some scenarios, when trying to refresh connectivity on a table that uses a custom import query. an error message was displayed
Filter items were not updated when a dataset was changed
When previewing data in Sisense, BIGINT values were rounded down, resulting in some values becoming identical
In some scenarios, after making changes in the Connection Wizard, the Refresh Preview icon disappeared
When the Connection Wizard was opened for the Google Analytics connector, the calendar and the date format were not localized
When the Connection Wizard was opened for the Google Analytics connector, when selecting the websites for which to view data, the "Select All / Select None" button was unresponsive.
When attempting to refresh schema or modify Connection Settings, the call to the relevant endpoint failed with an error 500 when the user attempting to perform the operation was part of a group.
Certain special characters in the name of the ElastiCube caused an error when deleting the model
Names of uploaded files showed up as hashed names in the Connection Wizard
In some scenarios, data security was not applied to starred filters
ElastiCubes with certain special characters in their name could not be scheduled to be built
In some cases, the chart widget displayed as empty due to negative values in the data.

7.3

7.3.0.12008 - Service Pack - March 12, 2019

The following issues were fixed:

Duplicate widgets were created in the application database
Canceling many-to-many queries created too many log messages
Added an optional configuration flag to control whether or not to apply data security on filters that have a relationship to the restricted field. By default, data security is always applied
Direct relationships were created for cubes that were modified in the desktop ElastiCube Manager

7.3.0.11022 - Service Pack - February 19, 2019

The following issues were fixed:

Sisense Data page was not displayed as expected when viewed in Google Chrome. For more information, see the post here
Queries with the error: “Threads Stuck waiting for Critical Section Lock on QOT statistics”
IIS did not work as expected and returned the error: “ParserLogger - Non-negative number required”
Pivot tables could not be exported to Excel when a Base URL was defined
Refreshing a schema did not work as expected after importing a new query

7.3.0.10434 - Bug fixes - January 3, 2019

7.3.0.10054 - Official release of Sisense V7.3 - November 13, 2018

Introducing Usage Analytics

Gather insights on dashboard interactions, performance, and viewer activity across your deployment
Filter and drill-into activity of specific users or dashboards to the finest level of detail
Monitor user behavior across dashboards to improve user adoption and engagement
Usage Analytics Overview

Improved Build Logs

View detailed build logs for each ElastiCube build
Download and save your build logs in JSON (Documentation)

New Connectors

Snowflake: Import data into Sisense (Documentation) or connect directly with a live connection (Documentation)
Google BigQuery (Beta): Import data into Sisense (Documentation) or connect directly with a live connection (Documentation)
Salesforce: Import data into Sisense (Documentation)
Google Ads: Import data into Sisense (Documentation)
Google Analytics: Import data into Sisense (Documentation)

New Multi-Node Deployment Wizard

The new Multi-Node Deployment Wizard assists you to install and set up Multi-Node deployments by automating almost all of the configuration process (Documentation)

Rebranding Sisense

Added a note “Powered by Sisense” to the User Profile box under the Sisense version number (this can be removed through the REST API)
If you have rebranded Sisense, Administrators now see the default Sisense Analytics homepage when the Dashboard Administration feature is enabled. Non-Admin users will see the rebranded homepage

Other

From Sisense V7.3 onwards, Sisense uses OpenJDK libraries. Oracle JDK libraries are no longer used by the application
Sisense no longer supports Internet Explorer 10
View a list of your users currently logged into Sisense in the Sessions Table (Documentation)
Delete CSV and Excel files saved on your Sisense server
Edit your connection settings without having to create a new connection (Documentation)
Improved error logs for JDBC connectors
Enhanced workflow for importing with custom queries (Documentation)

Limitations

Snowflake Live does not support the Ranking filter
When changing a connection to a data source, the password is not saved and the next build will fail. The password must be defined again in the Connection Wizard
Following an upgrade, your data models may be displayed in draft mode. Refresh the page until the models return to their correct status. This may take several minutes
The Connection string to Snowflake must include the warehouse and db parameters (Documentation)
In multi-node deployments, the Sisense.Orchestrator service must be restarted if the build node is restarted or shutdown while the Orchestrator is running

Selected Bug Fixes

In some scenarios, Excel files could not be deleted
When previewing data, time was defined by your time zone, not the time zone of the data source
In some scenarios, the Sisense Catalog was corrupted
Users in Active Directory with special characters were not added or could not be located
When importing more users from Active Directory than allowed by your license, no notification was displayed
When using Base URL, build logs were not displayed, and in some scenarios the Data page was blank and a 404 error was displayed
If an ElastiCube had multiple tables with the same connection, and one of the table’s connections was changed, the build failed
When searching for an ElastiCube that appears in the Recent section of the Data page, the page appears blank
Accumulative builds did not work as expected when the data source was another ElastiCube
Rebranding the Marketing area of the Data page did not update the links
In some scenarios, builds took longer than expected
Saving a custom table with an invalid name creates a draft custom table
Columns with geography types were not displayed in the preview of the Data Wizard
Static Range displayed different results in preview and after building the ElastiCube in some scenarios
When building a table with a time field, Sisense did not cast the field as expected leading to failed builds
Builds that included empty tables from Google Spreadsheets failed
Postgres columns with trailing spaces were not imported
Background filters in shared dashboards remained as background and data security rules aren`t applied for its lowest level breadcrumbs
In some scenarios, the "Created by Me" and "Shared by Me" filters were not displayed to Viewers in the Analytics page
When widgets included more elements than colors in the selected Color Palette, white was the default option used for extra elements
LDAP users were not able to authenticate when logging in with a domain name included in the user name
When using SisenseJS without running "renderFilters", prism events were not triggered

7.2.1

Build History

7.2.1.15002 - Service Pack - February 21, 2019

Sisense Data page was not displayed as expected when viewed in Google Chrome. For more information, see the post here
Queries with the error: “Threads Stuck waiting for Critical Section Lock on QOT statistics”
IIS did not work as expected and returned the error: “ParserLogger - Non-negative number required”

7.2.1.14004 - Service Pack - January 4, 2019

Sisense now uses the OpenJDK libraries instead of the Oracle JDK libraries that were previously used

7.2.1.13003 - Service Pack - December 6, 2018

The following issues were fixed:

The connection from IIS to Sisense Zookeeper failed in certain scenarios
A low severity security vulnerability in the NodeJS libraries used in Sisense V7.2.1 was resolved. See the Security Bulletin for more information

7.2.1.12010 - Service Pack - November 28, 2018

The following issues were fixed:

The Data page failed to load when Base URLs were defined
In some scenarios, ElastiCube builds failed when uploading a CSV file
Occasionally, CSV and Excel files failed to upload
In some scenarios, exporting an Excel file caused an IIS process to crash
Color palettes were not updated as expected when customizing them
The default Session Inactivity settings for non-Admins were applied to Admins

7.2.1.11002 - Service Pack - November 7, 2018

The following issues were fixed:

In some scenarios, the Sisense.JVMConnectorsContainer service crashed
Plug-ins were not loaded into Sisense
Some builds failed when connected to Oracle or Amazon Redshift

7.2.1.10226 - Official release of Sisense V7.2.1 - October 22, 2018

Introducing the JDBC Connector

Connect natively to Java applications and databases with the new Sisense JDBC connector (Documentation)

Duplicate Data Models

Create copies of your data models to save them as backups or share them with different users and groups (Documentation)

Dashboard Administration Improvements

View the total amount of Viewers who have opened a dashboard in your account in the Analytics page while in List view (Documentation)
View your most recently opened dashboards on the Recent tab of the Analytics page

Secure Active Directory Connections

Configure secure connections to Active Directory with the LDAP-S protocol (Documentation)

Other

Change your dashboard’s data source, now including live data sources (Documentation)
Change your column’s data type quickly and easily from the column’s menu (Documentation)
The Google AdWords API has been updated to the latest version – v201806. Earlier versions of the Google Adwords API have been deprecated by Google and are no longer supported. For more information about the changes, see Google’s Developers Blog.
Improved performance for calculated fields and tables in some scenarios

Limitations

The JDBC connector does not currently support accumulative builds
Sisense Narratives does not support Pivot widgets with multiple text fields

Selected Bug Fixes

Connections to tables could not be changed if the table was renamed
In some scenarios, dates were not displayed as expected when a Pivot table was exported to Excel
Percentages were not displayed as expected in the Y-axis of Column charts when using the stacked 100 option
In some scenarios, dashboard filters could not be removed
Some users could not access dashboards when the dashboard’s ElastiCube was shared with them
When exporting a Pivot to Excel after drilling into one of the values, the original Grand Total value was displayed
In some scenarios, data could not be imported when Import Relationships was selected

7.2

Build History

7.2.0.12014 - Service Pack - September 4, 2018

The following issues were fixed:

"There was an error reading from the pipe" error could occur under high loads and would require an ElastiCube restart
The Configuration Manager did not work as expected in Internet Explorer
The SQL Connection Wizard was not displayed properly in FireFox
An error occurred when creating a widget that used a live table that was renamed while connected to another table
In some scenarios, when exporting a single dashboard after clicking the Select Dashboards icon, the selected dashboard could not be downloaded
Pivot tables were not exported as expected when the Metadata Translation add-on was installed

7.2.0.11001 - Service Pack - August 20, 2018

Fixed: Cannot perform custom queries when working with Redshift

7.2.0.10498 - Official release of Sisense V7.2 - August, 14 2018

Before You Upgrade to Sisense V7.2

Sisense has made significant improvements to the Sisense infrastructure to provide a more robust and scalable system.

For a complete explanation of the changes and what features and functionality were impacted, see:

Announcing Breaking Changes

Introducing Live Data Models

Manage live connections through easy-to-use data models
Leverage web-based data model features like redo, preview and search on live models (Documentation)
Create multi-table relationships with data from Amazon Redshift and Microsoft SQL Server (Documentation)

New Data Dictionaries

Add tags and description data columns and tables for improved search and understanding in data models (Documentation)

Customize Sisense Mobile

White label and apply your unique branding to Sisense Mobile (Documentation)
Include your logo, colors and splash screen and publish it to your own app store (iTunes & Google Play)
Deliver a unified, branded analytical experience from desktop to mobile

Introducing Sisense BloX

Create beautiful, custom widgets with integrated application functionality through a fully supported Sisense add-on
Add sliders, write-back, or trigger notifications within your dashboard
Design widgets from an easy-to-use JSON editor (Documentation)

Dashboard Administration Improvements

View when a dashboard was last published and modified (Documentation)
Locate dashboards faster by dashboard name, data source, or owner with new search operators (Documentation)

Deployment Enhancements

Configure Sisense settings from the new Configuration Manager, including your web server and application database (Documentation)
Upgrade Sisense and maintain your existing configuration and customizations between versions

Other

Sisense automatically aborts queries where a Many-to-Many relationship may overload the system
Check the last time a user was active in Sisense with user usage data (Documentation)
Set the method for determining Session Inactivity Timeout (Cookie or Session), and set limits to the length of inactive user sessions (Documentation)
Starting from this version, adding the "Secure Flag" for cookies when using HTTPS is the default option
Sisense supports Active Directory users with special characters in their user name
The following Rank functions were added: (Documentation)
- RankDenseAsc
- RankDenseDesc
- RankCompetitionAsc
- RankCompetitionDesc
Sisense now supports SSL certificates in Cert Key format in addition to the PFX format that was previously supported
Additional ports are now in use for internal communication. No additional ports need to be opened in the firewall. (Documentation)

Limitations

Joined results are not displayed when previewing live relationships
Importing an ElastiCube with an identical name to a live model overwrites the live model
REST API endpoints with the model name in the URL will fail (404) in case the model name ends with a dot (.)
When building an ElastiCube on a remote server, the build log is not displayed as expected

Selected Bug Fixes

When applying a filter of the same time resolution on a multi-pass aggregation with a date field, the total was not updated
When sending email reports, "Report Sent OK" was displayed although "Send Emails" was disabled in the System Configuration setting and no email was sent
In certain scenarios, the Date format was not saved in Pivot tables exported to Excel
Users were not redirected to the SSO logout URL as expected when logging out of Sisense
After resetting IIS, in some scenarios, the first query was slow
Users with a special character in their username or user info in Active Directory were not added to Sisense
Build logs did not progress past Step 1 even though the build was completed successfully
The default language for Active Directory users was not imported
The Windows Authentication option was not displayed when connecting to SQL Server
In some cases, Sisense lagged after sharing a dashboard with “Everyone”
Some builds failed when connecting to SQL Server using Windows Authentication

7.1.3

Build History

7.1.3.16003 - Service Pack - March 5, 2019

When using the Google Analytics connector, some builds were not completed successfully.
In some cases, the Sisense orchestrator did not work as expected.

7.1.3.15004 - Service Pack - February 21, 2019

Sisense Data page was not displayed as expected when viewed in Google Chrome. For more information, see the post here
SQL Server connector was not displayed as expected
Queries with the error: “Threads Stuck waiting for Critical Section Lock on QOT statistics”
IIS did not work as expected and returned the error: “ParserLogger - Non-negative number required”

7.1.3.14001 - Service Pack - December 26, 2018

Sisense now uses OpenJDK libraries. Oracle JDK libraries are no longer used by the application.

7.1.3.13005 - Service Pack – October 25, 2018

Fixed: The error "There was an error reading from the pipe" occurred under high loads and required an ElastiCube restart

7.1.3.12002 - Service Pack – September 20, 2018

The following issues were fixed:

When working with Pie charts, the data labels were not always displayed as expected
In some scenarios, filters are being reset after data security is applied

7.1.3.11003 – Service Pack – August 13, 2018

Fixed: "There was an error reading from the pipe" error could occur under high loads and required restarting the ElastiCube

7.1.3.10025 - Official release of Sisense V7.1.3 - July 22, 2018

Selected Bug Fixes

Grand totals did not take data security into account when using an Elasticube set in some scenarios
Values that included special characters, such as ‘$’, were not filtered as expected
Value labels in some scenarios were not displayed as expected
In some scenarios, numeric fields were not imported as expected from Postgres data sources
In certain scenarios, a catalog file would become corrupted resulting in lost build schedules
Updating data security rules did not reset dependent filters selections
In some cases, when republishing a dashboard, widgets which were deleted from the original dashboard appeared for shared users
Custom SQL queries with NOT EXISTS did not return the correct results in some scenarios
When applying a filter of the same time resolution on a multi-pass aggregation with a date field, the grand total was returned
When changing the system’s language, Date filters were not translated as expected
Some values were not displayed as expected when translated to Japanese
When translating Sisense metadata, some custom titles were not displayed in the translated language
In some cases, when downloading filtered data as a CSV file, all the results were displayed

7.1.2

Build History

7.1.2.10076 - Official release of Sisense V7.1.2 - May 30, 2018

Improvements

Fiscal Years can now be defined to start at any month across your system or per ElastiCube (Documentation)
Connectivity settings can be updated for supported web-based data sources (Documentation)
Build settings have been updated to be more intuitive and you can limit the number of rows included per build (Documentation)

Selected Bug Fixes

When sharing a dashboard, if the data source was not previously shared with the user, the user could not view the dashboard
Data Administrators could not add new hierarchies
In some cases, changes that were made by Dashboard Designers to their dashboard’s copy might be republished to all users
In some scenarios, some values were missing when working with Polar charts
When changing column types and refreshing the schema, the column’s type was not recognized
Data Designers could not preview ElastiCubes in some scenarios
In some cases, ElastiCubes with special characters in the table names were not displayed as expected
In some scenarios, the Data page failed to load

Known Issues and Limitations

When changing a connection for a table where the build behavior for a column is Accumulate By, and the column doesn't exist in the new table, the connection change fails

7.1.1

Build History

7.1.1.10089 - Official release of Sisense V7.1.1 - May 6, 2018

Selected Bug Fixes

In some scenarios, an error occurred when adding a data source from the Quick Access list when working with the latest Chrome version (version 66)
Pivot table grand-totals were not translated as expected
When the ElastiCube or server name had a period in its name, dashboard filters were not saved
The auto-complete functionality in the SQL editor in the web-based ElastiCube Manager did not work as expected in some scenarios
Building an ElastiCube from the web-based ElastiCube required more memory resources than expected
In some scenarios, when working with the web-based ElastiCube Manager, the Build button was disabled after a build failure
No table preview was available when restoring the last valid custom column expression
Dashboard filters were not applied on all widgets in some scenarios
In some scenarios, when having many categories, some of the categories' labels were not displayed as expected in Bar and Column charts
In some cases, Pie charts were not displayed as expected after applying a filter
Ticker Indicator widgets were not displayed as expected in some cases
When exporting Pivot tables to Excel, tables with custom currency were not formatted as expected
Max value labels were not always displayed as expected when working with Bar and Column charts
Abbreviated numbers were not translated in Chinese as expected

7.1

Build History

7.1.0.12003 – Service Pack – April 24, 2018

Multiple sessions in the same ElastiCube model are allowed

The following issue was resolved:

In some cases, builds failed when connecting two tables through text fields

7.1.0.11010 – Service Pack – April 12, 2018

The following issues were fixed:

Widgets were not displayed as expected when a new widget was added to a new row in the dashboard
Unable to dismiss the 100% Zoom warning message
Some Date fields formats in Excel were not imported as expected when working with the web-based ElastiCube Manager
Filters were not applied to all widgets the first time they were loaded in some scenarios
“Error in deserializing body of reply message for operation describeSObjects” when working with SalesForce connector

7.1.0.10324 - Official release of Sisense V7.1 - April 2, 2018

Web-Based ElastiCube Manager Enhancements

Improved data modeling experience:
- Organize your data easily with pinned tables
- View related columns from the schema by hovering over their relationships
- Understand your schema with a descriptive legend
- For more information, see Managing Tables and Columns
Impact Analysis
- See what Sisense entities, such as dashboards or Pulse alerts, rely on your ElastiCubes with dependencies (Documentation)
- When deleting an ElastiCube, view the dependencies prior to deleting a cube. Easily map dashboards, widgets and Pulse alerts to an alternative ElastiCube
Save drafts of unfinished custom SQL queries for later and revert back to previous queries (Documentation)
Sort, filter, and sample your data when previewing your tables (Documentation)
Schedule ElastiCube builds from the web-based ElastiCube Manager (Documentation)
Upload Excel and CSV files to the web-based ElastiCube Manager (Documentation)
Define custom SQL queries for Oracle, PostgreSQL, Redshift, SQL, and MySQL databases (Documentation)
Duplicate values straight from the Sisense Web Application without having to copy existing formulas
Import relationships directly from your data source

Dashboard Management

Administrators can access and control all dashboards across their system from the Analytics page (Documentation)

Performance Enhancements

Significant improvement in dashboard load time
Immediate transition when moving from a widget view to a dashboard view
Improved ElastiCube build time and memory consumption, especially for ElastiCubes with custom tables and ElastiCube to ElastiCube imports

Fiscal Years

Easily define when your Fiscal year begins across your system or per ElastiCube (Documentation)

Selected Bug Fixes

Publishing dashboards for a large number of users took longer than expected in some cases
Calendar date filters could become misaligned when using the browser’s native zoom
When drilling down into Date dimensions, the menu was not displayed in the translated language Pulse alert tooltip was not translated as expected
Long labels names are not displayed in widgets correctly in some cases
Auto-Zoom could not be disabled in Line widgets in Sisense V7
In some cases, when sorting a Column chart, the loading indicator was still displayed after the sorting was completed
Values could not be renamed in the Formula Editor in some cases
Labels with different format types for each value were displayed with the in Column charts.
In some scenarios, Table widgets with infinite scrolls in the dashboard were not exported to PDF properly
Certain special characters in the Pivot table name were corrupted when exporting to PDF
When exporting Pivot to Excel, the columns were displayed in a different order in some cases
Sisense Web Application did not load as expected and returned the error ‘503 Service Unavailable’
After upgrading to Sisense V6.7.1, users authenticated with SSO were redirected using the HTTP protocol instead of HTTPS
The ElastiCube server crashed with “CMapiLib.mapi_result” error in some scenarios
When working with the online ElastiCube Manager, custom import queries were removed from Redshift tables after duplicating the table
Sisense might not work as expected in high availability configurations when the primary application database is down

Limitations

Using the web-based ElastiCube Manager is supported in high availability environments with limitations described here
Changing the fiscal year after a dashboard or widget filter with a related date field is in use might lead to incorrect results. To resolve this, the date filter should be removed and added again
Tables cannot be refreshed when working on a remote ElastiCube. To refresh tables, the ElastiCube must be located on the same machine as the web server

7.0.2

Build History

7.0.2.14004 – Service Pack – April 22, 2018

The following issues were fixed:

Growth function did not work as expected in Continous Line charts
Unable to perform drilling on charts when working with Continuous Timeline charts in some scenarios
In some cases, the drill breadcrumb was not working as expected when working with Continuous Timeline charts

7.0.2.13001 – Service Pack – April 2, 2018

The following issues were fixed:

Continous Timeline charts did not behave as expected when the user changed their time zone
Unable to perform drilling when the first column in a Pivot table is disabled

7.0.2.12002 – Service Pack – March 23, 2018

The following issue was fixed:

When exporting Pivot tables to Excel, tables with currency were not formatted as expected in some cases

7.0.2.11001 – Service Pack – February 22, 2018

The following issues were fixed:

Dashboard filters on Date fields might filter the wrong dates/time due to time zone differences
Exclude Date filter members were not displayed as grayed out

7.0.2.10036 - Official release of Sisense V7.0.2 - February 12, 2018

Selected Bug Fixes

Ticker Indicator widgets were not displayed as expected when the Min value was negative
In some scenarios, the table preview was not shown in the web-based ElastiCube Manager
High CPU consumption occurred when working with the Weeks resolution in some scenarios
When embedding Sisense, the left Navigation Panel was empty although the panel was set as visible
Oracle connector did not allow Service IDs with numeric values in the web-based ElastiCube Manager
Some Oracle tables could not be added in the web-based ElastiCube Manager in some scenarios
Data Designers could not access the Data page when SSO was enabled
Sisense.Repository service did not start after rebooting the machine in some cases
Pulse KPI history events were not displayed as expected in the History tab in some cases

7.0.1

Build History

7.0.12003 - Service pack - January 31, 2018

Added configuration attribute to determine whether SAML SSO groups are synchronized after each login

7.0.1.11006 – Service pack – January 24, 2018

Fixed SisenseJS widget load issue

7.0.1.10061 – Official release of Sisense V7.0.1 – January 15, 2018

Announcing Breaking Changes

New Features and Improvements

Support for Hours and Minutes time resolutions (Documentation)
New Live Hive connector (Documentation)
Support for formatting and data masks when exporting to Excel (Documentation)
New dashboard color palettes. The new palettes are Pastel Rainbow, Meadow, Midnight Light, and Soil (Documentation)
Backslash (\) escape key supported when searching for special characters in text filters (Documentation)

Selected Bug Fixes

Dashboards embedded in iFrames loaded Navigation Panels that were hidden
Google Spreadsheets builds could fail on empty tables
MySQL Live connections did not support comments
After disabling Sisense Pulse, some charts still displayed the ‘Add to Pulse’ menu option
'ww dd' formatting didn't show the first day of the week in aggregated week dimensions
Break By values for Column and Bar widgets were not sorted as expected
SAML SSO users with uppercase letters in their email addresses could not log in
Widget descriptions were not always presented as expected
Some formulas and quick functions could not be used as arguments in other arguments
Column chart value labels were not always displayed above the bar as expected

7.0

Build History

7.0.0.21003 - Service pack update including several bug fixes - December 27, 2017

7.0.0.20135 - Improved relationships workflow, performance enhancements, and bug fixes - December 19, 2017

7.0.0.10700 - Bug fixes - November 30, 2017

7.0.0.10065 - Official release of Sisense V7.0 - October 30, 2017

Before You Upgrade to Sisense V7.0

Are you upgrading from a pre-6.7 version of Sisense? If so, there were significant changes to Sisense's infrastructure including upgrading to a newer version of its application database (MongoDB), which supports the Sisense Web Application

If you are upgrading from a version earlier than Sisense V6.7, see the Sisense Upgrade Guide before upgrading to Sisense V7.0

Introducing the New Web-Based ElastiCube Manager

Sisense V7.0 offers a new way of working with your data. To familiarize yourself with some of the changes, check out Getting Started: New ElastiCube Manager.

Web-based ElastiCube Authoring and Management

Model your data from an intuitive new interface (Documentation)
Create and manage ElastiCubes straight from your browser (Documentation)
Share ElastiCubes and collaborate with others using two new roles:
- Data Administrator: Can access the Admin page of the Sisense Web Application from where they can manage all ElastiCubes and Live connections across the system
- Data Designer: Can create and edit ElastiCubes they created or were shared with them. (Documentation)
New Data Page to view and manage all Elasticubes on the web (Documentation)

Improved Data Modeling Workflows

Locate tables and fields faster with highlighted search results (Documentation)
Manage tables and fields settings directly from the navigation menu
Improved Custom SQL editor for creating custom tables and columns
- Intuitive parsing that highlights SQL and functions
- Related functions grouped together
- New functional categories for aggregations and keywords
- Find and replace text in your SQL statements
Create and preview relationships from the new Relationship window
Undo and redo schema changes as necessary from the dashboard menu

Field Suggestions

Suggestive technologies displays field suggestions so that Designers can quickly create meaningful visualizations (Documentation)

Dashboard Visualization & Performance Enhancements

Improved the dashboard loading experience
Deep dive into the Pie Chart’s Others slice to display a full breakdown (Documentation)
Improved X-axis navigator and new Y-axis navigator support
Interactive legends that highlight selected data when you hover over them and hide data when clicked

ElastiCube Enhancements

Automatic Many-to-Many avoidance in scenarios where a dashboard filter caused a Many-to-Many relationship

Administration Enhancements

Review active features and user allocation for your account from the Licensing Utilization page (Documentation)
Access your Server Console settings from the Admin Console (Documentation)

Data Connectors

New live connector to Oracle

Sisense Mobile

Monitor important KPIs and create alerts from Sisense Pulse
Review your latest Sisense Pulse notifications
Share your widgets and insights using native mobile screen sharing
Enhanced dashboard experience with new widget tiles and a fresher look
New navigation area to easily move between dashboards, Pulse and notifications
Leverage popular Sisense plugins on Sisense Mobile

Other

Customizable Base URLs that allow you to define Sisense hostnames as a subfolder of a domain, for example: www.acme.com/reporting (Documentation)
Read preference options are supported for application database replica sets in High Availability configurations (Documentation)

Selected Bug Fixes

Negative numbers are not displayed on bar and column charts
Some buttons in Sisense V7.0 were not translated as expected
Filter mode occasionally changed from single to multi-selection when the viewer was not allowed to see the published value
Scheduled reports were not sent to users in the “Everyone” group
Some Value labels were overlapping each other in charts
Continuous timelines on charts were not rendered as expected in some cases
Scatter Chart Y-axis were not always sorted as expected
Heavy Line charts took longer to load than expected
X-Axis titles disappeared after drilling down
Dashboard filters were not being updated when changing the dashboard data source in some scenarios
Pie charts slices were duplicated after applying filter changes in Sisense V6.6
Accumulative builds on MongoDB date fields were slower than expected in certain scenarios
Builds occasionally failed when working with Postgres in certain scenarios
Users could not change connectivity settings on ElastiCubes for certain connectors after downgrading the Postgres connector
Importing CSV folders failed when the original file was removed
‘Specified cast is not valid’ build error returned when importing data from a decimal field 26 digits of precision or more
Change Connectivity Settings window in Sisense V6.7 was not displayed as expected when changing the settings for the Generic ODBC driver

Limitations

Sisense Field suggestions are updated once a day and might take from a few seconds to several minutes to run. During that time, suggestions might not be available.

Downgrading to an Earlier Version

After upgrading to Sisense V7.0, if you decide to downgrade, keep the following in mind:

The ElastiCube’s layout in the new ElastiCube Manager’s schema will be lost. The tables will appear in the ElastiCube Manager stacked on one another until you reorder them. All relationships are maintained, only the layout is lost.
Tables that are part of ElastiCubes that were edited in the new ElastiCube Manager will be displayed under the Live Data Sets section of the Data Sources page in the Admin console. These tables can be deleted from the Live Data Sets section without impacting your ElastiCube. Note: The tables will not be displayed as Live Connections when adding new data to an ElastiCube.

6.7.1

Build History

6.7.1.17004 - Service pack - May 23, 2018

In some cases, data security was not working as expected when working with fields from tables which are not connected within a schema. See the Security Bulletin for more information

6.7.1.15016 - Service pack - January 7, 2017

Sisense has made several security improvements to the SSO JWT feature, see the Breaking Changes section below for more information
Sisense has implemented several features for improved security of Sisense web pages, and now supports additional configurable parameters for security hardening of web pages (Documentation)

The following bugs were fixed:

The Sisense application database (MongoDB) could be corrupted following a system restart due to a MongoDB bug
Exporting Pivot tables to Excel might fail in some systems. When a reverse proxy or load balancer is combined with SSL, additional configuration is required (See Step 6 in Setting Up SSL)
Email reports failed and returned the error ("could not connect to the ElastiCube")
The left Navigation Panel was loaded by the browser in embedded environments although the panel was not visible
The SiSenseRepository service failed to restart in some scenarios

6.7.1.14504 - Hotfix - December 19, 2017

The following security vulnerability was resolved: In some cases when a pivot table was exported to an Excel file, the wrong data security rules were applied

6.7.1.14018 - Service pack - November 29, 2017

The Sisense Web Application now supports Dutch

The following bugs were fixed:

In some scenarios, the build time might gradually increase over time
Export Pivot to PDF ignores the word wrap definition
Categories in Pie charts may be duplicated after applying filter changes in some scenarios
Pulse might affect the dashboard load time in some cases

6.7.1.13022 - Service pack - November 6, 2017

Sisense has enhanced the pagination capabilities of Custom REST connector. See Pagination for more information

The following bugs were fixed:

Exporting Pivot tables to Excel failed in some cases
Dependant filters could not be reordered
In certain scenarios, Sisense could not authenticate users that opened multiple sessions concurrently
When using JWT SSO with username authentication, Administrators could not see the ElastiCubes list
Unable to perform drilling when working with the mobile app in some cases
Occasionally, accumulative builds performed on the MongoDB date field performed slower than expected
In Sisense V6.7, the Connectivity settings for generic ODBC connectors could not be changed

6.7.1.10043 - Official Release - September 4, 2017

Announcing Breaking Changes

Release Summary

Improvements and bug fixes

New Features and Improvements

Improved Indicator widget styling added to the JavaScript API (documentation)
New secure flag for cookies (documentation)

Selected Bug Fixes

The ‘Others’ slice in Pie charts was not abbreviated as expected
Changes to font colors in Text widgets were not displayed in Internet Explorer 11
Occasionally when updating a dependent filter via a member selection in a widget, the filter type changes from single to multi-selection
Filters and some nested objects were not translated as expected by the metadata aliasing mechanism after implementing custom translations for the Sisense Web Application
YTD/MTD/QTDSUM functions in widgets without a date field could return incorrect results when used in conjunction with dashboard-level date filters
Importing .ecdata files with data type mismatches could result in a server crash
Polar charts were not displayed correctly when the same dimension was included in Categories and Break By

6.7.0.12010

Build History

6.7.0.12010 - Hotfix #2 - August 20, 2017

6.7.0.11001 Hotfix #1 - August 15, 2017

Occasionally, dashboards were not loaded as expected. This issue is related to cookie expiration and can be resolved by logging out and logging back into the Sisense Web Application.

6.7.0.10573 - Sisense V6.7 official release - August 6, 2017

Release Summary

Official release of Sisense V6.7

Before You Upgrade to Sisense 6.7

Sisense has made significant changes to its infrastructure including upgrading to a newer version of its application database (MongoDB), which supports the Sisense Web Application.

To make your upgrade as seamless as possible, see the Sisense V6.7 Upgrade Guide before upgrading to Sisense V6.7.

Breaking Changes

New Features and Improvements

Enhanced Sisense Reports and Pivot Exporting

Export pivot tables to Excel while maintaining your pivot’s layout and structure (Documentation)
Export pivot tables into customizable, multi-page PDF reports (Documentation)

Sisense Narratives

Add automatically generated text to popular widgets that communicates your analytics and provides insights of your data
See Sisense Narratives for more information
This feature is available for customers who purchased the Natural Language Package package. For details contact your CSM.

Plug-in Management

Manage your plugins from a centralized UI in the Sisense Web Application
Control which plugins are enabled or disabled
See Managing Plug-ins for more information

Sisense Monitor

Easily monitor information about your system, including system utilization (CPU, memory and disk space), Elasticube build times, dashboard query times, and more.
See Sisense Monitor for additional information.
This feature is being released gradually and has a waiting list. For more details regarding this service, contact your CSM.

Data Connectors

Google Analytics connector enhancements (Documentation)
- Support for segments, filters, and sorting
The following data connectors are now available in beta
- Sharepoint
- Microsoft Dynamics NAV
- Contact your CSM for the latest beta connectors

Sisense Mobile

Drilling is now natively supported in Sisense Mobile
Focus on a single widget to easily view and interact with the data using mobile app gestures such as (two fingers) zoom in/out
SSO support
See Viewing Dashboards on Mobile Devices for more information.

ElastiCube Engine

Enhancements to the memory Garbage Collection mechanism provide up to X10 performance improvements under high-load & memory intensive circumstances

Improved Application Database Security

Authenticated access to the application database
HTTPS support for connections to the application database
Access to the application database is limited to the local host. You can add access from external IP addresses, if necessary (Documentation)

Other

New Running Sum Function – Accumulate a running total of a value. Now available in the quick function menu and the formula editor as RSum()
ElastiCube sets now include a failover option. You can define a cube that will be the failover option for an ElastiCube set, and will only be used if none of the other cubes in the set are available (Documentation)
Reporting enhancements for scale - identical reports are sent together to reduce server load and support higher PDF generation loads

Select Bug Fixes

In some cases, the Sisense Web Application could not locate the ElastiCube associated with a dashboard
When a dashboard was not imported successfully, no error message was displayed
Some custom REST connectors were displayed as Live connectors when adding a live connector
When browsing locally in Sisense V6.4.1, a blank page was displayed when opening the Sisense Login page
Refreshing the connectivity settings deleted custom import queries
The Sisense MongoDB ODBC connector V2.2.1 could only import 4096 rows
When a broken value was present in Column, Bar, Line, or Area charts, the Drill Into option was not displayed from the dashboard
In some cases, the text widget may not appear as expected in the Sisense Mobile app
The ElastiCube server crashed when importing an .ecdata file in some circumstances
Build failures when importing data from Google Analytics that generated error 403: Rate Limit Exceeded were resolved
When implementing localization, the POST and PATCH Settings/Globalization endpoints in the REST API did not update the date and number formats as expected
Text widgets with background colors in multi-column layouts did not display as expected
In FireFox, bar and pie charts did not respond when hovering the mouse of the widgets
The ElastiCube & Data Sets page loaded slowly when there are large amounts of ElastiCube Sets
In some cases, custom expressions did not display strings correctly in the Preview window in the ElastiCube Manager
Build errors that resulted in "Could not connect to 127.0.0.1:50XXX" (or higher port number) errors
In high availability environments, Orchestrator-related build issues

Limitations

Exporting a Pivot table to PDF is supported for up to 10,000 rows only and the following plugins are not support:
1. Embed images to Pivot tables
2. Conditional format Pivot foreground
3. Embed a sparkline chart into a Pivot
When exporting a Pivot to Excel, formatting and data-bars are not supported
Running Sums (RSUM) are not supported on live data sources
Grand-Totals break the entire query (widget error) when used in conjunctions with the function
Sub-Totals are aggregated as an independent series, which is distracting and logically inaccurate
Sisense V6.7 does not support FIPS 140-2. This issue is currently planned to be resolved in Sisense V7.0
During the upgrade process for high availability deployments, the following files are overwritten:
1. default.yaml
2. Sisense.WebQueryService.exe.config
3. Mongodbconfig.conf
4. Configuration updates performed on these files, will need to be reconfigured following the upgrade

6.6.1.12014

Release Date: May 19, 2017

Release Summary

Improvements and bug fixes

New Features and Improvements

Sisense Pulse

Define alerts for more widgets, including Line, Bar, Area, and Column charts (Documentation)
New ‘Between’ condition added for data alerts
Added JavaScript customization support for Pulse tiles and Pulse page (Documentation)

Performance Enhancements

Significant improvements to dashboard load times due to optimizations in Indicator and Text widgets

Data Connectors

Sisense has significantly upgraded several data connectors:

Facebook
- Facebook has been split into two connectors, Facebook and Facebook Ads
- If you previously connected to Facebook Ads tables with an earlier version of the Facebook connector, you can continue to connect to those tables by changing the connectivity settings for those tables. For more information, see Change Connectivity Settings
- Easily add tables without custom SQL
- Automatic retry mechanism for Facebook Ads to improve build success
MongoDB
- Support added for MongoDB 3.4
- For more information, see Connecting to MongoDB
Oracle
- Support added for Relations and Synonyms
Generic ODBC
- Reduced data import times
- Customizable ODBC connections to support more data sources (Documentation)
Custom REST
- Define schema maps for data sources (Documentation)
- Note: New procedure for upgrading Sisense when using Custom REST connectors (Documentation)

Selected Bug Fixes

In certain scenarios, the Gauge and Indicator widgets were not displayed as expected
In some browsers and devices, when hovering over certain parts of a widget, the tooltip was displayed in another part of the dashboard
In some instances, multiple copies of some email reports were sent to users
When changing connectivity settings on Google Analytics tables, all the views were selected by default
Extra delimiters at the end of CSV headers caused the build to fail
RedShift connector occasionally converted Float types to Strings
Some dashboards were not displayed as expected when published to thousands of users at a time
Authenticated users over SSO could not connect to Sisense using multiple devices, concurrently
Some data connectors might not be available after restarting your system
TempCloudML folder size was not restricted in disk space
Pie Chart might display a grayed out image when no results are returned

6.6.0.10327

Release Date: April 18, 2017

Release Summary

Official release of Sisense V6.6

New Features and Improvements

Introducing Sisense Live Connect

Access, govern and visualize live data directly from SQL Server, MySql, Postgres, and Redshift for an immediate view of your data
Present live and ElastiCube data in the same dashboard for a more complete analysis
Refresh widgets with live data automatically or manually from the Sisense Web Application
For more information, click here

Enhanced Sisense Reports

Transform dashboards into professional, and easy-to-read PDF reports
Export Table widgets into customized multi-page PDF reports
Control how dashboards look and feel with predefined paper sizes and customized headers and footers
Preview reports from the Report Settings window before sharing
For more information, click here

New Sisense Migration Capabilities

Easily copy dashboards across environments from the Sisense Web Application
Import and export multiple dashboards in a single .dash file
For more information, click here

Internationalization and Localization

Sisense supports multiple languages on the same Sisense server
Users can select their preferred language from the Sisense Web Application
Translate more Sisense metadata including widget titles, dashboard names, and folder names (Documentation)
Define default languages for new users and groups
Italian now supported

Security

Improved security for Sisense user passwords which are now encrypted with a stronger encryption methodology

Dashboard Enhancements

Perform operations (export/delete/copy to server) on multiple dashboards and folders at once
Support for filters from multiple data sources in the same dashboard

Mobile Filters

New filtering functionality included in the Sisense mobile app.

Data Connectors

Bing (Documentation)
Box (Documentation)
Google AdWords API has been updated to the latest version, v201702. Google Adwords API v201607 supported by Sisense v6.5.1 and earlier has been deprecated.
ServiceNow, Youtube, Youtube Analytics are available for general release
Accumulative builds for numeric data supported for Facebook, DynamoDB, HubSpot
Improved rate limitation handling for Facebook
Sisense now supports the following for Splunk:
- Importing the latest artifact from a list instead of the first (oldest) one
- Importing data from specific Splunk apps

Other

ElastiCube performance enhancements including faster queries when used in conjunction with Rank filtering, Statistical functions, and Distinct Count
Many more REST API capabilities (Documentation)
More PSM.exe commands added for automating ElastiCube model changes (Documentation)
Windows 2016 is now supported

Selected Bug Fixes

In some cases, builds failed with the message: “Failed to Load Elasticube <name of the EC> Process” for several build types and during various build stages
In certain scenarios, builds failed with the message “Connection Lost”, during the calculation of custom tables
Occasionally, the Dashboard navigation tree did not load as expected or after a significant amount of time
Inner arrays in Custom REST Connectors were not handled as expected for certain data sources
Importing tables from Google Analytics failed in some cases with the message: “GA analytics query returned wrong results” thrown by the data source
The full Google Analytics paths were not displayed in tooltips in the ElastiCube Manager
Exported CSV files with certain escape characters were not displayed as expected
When applying date-related filters to Calendar Heatmaps, the widget was not displayed as expected
When changing connectivity settings, Change Source Provider did not change the source for each table for a data source
Calendar heatmap widgets were not displayed correctly when uBlock was installed
The GET /elasticubes/{elasticube}/Sql endpoint with certain queries returned a parsing error
The POST /elasticubes/ attach and detach endpoints did not work as expected
When changing the Min and Max values of a Gauge widget, the values were not updated in certain scenarios
After upgrading to Sisense V6.5, some existing Active Directory users experienced login issues

Limitations

6.5.2.11007

Release Date: January 22, 2017

Release Summary

Improvements and bug fixes

Announcing Breaking Changes

New Features and Improvements

New Data Connectors

QuickBooks Desktop (Documentation)
Xero Accounting (Documentation)
Exact Online (Documentation)
Microsoft Dynamics CRM (Documentation)
Microsoft Active Directory (Documentation)
Gmail (Documentation)
Stripe (Documentation)
ServiceNow (Documentation)
Box (Beta) (Documentation)

Custom REST API Enhancements

The Sisense Custom REST API now supports:

Nested objects in Post requests
Several new pagination options
CSV, XML, and JSON responses
For more information click here.

REST API User Authentication

Sisense has removed the REST API token from the Admin page. This token is used for REST API v0.9 authentication methodology. While this methodology is still supported and available through the REST API, Sisense recommends implementing the REST API v 1.0 methodology, as described here.

For information about retrieving a token through the REST API v 0.9 authentication methodology, click here.

Selected Bug Fixes

Sisense Pulse notifications were not sent from remote ElastiCubes
In some scenarios, since Sisense v6.4.2, custom tables took longer to build than expected
When building ElastiCubes with accumulative builds in Sisense v6.5, under certain conditions the build time was longer than expected
Tables were not loaded as expected when connecting to ElastiCubes with Chinese names through the Sisense ElastiCube connector
After importing data through the SalesForce connector, any new fields subsequently added were not imported into the ElastiCube
Title casing was applied to the main title of Indicator widgets even when written in all uppercase letters
In some configurations, new fields were not displayed in the Data Browser when creating a widget or filter
When embedding the Sisense Pulse page, the page was not displayed as expected
When applying data security to a field, only the top five search results were displayed when searching for an accessible value
Changing the default language to Russian did not change the language displayed in automatic emails
In Sisense v6.5.1, background filters were not displayed

6.5.1.10075

Release Date: January 1, 2017

Release Summary

Improvements and bug fixes

Improvements

Pulse functionality improved to send alerts to Sisense mobile users by default
Greater flexibility added to the Custom REST @today parameter through the TodayFormat key
POST /dashboards/{dashboardid}/widgets endpoint creates widgets and displays them in the specified dashboard in a single call

Selected Bug Fixes

Exporting Text widgets to PDF in Sisense 6.5 returned unexpected artifacts
Line Charts exported to PDF in Sisense 6.5 PDF were not displayed as expected
The PASTYEAR function returned the wrong year when the Weeks dimension was applied
In some scenarios, the secondary value of an Indicator widget was not displayed
Tables exported to CSV with line breaks and commas were not displayed properly
Pivot Tables exported to CSV may return unexpected results

6.5.0.11013

Release Date: November 29, 2016

Release Summary

Official release of Sisense V6.5

Announcing Breaking Changes

New Features and Improvements

Introducing Sisense Pulse

Create alerts for data and system events and be notified via email, mobile, built-in feed, or across 3rd party platforms like Slack and Zapier
Allow Sisense to intelligently identify anomalies in your data based on machine learning algorithms
Easily monitor important KPIs from multiple dashboards from the new Sisense Pulse page
For more information, click here.

New Conditional Statements in Widgets

Conditional statements are now supported in widget formulas using IF and CASE functions. (Documentation)

Box & Whisker Plot Widget Added

Sisense enables you to visualize data on a box & whisker plot. This widget provides an intuitive graphical representation that summarizes data and displays the results in a single graph. Box & whisker plots allow for comparing data from different categories offering deeper data insights. (Documentation)

Accumulative Builds Enhancements

Query ElastiCubes during accumulative builds
Automatic roll back to your last successful build if an issue occurs

New Data Connectors

Facebook (Documentation)
Twitter (Documentation)
YouTube - Beta (Documentation)
YouTube Analytics - Beta (Documentation)
DynamoDB (Documentation)
QuickBooks Online (Documentation)
HubSpot (Documentation)

Additional 21 new beta connectors. Click here for the complete list.

Enhancements to Existing Connectors

Custom REST
- Support added for the POST HTTP method and HTTPS redirect URLs
Google AdWords
Support added for unicode character-sets and floating point data types
Salesforce: Support added for:
- Salesforce's latest TLS encryption protocol
- Accumulative builds
- Salesforce sandbox environments
- Custom SQL statements when importing tables
- SOQL statements when importing tables
Splunk
- Support added for the new Splunk SDK (2.0)

Support for Multiple Active Directory Domains

Sisense now supports users and groups from multiple Active Directory domains. (Documentation)

SSO Enhancements

Support for SSO authentication using SAML 2.0
Sisense has added support for SSO using SAML 2.0 to allow easy integration with SAML-based authentication systems. This is provided in addition to the previously supported SSO using JWT. (Documentation)
Support for SSO authentication using User Name
Sisense now supports SSO authentication using a user name in addition to email addresses.
Support for SSO authentication over JWT without enforcing jti attribute
Sisense allows you to set a lower security level when using JWT SSO. You can configure the Sisense server to not enforce a mandatory jti attribute through the Sisense REST API.

Sisense Web Application UI Enhancements

Enhanced Sisense Web Application UI with a sharper, fresher look

New and Improved Sisense Mobile App

The Sisense Mobile App for Android and Apple-supported devices offers improved dashboard performance and the ability to receive notifications from Sisense Pulse. (Documentation)

AngularJS Support Enhancements

In addition to supporting Angular 2.x, Sisense V6.5 adds support for Angular 1.x. This enhancement allows you to embed SisenseJS on sites in which Angular 1.x and 2.x have been implemented. For more information, click here.

System Requirements

Sisense 6.5 requires .NET version 4.5.2. When you install or upgrade to Sisense 6.5, .NET version 4.5.2 is installed if it was not previously installed. For offline installations, you must install .NET version 4.5.2 prior to installing Sisense.

Selected Bug Fixes

In some cases, the Formula Editor did not recognize parentheses as legal expressions
The Area Map and Indicator widgets were not translated when switching between languages in the Sisense Web Application
When importing tables from an ElastiCube through the ODBC driver, queries were not displayed in the Preview area
Emails were sent an hour later than scheduled following changes to daylight savings
When creating new dashboards or changing a dashboard's ElastiCube, the full name of the ElastiCube was truncated in the dashboard selection menus
Pie chart labels were partially displayed after drilling down
Very large tables imported through the Zendesk REST Connector may cause a build to fail
When importing tables through the Hive ODBC driver, queries were not displayed in the Preview area
Drilling into a dimension with a one filter, and then drilling into the same dimension with another filter displayed the results of the first filter applied
Widget animations in Internet Explorer 10 did not run smoothly
Widgets labels and legends were partially displayed in Internet Explorer 10
In some cases, the ElastiCube-to-ElastiCube ODBC driver timed out during builds where large amounts of data were imported

Limitations

6.4.2.11006

Release Date: September 26, 2016

Release Summary

Improvements and bug fixes

Improvements

New Data Connectors

Native Sisense ElastiCube connector with significantly faster performance than ODBC. (Documentation)

Other

Weeks time resolution support has been expanded to all time-related functions
New dashboard color palettes for color blind users (Documentation)
Improved Data Security page load time
Enhanced performance for Distinct Count query
Sisense now supports using more than 10 arguments when using R in formulas

Selected Bug Fixes

In some scenarios, builds failed due to simultaneous builds connected to the same data source
Email reports were not sent as expected due to deleted dashboards with scheduled reports
European Date fields in Excel were not imported as expected into ElastiCubes in some formats
Formula validation returns an error in some cases when a newline character is present
When inserting a link in a Text widget, you could not open the link in new windows as expected

6.4.1.13002

Release Date: August 30, 2016

Release Summary

Improvements and bug fixes

Announcing SSO Breaking Changes due to Security Hardening

To improve security, when creating a JWT request for SSO, the jti attribute is now mandatory.

For more information, click here.

Improvements

Internationalization and Localization

Metadata localization (Documentation)
The system language can be controlled directly from the Sisense Web Application Admin page (Documentation)

Custom REST API

Support for accumulative builds (Documentation)
Authentication details can now be controlled on a connection basis via the UI (Documentation)

Data Connectivity

Support for Snowflake ODBC Driver (Documentation)

Security

When updating your Sisense password, Sisense has implemented a new password policy. Passwords must meet the following requirements:
- Contain at least 8 characters
- Include at least one letter, number, and special character
- Not match your previous password
The ElastiCube metadata file (ElastiCube.xml) is now encrypted

Other

Sisense Shell (psm.exe) now supports refreshing all tables in an ElastiCube (Documentation)

Selected Bug Fixes

Some new widgets did not display any data and returned the error “Widget has now raw query result. Query simulation cannot take place."
In some scenarios, email limitations were ignored and updates were sent after every build
Dynamic Conditional Coloring does not update after filtering
Occasionally when updating a parent filter, the refresh animation continued to be displayed for nested filters
When signing into Sisense, new users with Active Directory that entered the wrong credentials received the error message “Problem during operation”
GB (Great Britain) was not displayed properly in map visualizations

Limitations

6.4.0.30091

Release Date: July 27, 2016

Release Summary

Official release of Sisense V6.4

Announcing Breaking Changes

New Features and Improvements

Introducing High Availability with Sisense

Ensure uptime for mission-critical environments
Scale out components for high concurrency scenarios
Failover for every component
For more information, click here

Introducing SisenseJS

Load Sisense runtime anywhere through the Sisense JavaScript library
Load or create dashboards in runtime without iFrames
Render all/part/new widgets in any DOM container
For more information, click here

Internationalization and Localization (i18n and l10n)

Sisense now supports the following languages in the Sisense Web Application:

Chinese (Simple), French (France), German, Japanese, Portuguese (BR), Russian, Spanish (ES), Spanish (LA)

For more information, click here.

Custom REST Connector

Connect to open 3rd party RESTful data sources and import data into Sisense with Sisense's Custom REST Connector. (documentation)

In-Chip Enhancements

Enhanced cross-process memory management
Enhanced memory eviction algorithms
Increased performance in high-concurrency environments

Other

Week time resolution
Updates to the following connectors:
- MongoDB (Download)
- Hive (Download)
- Google BigQuery (Download)
To update your connector to the latest version, uninstall the current version of the connector. Then, download and install the latest version.

Selected Bug Fixes

Scheduled email reports were occasionally sent twice to subscribed users
Custom queries returned empty tables in some scenarios
Timeout errors were returned when importing data from an ElastiCube to another ElastiCube through the ODBC connector
Sisense failed to install when installing IIS Express after installing IIS
The POST /Palettes API did not always display new colors
Some characters were displayed incorrectly when opening CSVs exported from Sisense in Excel
An error occurred when changing the source folder of CSV files imported into Sisense
Import/Export dashboard API in the interactive API reference page did not work as expected
When loading Sisense after several hours without use, the dashboard list was not always loaded
In some scenarios, widgets were not refreshed after deselecting date members that you have previously selected
Custom SQL queries were not displayed in the Connectivity Settings page for imported ElastiCubes
Not all tables were imported from Google BigQuery when importing large amounts of tables
MongoDB ODBC connections did not display the query in the preview screen
Dashboard reports from ElastiCube Sets were not sent after a build is complete in some cases
100% zoom warning message was displayed even when the browser is set to 100%
Sisense version number overlapped the browser scroll bar on the home page of the Sisense Web Application

Limitations

6.2.5.141

Release Date: June 7, 2016

Release Summary

Improvement and bug fix release

Downgrade & Compatibility Limitation

Some ElastiCubes that have been used in V6.2.5 will not work with older versions of Sisense. In this case, they will have to be rebuilt with the older version. For additional information contact us through our Help Center.

Javascript Changes

Following infrastructure improvements in our JavaScript framework, some changes might affect your plugins. Additional information can be found in the Developer Release Notes

Improvements

Support for custom email servers (Documentation)
New help section in the menu bar of the Sisense Web Application with links to the Sisense forums and documentation. To redirect users to your documentation, click here.

Selected Bug Fixes

Bar/Column chart legends do not match the order of the data displayed in the widget
Dashboards shared with Admins group are not displayed in the administrator’s dashboard panel
When creating a new dashboard with a long name, the full title was not displayed. You can now view the full title in the tooltip
When using the ‘Between’ condition in a numeric filter, the 'from' value was displayed as the 'from' and 'to' values
Filters pane can’t be minimized when embedding dashboard on iPads
When clicking the menu or filter buttons in some tablet devices, the dashboard is moved off screen.
When refreshing a widget, the 'Widget affect dashboard filters' checkbox is cleared even if selected previously
ElastiCube set permissions defined through the UI were not always saved
Setting ElastiCube set permissions via the API prevented designers from creating dashboards.

6.2.2.35

Release Date: May 1, 2016

Release Summary

Bug fix release

Selected Bug Fixes

Email report issues specific to V6.2
White labeling parameter inconsistencies between Sisense versions
Filters pane can’t be minimized when embedding dashboard on iPads
Scatter map widget can cause the Sisense Web Application to become unresponsive under heavy loads
Parameters that are added to the URL of embedded dashboards and widgets are not passed when selecting different dashboards from the Dashboard list
After a user transfers ownership of a dashboard, deleting the same user can delete their previously owned dashboards in the new owner’s Dashboard list
When trying to change the source DB from SQL to Oracle - the following error message was displayed: "Index was out of range"

Improvements

Support for session-only cookies (documentation)
Press CTRL-S to save a script in the JavaScript editor
Added support for Javascript script editing for text widgets

6.2.1.80

Release Date: March 30, 2016

Release Summary

Bug fixes and improvements release

Improvements

Send an immediate email report to yourself from the Shared Dashboard window.
The Google AdWords API has been updated to the latest version – v201601.
Improved Google Analytics connectivity during high loads by using Exponential Backoff.
New Ordering() R function that allows you to control the order in which data is sent to R (documentation).
Google BigQuery now supports native syntax when using the "manual query" option.

Selected Bug Fixes

When loading dashboards on an ElastiCube build that has been stopped or or an ElastiCube right after a build, some widgets might return errors until refreshed.
Updating the source database through "Change Connectivity Settings" in the ElastiCube Manager could throw "Object Reference Not Set to Instance of Object" for certain database configurations.
Login attempts resulted in "Problem During Operation" errors for certain IIS configurations.
Exported CSVs could be empty for viewers for certain widget configurations.
Widgets and email reports can fail with an "Index '-1' out of range" error.
Clicking Update on dashboards that are set for manual update would not trigger immediately in certain dashboards.
Exporting dashboards through the REST API would not work for specific dashboards.

6.2.0.339

Release Date: February 29th 2016

6.2.0.357 Hotfix – March 12th 2016

Bug Fixes

Email reports not sent for certain configurations.
Unable to connect to some/all ElastiCubes from the Sisense Web Application in certain scenarios.
Localization settings are not applied when exporting to CSV.
Exporting a large pivot to CSV takes a long time.

Release Summary

Official release of Sisense V6.2

New Features and Improvements

Introducing ElastiCube Sets

Combine identical ElastiCubes into a single ElastiCube set
Allows dashboard querying during accumulative builds
Supports single/multiple nodes
For more details go to the ElastiCube Sets (Documentation)

Dashboard Management Enhancements

Dashboard sub-folders
Dashboard search
Copy widgets across dashboards (Documentation)
Attach PDFs to email reports (Documentation)
Change dashboard owner via the share window
Change the dashboard's source ElastiCube (Documentation)
Re-sizable dashboard panel
Share dashboards directly from the navigation tree

Data Connectors

New Google BigQuery connector (Documentation)
New Hive connector (Documentation)
SSL support for MSSQL and MySQL

Other

Import tables between ElastiCubes via Sisense ODBC (Documentation)
New API 1.0 functionality (See Developer Release Notes)
New statistical functions: Rank, Intercept, Slope
New mathematical functions: Log, Ln, Exp, Mod, Quotient, Ceiling, Floor, Round, Sin, Cos, Tan, Cot, Asin, Acos, Atan, Sinh, Cosh, Tanh

Selected Bug Fixes

"Failed to load ElastiCube <name> process" build failure in certain scenarios
Drilling in a pre-defined hierarchy might ignore filters when skipping a level
When importing data from MySql with custom SQL data types might be incorrectly assigned
Running multiple builds concurrently might result in build failures in specific scenarios
Using tables with identical names on different Redshift schemas might result in a 'connection failed' error

6.0.2.32

Release Date: January 17th 2016

Release Summary

Bug fixes release

Selected Bug Fixes

Email to user groups are not being sent in some Active Directory configurations
Exporting a very large pivot to CSV could take very long when working with IIS Express
Some widgets could be cut off in pdf exports
When working side by side with V4 dashboards, some filters might result in an error
The Sisense web app could become unresponsive when dealing with hundreds of widgets
Active Directory configuration screen is empty when working with an AdBlock plugin

6.0.1.87

Release Date: December 27th 2015

Release Summary

Bug fixes and improvements release

Improvements

FIPS Compliance
This version is suitable for regular deployments or installed on FIPS compliant machines.The Federal Information Processing Standard (FIPS) Publication 140-2, is a U.S. government computer security standard used to accredit cryptographic modules.
Allow exporting of large datasets out of the ElastiCube into CSV
Allow viewer to delete his sample dashboards

Selected Bug Fixes

Export to CSV Error 413 – “Request entity too large”
Builds with CSV/Excel files could fail when changing the file location
Build failures with the error "Failed to execute reader"
Build failures with the error "index out of range"
"Error saving data" when trying to preview or import data from NetSuite via ODBC
Scatter Chart size value show up wrong in tooltips
Table headers could become misaligned when using the browser’s native zoom
Stacked charts might display additional 'N/A' column when two categories are defined
"Problem during Operation" error when attempting to log in to Sisense Web
Formulas are not being saved when the ElastiCube's name contains special characters
Groups with long name are not always displayed properly

6.0.0.1602

Release Date: November 15 2015

Release Summary

Official release of Sisense 6.0

Announcing Breaking Changes

New Features

OPEN Sisense:

Sisense ODBC - Allow 3rd party tools to connect directly to ElastiCubes (Link)
Note: This feature is subject to additional terms & conditions. Please contact your success manager.
Sisense API version 1.0 (Documentation)

Sisense Mobile

New native apps for iOS and Android

Advanced Analytics

R Integration - run R code directly from Sisense dashboards (Documentation)
New set of native statistical functions (Documentation):
- Correlation
- Covariance
- Skewness
- Normal Distribution
- T-Distribution
- Possion Distribution
- Exponential Distribution
New mathematical functions (Documentation):
- Square Root
- Absolute
- Power

Improvements

Formula editor improvements (Documentation):
- 'Jump To' button for quick navigation between formula categories
- 'Expand' button to switch to new expanded window for easier handling of large formulas.
Sisense Web Performance and Infrastructure Improvements
- Reduced application size and load time
- Improved rendering times due to Angular.js framework upgrade
- Read more in the Developer Release Notes
ElastiCube Performance Improvements
- New heuristic algorithms to improve performance of grouping in queries
- Improved performance for basic and advanced aggregations
- Improved decompression performance for recycled queries in big data ElastiCubes

Selected Bug Fixes

Identical table names across different schemas would collide in some databases
ElastiCube could become unavailable for queries during full builds in certain scenarios
Unable to change the width of a pivot's column in some cases
Data security option did not work as expected when combining an 'Everything' rule with 'Everyone else'
Alignment issues when exporting dashboards with several columns to PDF
Sorting from the dashboard view would not take effect after multiple sorting modifications
Scatter map would hang with empty strings
Selections in charts would not take effect when working with the 'continuous timeline' feature
Scatter chart tooltip is not always well formatted for dates and formulas
Dashboard filter ranking tab terminology is misleading in some cases

For Release Notes prior to version 6.0, see the Release Notes Archive.