Build History – Service Pack – February 22, 2018

  • 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 –  Official release of Sisense V7.0.2 – February 12, 2018

Selected Bug Fixes

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


Build History

7.0.12003 – Service pack – January 31, 2018

  • Added configuration attribute to determine whether SAML SSO groups are synchronized after each login – Service pack – January 24, 2018

  • Fixed SisenseJS widget load issue – 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.

Application Database

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:

Limiting Access to the Application Database

Replica Sets

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

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


Build History – Service pack – Bug fixes – December 27, 2017 – Improved relationships workflow, performance enhancements, and bug fixes – December 19, 2017 – Bug fixes – November 30, 2017 – 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 section 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 web-based ElastiCube Manager (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


  • 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


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

Downgrading to an Earlier Version

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

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


Build History – 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. For more information, click here
  • 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. – 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. – 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 – 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 – Service pack –  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.

New Features and Improvements

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

Release Date: August 6, 2017 – Hotfix #2 –  August 20, 2017 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. – 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

Application Database

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.

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:


to its new location at:


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.

ElastiCube Memory Settings

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. 

Google Adwords and Google Analytics

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:



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 plug-ins from a centralized UI in the Sisense Web Application
  • Control which plug-ins 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.


  • 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” (or higher port number) errors
  • In high availability environments, Orchestrator-related build issues


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

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
  • 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

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

To see how you can connect to live data sources, check out this video demo.

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

To see how you can generate beautiful PDF reports, check out this video demo.

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

To see several examples of how you can migrate Sisense dashboards, check out this video demo.

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


  • 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.

To see the Mobile App in action, check out this video demo.

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


  • 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


Sisense Live Connect

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

Sisense Reports

  • The current plug-ins are not supported in Sisense Reports:
    • Accordion
    • Forecasting

Downgrading from v6.6

  • 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.

Release Date: January 22, 2017

Release Summary

Improvements and bug fixes

Announcing Breaking Changes

Google Adwords

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:

  • 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

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

Release Date: January 1, 2017

Release Summary

Improvements and bug fixes


  • 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

Release Date: November 29, 2016

Release Summary

  • Official release of Sisense V6.5

Announcing Breaking Changes

SalesForce Connector

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

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


Sisense Pulse 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.

Accumulative Builds

  • 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.

Downgrading from v6.5

  • In the event that you need to downgrade from Sisense 6.5 to an earlier version, please contact Sisense Support who can guide you.

Release Date: September 26, 2016

Release Summary

Improvements and bug fixes


New Data Connectors


  • 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

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.


Internationalization and Localization

  • Metadata localization (Documentation)
  • The system language can be controlled directly from the web app admin section (Documentation)


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

Data Connectivity


  • 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


  • 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


Upgrading Custom REST connectors from 6.4 to 6.4.1

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.

Downgrading ElastiCubes from v6.4.1

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:

  1. 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.
  2. From the Command prompt, run psm.exe ecdata 62downgrade filename=<your ecdata filename>. For more information, click here.
  3. Import the updated version up the ElastiCube to an earlier version of Sisense.

Release Date: July 27, 2016

Release Summary

  • Official release of Sisense V6.4
Announcing Breaking Changes in Google AdWords & MongoDB connectors

Google Adwords

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.

Open for more information regarding breaking changes

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:



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 Sisense.js

  • 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


  • 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


Weeks-time Resolution:

  • 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.

Open for more information regarding limitations

Sisense JS:

  • Currently, Sisense.js can’t run in apps that use Angular JS 1.x.
  • Sisense.js overrides the “Date” prototype with the “toISOString” function.

High Availability:

  • 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.

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 


  • 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.

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”


  • 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

Release Date: March 30, 2016

Release Summary

  • Bug fixes and improvements release


  • 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.

Release Date: February 29th 2016 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


  • 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

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

Release Date: December 27th 2015

Release Summary

  • Bug fixes and improvements release


  • 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

Release Date: November 15 2015

Release Summary

  • Official release of Sisense 6.0

Announcing Javascript API 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 (Link)

Sisense Mobile

  • New native apps for iOS and Android (Link)

Advanced Analytics

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


  • Formula editor improvements (Link):
    • ‘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

Release Date: November 2nd 2015

Release Summary

  • Bug fixes and improvements release

Important Notice – Dashboard folder management:

 We have recently discovered a critical bug in dashboard folder management, which impacts all customers on version 5.x and above. The bug occurs in the following scenario: When a shared “Dashboard 1” is moved from “Folder A” to “Folder B” and then “Folder A” is deleted, “Dashboard 1” becomes inaccessible. The issue has been fixed in this version, 5.8.3. 

Selected Bug Fixes

  • When importing data from Redshift/PostgreSQL builds might fail with ERROR 42P01
  • Continuous timeline is not always synced with the OS time-zone
  • Sisense REST API – error 400 on elasticubes/server/elasticube/permissions POST
  • Certain custom installation configurations might result in failed login issues due to invalid MongoDB port configuration
  • Some chart configurations might result in the Y2 axis labels being displayed outside the chart area
  • Missing dashboard filters when opening a dashboard in a new tab in some cases
  • Renaming fields in the new widget wizard are not taken into effect
  • Dashboard deletion is not always available when working side by side with V4 dashboards


  • Improved Google Analytics sampling to avoid missing entries due to Google sampling constraints (Documentation)
  • Improve silent installation to support additional arguments such as website name and port (Documentation)

Release Date: September 29th 2015

Release Summary

  • Bug fixes and improvements release


  • Support Now(<date level>) function of a date field (Link)
  • Enable/disable star filter functionality for viewers by using a custom role (Link)

Selected Bug Fixes

  • Export to CSV 500 Error – “Sequence contains more than one element”
  • In some cases, there were missing results when filtering on a single date after accumulative build
  • Very large Pivots might run out of memory when sort is applied
  • Incorrect last build time of a dashboard in the email subject in some cases
  • Using URL parameters does not work for anonymously logged in users
  • Viewers can ‘star’ a filter selection although ‘Starred’ filter tab is hidden
  • Past Value functions are not always affected by dependent date filters
  • Switching between dashboards before loading has finished does not behave as expected in some cases

Release Date: August 23rd 2015

Release Summary

  • Bug fixes and improvements release
  • Windows 10 is now supported when working with IIS Express

Important Notice for Google AdWords users:

The Google AdWords API has been updated to the latest version – v201506. This 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. 

New Features and Improvements

  • ‘Background Filters’ for limiting filter contents (Link)
  • User defined default dashboard filters (Link)
  • Drilling:
    • ‘Drill to Anywhere’ configuration option in widget editor (Link)
    • Set ‘Drill to Anywhere’ default in custom user roles (Link)
    • Predefined drill hierarchies can be set to always be included for field (Link)
    • Display the current drill level as part of the breadcrumb
    • Ability to rename/change a single hierarchy level in the hierarchy management
  • Support for importing multiple Excel files (Link)
  • Improved Pivot performance
  • Prism Shell (psm.exe) now supports changing datasource connectivity settings (Link)
  • When sorting Pivots the first click applies a descending sort
  • Designers can now copy shared dashboards
  • Support for map selections on tablets
  • Save confirmation when editing a widget script
  • Support for offline activation in silent installations

Selected Bug Fixes

  • Pivot scroll bars would not show up or not behave as expected in some cases
  • CSV export error 500 – “Specified value has invalid control characters”
  • In specific drill and filtering scenarios grand totals would display wrong results
  • IE11 would not function as expected in some SSO configurations
  • Embedded dashboards would show navigation panel on errors
  • Color formatting in indicators did not respond to formulas
  • Drill breadcrumbs are not displayed in ‘No Results’ scenarios

Release Date: July 15 2015

Release Summary

New Features and Improvements

  • Predefined drill hierarchies and breadcrumbs (Link)
  • Custom SQL for database connectors (Link)
  • Ability to cancel widget and dashboard loading directly from the dashboard
  • Ability to cancel all running queries for an ElastiCube (Link)
  • Manual ‘Apply’ option for filter panel (Link)
  • Apply multiple conditions in a single filter (And/Or) (Link)
  • Lock filters to restrict dashboard viewers (Link)
  • New Calendar filter with more functionality (Link)
  • Continuous time series and missing values handling (Link)
  • Add/Edit widget title from dashboard (Link)
  • Add/Edit axis titles in charts (Link)
  • Set axis range & interval in charts (Link)
  • More accessible highlight/slice widget configuration (Link)
  • Scatter charts marker size controller
  • Accumulative tables are highlighted in ElastiCube Manager (Link)
  • Display row count in table info (Link)
    Note: The row count will only be displayed after an ElastiCube has been built with 5.8.
  • Reduced memory consumption in ElastiCube builds

Selected Bug Fixes

  • Various ElastiCube build failures
  • PDF export glitches in widget with long titles
  • Past Month calculations on last days of month were non-standard
  • Improved dashboard behavior when querying a stopped ElastiCube
  • Data Browser didn’t respond well to quick typing in large ElastiCubes

Please notice the following changes to the Sisense installation:

  • The “PrismWeb.Express” Windows service has renamed to “SisenseWeb.Express”
  • The “Prism.Oxygen” Windows service has been renamed to “Sisense.Oxygen”
  • The ElastiCube plugin folder has been moved to C:\Program Files\Sisense\Prism\Server\plugins (Your existing plugins will be copied automatically on upgrade)

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