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:

• Sisense Version Upgrades
• Upgrading Sisense
• Backing Up Sisense

7.4.1

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

Announcing Breaking Changes

• 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

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:

• Upgrading Sisense
• Upgrading Sisense V7.2

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)
• Choose your session management method (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

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

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:

1. 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.
2. 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.