6.5.2.11007

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

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

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.

SisenseJS

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

Limitations

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

6.4.2.11006

Release Date: September 26, 2016

Release Summary

Improvements and bug fixes

Improvements

New Data Connectors

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 web app admin section (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

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

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

6.4.0.30091

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:

%ProgramData%\Sisense\PrismServer\LocalRepository2.0\Resources\Google\Adwords

MongoDB

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

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

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.

Connectors:

  • 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

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

Improvements

  • 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

 

5.8.3.18

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

Improvements

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

5.8.2.15

Release Date: September 29th 2015

Release Summary

  • Bug fixes and improvements release

Improvements

  • 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

5.8.1.29

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

5.8.0.1253

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.