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.2
8.0.2.10023 - Official release of Sisense V8.0.2 - November 17, 2019
Selected Bug Fixes
- Export to Excel of Pivot Tables intermittently failed due to a server-side issue
- ElastiCubes failed to build when the DateDiff function was used twice in a WHERE clause
- In some scenarios, when exporting to Excel, unnecessary rows with garbled characters were generated
- Highlight bar chart filters did not highlight fields containing numerical characters
8.0.1
8.0.1.10112 - Official release of Sisense V8.0.1 - September 13, 2019
Announcing Breaking Changes
- The GET /dashboards/{id} endpoint returns only the Dashboard Owner ID and no other information about dashboard owners when called by non-Admin users
Introducing Live Table Queries
- Data Designers can create custom queries against live sources directly from within Sisense when working in the Live data model, without modifying the data in the source (Documentation)
Edit Embedded Dashboards and Widgets
- You can allow users to edit the Sisense dashboards and widgets embedded in your websites or applications (Documentation)
- Note: Starting from version 8.1, Designers will not be able to make any changes in view mode. In order for designers to make changes to dashboards and widgets, the host environment will have to be configured to edit mode
Rebranding
- Rebranding the application logo is now applied also to the Configuration Manager
Security
This version fixes a few security issues and contains some security hardening, including the following:
- Protection against Cross-Site Request Forgery is now supported (Documentation)
- The header "X-powered-by" on Sisense web pages was removed
- In some cases, the JWT token was not processed, resulting in the user being redirected to the remote login URL
Limitations
- When building data from the Athena JDBC connector, builds running for 30 minutes without retrieving any data fail with the error: "Build failed: Task: Base table panama-main-parquet-articles-metadata was not completed as expected”, as Athena imposes a 30-minute limit for queries. Users can increase this limit by contacting AWS
Selected Bug Fixes
- In the Groups list, the alphabetical sorting of groups was not working properly
- When importing data from another ElastiCube larger than 10GB, building the ElastiCube resulted in "The Operation has timeout"
- Conditional values in filters starting with "<" were displayed as starting with "<"
- The REST API ‘PATCH /Folder/{id}’ endpoint was breaking the contained dashboards pointing to the owner when changing the folder ownership
- When the “First Month of Fiscal Calendar” was set to a value other than January, months were not populated in a continuous and consistent manner within Pivot Tables
- In some cases when using Sisense on Firefox, duplicating a database table and then dragging it to the original table did not work as expected
- In some scenarios, copying dashboards between servers resulted in "Communication{{ error"
- In the Microsoft Excel connector, the Static Range setting was not working properly
- In dates imported from Microsoft Excel, changing the type from Text to DateTime did not behave as expected
- Zooming out on the Data page did not display the entire schema editor
- When dragging a table away from the other tables on the schema editor, the other tables converged together to overlap each other
- On tables with partitions imported from Google Big Query, the preview and querying did not work as expected
- When changing the database in the Google Big Query connector with the Change Table option, an error message was displayed
- Viewers were occasionally unable to save Time Frame filters on dashboards
- In some scenarios, values that were passed in Sisense with the parameter [filter] in URL of the frame did not work as expected
- In some cases, values from previous timeframes were included when drilling into the days of a specific month
- Live model menu settings were not displayed in the Data Sources section of the Admin page for Data Designers
- Issues relating to translation were resolved:
- In some cases, the drill-down menu was inaccessible for translated fields
- In some cases, the translated values in Pivot tables were exported to Excel as ‘undefined’
- In some cases, suggested fields were not translated
- In some cases, translated filters appeared in the original language after dashboard page refresh
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
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. To connect to SQL Server, use the SQL database credentials
- 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

If you have configured your system to communicate over SSL, you must re-upload your certificates through the Configuration Manager.
For more information, see Setting Up SSL.
If you are currently running SSL on port 443, the configuration of port 443 should be removed from the IIS Manager and browsing should be performed to the port as defined in the Configuration Manager.
When using SSL, the certificate must include the root certificate and any intermediate certificates.
The root certificate and the intermediate certificates must be manually appended to the certificate you provide. To do this, upload your certificate using the Configuration Manager. Then, edit the certificate in the Certificate text area and append the additional sections to the certificate text that appears there.

The location of the Email Templates directory has been changed from C:\Program Files\Sisense\PrismWeb\vnext\src\features\emails\templates to C:\Program Files\Sisense\app\galaxy-service\src\features\emails\templates.
Templates located in the old folder are automatically migrated to the new location when you install Sisense V7.2.
For more information, see Rebranding Sisense Automated Emails.

The location of the Plugins directory has been changed from C:\Program Files\Sisense\PrismWeb\plugins to C:\Program Files\Sisense\app\plugins. Existing plugins located in the old folder are automatically migrated to the new location when you install Sisense V7.2. When installing additional plugins, the files should be copied to the new location.

The location of Application log files was moved from C:\Program Files\Sisense\PrismWeb\vnext\iisnode to their new location at: C:\ProgramData\Sisense\application-logs.

Several endpoints were updated and others were removed from the REST API, for more information, see Developer Release Notes.
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
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

Following recent security improvements, the return_to URL must redirect users to a URL with the same protocol and domain as the URL where the authentication request originated from. Keep in mind, if your domain’s port is not the default port 80, you must include the port as part of the domain in the value of the return_to parameter, for example, return_to=http://localhost:8081.
If you have implemented SSO with a JWT token, your scripts should be updated to ensure that your user is redirected as expected.
For more information, see SSO via JWT.

The /settings/sso endpoints in the REST API V1.0 have a new attribute syncGroupsFromSamlToken.
When using SAML SSO, you can specify which groups the user belongs to as part of the SAML SSO token. The user is associated with these groups when the user is first created during the SAML SSO login process.
This new attribute controls whether to update the user’s groups from the SAML SSO token on subsequent logins.
By default the value is "false", meaning the user’s groups are updated only when the user is created. Specify “true” to synchronize the user’s groups on each login via SAML SSO. Specifying “true” will overwrite any manual changes to the user’s groups made in the Sisense application.

Following recent improvements to the Sisense application database, if you have implemented high availability with a MongoDB replica set or connect to the application database remotely, you need to modify the mongodbconfig.conf file and change the values of bindIp from an array to a string.
For more information, see:
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

Following recent security improvements in Sisense V6.7.1.15016, the return_to URL must redirect users to a URL with the same protocol and domain as the URL where the authentication request originated from. Keep in mind, if your domain’s port is not the default port 80, you must include the port as part of the domain in the value of the return_to parameter, for example, return_to=http://localhost:8081.
If you have implemented SSO with a JWT token, your scripts should be updated to ensure that your user is redirected as expected.
For more information, see SSO via JWT.
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

Sisense has improved the security of the application database included in the Sisense installation. All access to it must now be authenticated. If you access the application database directly, you must access the database with users created by Sisense during the Sisense installation. For more information, see Accessing the Application Database.
If you backup your Sisense application database, or use scripts that routinely do this for you, the location of the application database has been changed from:
Backing up the Sisense Application Database
If you backup your Sisense application database, or use scripts that routinely do this for you, the location of the application database has been changed from:
%ProgramData%\Sisense\PrismWeb\DB\Prod
to its new location at:
%ProgramData%\Sisense\PrismWeb\Repository\DB
High Availability
If you have implemented replica sets to support a high availability deployment, you need to reconfigure your replica set to work with the MongoDB V3.4 supported by Sisense, and to use the relevant database user credentials. For more information, see Replica Sets.

If you have set a specific percentage for ElastiCube memory usage in the ElastiCube server settings, it will be changed back to 'Dynamic' by default to support the new Garbage Collector mechanism. Contact Sisense Technical Support if you believe this may have any negative effect on your performance before making any changes.

If you have customized your Google Analytics or Adwords files GAnalytics.Tables and AdWords.Tables XML files in the following directory:
%AppData% \Roaming\Sisense\Prism\LocalRepository2.0\Resources\Google\Analytics (or Adwords)
you should move these files to the following directories to continue using the Google Analytics and Google Adwords connectors without any interruption:
%ProgramData%\Sisense\PrismServer\LocalRepository2.0\Resources\Google\Analytics
%ProgramData%\Sisense\PrismServer\LocalRepository2.0\Resources\Google\Adwords
If this directory does not exist, create it and then move your XML files to this directory.
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:
- Embed images to Pivot tables
- Conditional format Pivot foreground
- 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:
- default.yaml
- Sisense.WebQueryService.exe.config
- Mongodbconfig.conf
- 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

The current features are not supported by live connections:
- Pulse alerts
- Box & Whisker and Heatmaps
- R is not currently supported
- Some functions are not currently supported
- Changing live data sources for dashboards

The current plugins are not supported in Sisense Reports:
- Accordion
- Forecasting

To increase Sisense server security, starting from Sisense v6.6, user passwords stored in the Sisense server are encrypted with a stronger encryption algorithm. When downgrading from v6.6, all users who have logged into version 6.6 will need to reset their passwords. Alternatively, after downgrade from 6.6, you can restore all user information from a previous backup of a version lower than v6.6.
6.5.2.11007
Release Date: January 22, 2017
Release Summary
Improvements and bug fixes
Announcing Breaking Changes

The Google AdWords API has been updated to the latest version – v201609. Earlier versions of the Google Adwords API have been deprecated by Google and are no longer supported. Due to the updated API, the following fields are no longer supported by Google:
- CostPerConvertedClick
- ConvertedClicks
This update affects the following tables:
- ADGROUP_PERFORMANCE_REPORT
- Ad Group (Report), Daily Report
- Ad Group (Report), Monthly Report
- Geo Performance Report
- Search Query Performance, Daily Report
- Search Query Performance, Monthly Report
- Keyword, Daily Report
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

Starting from early 2017, SalesForce will require use of TLS 1.1 and higher to login to SalesForce services.To ensure uninterrupted service, you should upgrade to Sisense version 6.5 or higher, prior to the SalesForce login protocol change in early 2017.
Sisense has developed a new Sisense SalesForce connector that supports v37.0 of the SalesForce API.
The latest API includes changes to some of the SalesForce tables. Consequently, you may need to refresh the connectivity settings and your table's fields. Then, rebuild your ElastiCube’s schema or your ElastiCube build will fail due to the change in the SalesForce v37.0 API.For more information about changes to the SalesForce API, click here.

To ensure that SisenseJS continues to work after installing Sisense 6.5, your Sisense HTML content must be encapsulated within a div element with the ID "sisenseApp".
This is required for all Sisense.js scripts whether or not your website uses the Angular framework.
For more information, click here.
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

- Alerts are not supported in High Availability deployments.
- Currently, Sisense supports up to 30 alerts per user, including those created by the user and shared with the user.

- The first time you run an accumulative build, Sisense copies the ElastiCube to your server. While the ElastiCube is copied to your server, you cannot query the ElastiCube.
- In the event of a build failure, the ElastiCube with the last successful build may be unavailable while it is copy and pasted on your server.
- Your server should have enough disk space available to support a copy of your ElastiCube in case an error occurs during a build.

- In the event that you need to downgrade from Sisense 6.5 to an earlier version, please contact Sisense Support who can guide you.
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

Connectors created in version 6.4 of Sisense will not work unless you update the DLL files in each custom connector folder. You can retrieve this file from one of the sample REST connector files included in your Sisense installation located at:
...Program Files\Sisense\DataConnectors\DotNetContainer\SampleRestConnectors.

Following 6.4 security improvements, ElastiCubes built in version 6.4.1 have to go through the following process in order to work in pre-6.4.1 versions:
As a work around, you can do the following:
- In the Sisense Server Console, stop the Elasticube you want to import into an earlier version and export that ElastiCube to an ecdata file. For more information, click here.
- From the Command prompt, run psm.exe ecdata 62downgrade filename=<your ecdata filename>. For more information, click here.
- Import the updated version up the ElastiCube to an earlier version of Sisense.
6.4.0.30091
Release Date: July 27, 2016
Release Summary
- Official release of Sisense V6.4
Announcing Breaking Changes

The Google AdWords API has been updated to the latest version – v201605. In addition, Sisense has updated the Google Adwords connector that is 10x faster and more robust than its predecessor.
1 - Refreshing AdWords tables
The v201605 API version includes changes to some of the AdWords predefined columns. Consequently, it is required for you to click refresh in the 'Change Connectivity Settings...' window next to your AdWords data source and rebuild your ElastiCube. Unless this action is taken, your ElastiCube build will fail due to the change in Google AdWords schema.
2 - .NET 4.5.2
Your system has to be updated with .NET 4.5.2 for the updated AdWords connector to work
3 - Customized AdWords tables/column
If you use customized tables or columns, the resource folder has changed and you should move the files Adwords.Tables.xml or Adwords.Fields.xml to the following directory:
%ProgramData%\Sisense\PrismServer\LocalRepository2.0\Resources\Google\Adwords

Sisense now support MongoDB v2.0. This upgrade contains breaking changes. For more information, click here.
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:
- 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

- Currently, Sisense does not support the Prev/Next and Running Sum/Avg function sets when working on the weeks level.
- The week hierarchy is not automatically available for drilling down in widgets that were created prior to 6.4. Designers can add the week hierarchy manually.

- Currently, Sisense.js can't run in apps that use Angular JS 1.x.
- Sisense.js overrides the "Date" prototype with the "toISOString" function.

The Sisense build node that distributes ElastiCubes to your query nodes does not support concurrent builds.

After upgrading to the latest drivers, ElastiCubes that import tables from MongoDB/BigQuery/Hive using the lastest drivers will not be backwards compatible with the pre-6.4 drivers.
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

Please note that due to an upgrade to the Javascript Infrastructure in V6, custom Javascript functionality & plugins might need to be adjusted.
Additional information can be found under the Developer Release Notes
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.
