5.7.7.515

Release Date: June 2nd 2015

Release Summary

  • Bug fixes and improvements release

Improvements

  • Importing dashboards now supported at the root folder
  • Improved dashboard response time to filter changes
  • Viewers are now able to switch between date filter tabs
  • Long field names are not trimmed early in data browser
  • MongoDB now supports accumulative builds

Selected Bug Fixes

  • Pdf export would fail in certain scenarios
  • Sorting case-sensitive inconsistencies between widgets
  • Cascading filters would be replaced by a regular filter when a selection would change from the widget
  • Some non English date-time patterns would be imported as nulls from CSV files
  • Indicator titles would not show up in email reports
  • Data labels formatting in scatter charts would display incorrectly when manually changed
  • Scrolling in the Javascript Editor available for long scripts

5.7.6.59

Release Date: May 10th 2015

Release Summary

  • Bug fixes and improvements release
  • Please note that the “Contributor/Consumer” terminology has been replaced with “Designer/Viewer”

Improvements

  • Hovering over dashboard names shows additional info
  • ‘Infinite Scroll’ support for the table widget in addition to standard paging
  • Bar Chart Y-Axis labels can be manually adjusted to avoid trimming
  • Data browser can display long field names without trimming
  • Exported PDFs do not show widget comments anymore
  • Proxy configuration to enable maps in proxy environments
  • Google AdWords API has been updated to v201502

Selected Bug Fixes

  • Export to PDF could fail in dashboards with many widgets
  • Newly built ElastiCubes would not always show up immediately in the web environment
  • Top Ranking filter would be applied first instead of after existing filters
  • Top/Bottom ranking widget filters could behave inconsistently in conjunction with dashboard filters
  • Combinations of complex formulas in a single pivot would return null results in certain scenarios
  • An error in a source database could make the ElastiCube build hang
  • Copies of dashboards that were shared in folders would not be saved
  • Excluding field members from a dashboard filter would not affect Pivots properly
  • Email reports delivery could become inconsistent after upgrades
  • Renaming would revert to old name in certain scenarios
  • Widgets that take long to execute could show up as unformatted line chart
  • Sort order of field members in some menus was case sensitive
  • Color Range formatting would misbehave on IE 11
  • iPad Air rendering issues for certain dashboard scenarios

5.7.5.1105

Release Date: March 29th 2015

Note: Windows Server 2008 (pre R2) is no longer supported starting from V5.7.5

Release Summary

New Features

  • New Text Widget (Link)
  • New Table Widget (Link)
  • Dashboard color palettes (Link)
  • Export widgets as images (Link)
  • Configurable Contributor/Consumer roles (Link)
  • Filters can be reordered

Improvements

  • Significant performance improvements in concurrent usage environments
  • Sisense login page credentials can be saved by the browser
  • Titles in indicators are now back, after having been removed in 5.7
  • New On/Off button for filters (Link)
  • New On/Off button for widget fields
  • Chart X-Axis labels can be manually adjusted to avoid trimming
  • Fields within formulas can be easily filtered/edited (Link)
  • Hovering over filters displays more info
  • Open ElastiCube Manager directly from the browser
  • Numeric formatting is affected by the OS locale and can be overridden (Link)
  • Email reports show the dashboard owner as sender
  • Our Splunk Provider now supports scheduled jobs

Selected Bug Fixes

Sisense Web App:

  • Export to pdf would return a “ReferenceError” on certain machine configurations
  • PDF exports would not always render maps correctly
  • Dashboard filter member weren’t affected by data security rules
  • New ElastiCubes wouldn’t immediately be available for dashboards in certain scenarios
  • White labeling issues such as page title and ‘Sisense’ occurrences
  • Grand Totals would not always get updated after drill-downs
  • Pivot headers on IE10 could become misaligned in certain scenarios
  • Sorted chart axis labels would ignore upper/lower case
  • Maps would not highlight selections correctly in certain selection combinations
  • Email reports wouldn’t show secondary indicator values

ElastiCube

  • Build failures with the error “The underlying provider failed to open”
  • Large numbers of complex calculations on a Pivot could corrupt it
  • Very large Excel 2013 files could take extremely long to build
  • Builds with CSV files could fail in certain open quotation marks scenarios
  • Builds with CSV files that were created on OSX would fail
  • Failed accumulative builds could leave ElastiCube in invalid state

Administration

  • Arrays were not accepted in the ElastiCubes/Data Security API calls
  • Disabling email notification through the API would not always take effect
  • Active Directory wouldn’t accept users with special characters
  • ‘Resend Invitation’ wouldn’t be sent out on some machines

5.7.1.38

Release Date: February 8th 2015

New Features

  • Change aggregation type of subtotals and grand totals. (link)

Bug Fixes

Sisense Web App:

  • Grand Totals wouldn’t be affected by drill downs.
  • Some widgets could be cut off in pdf exports
  • Can’t make a copy of a shared dashboard in a folder
  • Sunburst wouldn’t show tooltip for some all series members

ElastiCube:

  • ‘Build Schema Changes’ would could corrupt ElastiCube in certain scenarios.
  • ToFloat function could misbehave on null values
  • daydiff function could return wrong results in specific complex formulas

5.7.0.161

Release Date: January 21st 2015

5.7.0.166 Hotfix – January 30th 2015

Bug Fix – Selecting dates in widgets could result in invalid results in certain time zones.

 

Release Summary

New Features

  • Download dashboard as pdf or image (link)
  • Pivot Subtotals for all aggregations and formulas
  • New Providers
  • New Widgets
    • TreeMap (link)
    • Calendar Heatmap (link)

Improvements

Sisense Web App:

  • Table-like sort – The Pivot can be sorted by any column if it contains non-grouped data
  • Word Wrapping in Pivot headers
  • The data browser responds to faster typing and returns results faster
  • Scatter Maps can show more details in the tooltips
  • Scatter Maps can be used as selectors
  • Clearer ‘Drill Up’ and ‘Clear Selection’ buttons with responsive design
  • Text selection is possible in Pivots
  • Improved error messages

ElastiCube:

  • Improved high-concurrency performance

Selected Bug Fixes

Sisense Web App:

  • Email reports wouldn’t be sent out on certain corporate configurations
  • Exporting large data sets to CSV from widgets could fail
  • Text wasn’t encoded right for some languages when exported to CSV
  • Functions in conditional formatting were not affected by the widget categories
  • Pivots highlight/slice modes didn’t work when affected by a dependent filter
  • Changing filter selections could add an ellipsis to indicator titles

ElastiCube:

  • Wrong build duration could be displayed in the ElastiCube Manager
  • Using multiple lookup fields would consume too much memory
  • Accumulative builds could crash in specific text field scenarios
  • Failed builds would hang in “Building” state in certain scenarios

Mobile:

  • Drilling would not work on certain devices

5.6.2.22

Release Date: November 28th 2014

Selected Bug Fixes

Sisense Web App:

  • The horizontal scroll bar in pivots would not show up in certain scenarios
  • Some widgets would go out of bounds in specific resizing scenarios
  • Email reports would fail on configurations in which an alias is active and localhost doesn’t redirect
  • Exporting to CSV with certain sort combinations would fail
  • The paging buttons in Pivots could not shop up when the dashboard is in view mode
  •  The Sisense sample ElastiCubes would not be deployed on some OS configurations

5.6.1.2

Release Date: November 9th 2014

New Features

Improvements

  • Maps have been improved to return much more accurate results
  • Easier to identify and troubleshoot cases in which a widget tries to work with two disconnected fields
  • ElastiCube connectivity errors are easier to identify and troubleshoot

Selected Bug Fixes

Sisense Web App:

  • Email reports wouldn’t display well on Outlook
  • Adding a custom field to a source Salesforce table could fail the ElastiCube build
  • Creating a filter based on a field value with “&” didn’t work
  • Fields that were marked as invisible in the ElastiCube would still be visible in the Sisense Web App
  • Exporting big pivots to csv could fail with “The request URL is too long” exception
  • Exporting to csv would always format dates in US format instead of local format
  • Exporting to csv couldn’t handle line breaks

ElastiCube:

  • Arithmetic operations with null values would return null instead of treating the null as 0
  • Pivots could return zeros in an entire column with some formula combinations across multiple fields
  • More date-time patterns recognized by the csv import provider

Other:

  • SQL API wouldn’t return column names in certain scenarios
  • White-labeling API could make the web application unavailable when used with invalid parameters

5.5.3.10

Release Date: September 1st 2014

Release Summary

New Features

  • New ElastiCube & Data Security (documentation), including REST API
  • User Groups with Active Directory integration (documentation)
  • Dependent Filters (documentation)
  • White-Labeling (documentation)
    • Note: On upgrade the existing rebranding options will be lost. Please use the new API call to re-initiate the white label, as described in the documentation.
  • New CSV provider – up to 3 times faster in importing big csv files

Improvements

Sisense Web App:

  • Last ElastiCube build time is shown for dashboards
  • Copy & Paste support in formulas
  • Improved field handling in the widget editor:
    • Direct buttons to sort/change aggregation/change filter/change formula
    • Double click title to rename.
  • Improved filter handling in the filter panel:
    • One click to expand/collapse
    • Click to toggle filtered items on/off
  • Improved menu handling and design

Administration:

  • Support for multiple administrators
  • Users who have not activated their account can get email reports

ElastiCube Manager:

  • Search for tables in the database import wizard

Mobile:

  • Added support for pivots on mobile devices

 

Selected Bug Fixes

Sisense Web App:

  • New widget wizard wouldn’t show field suggestions
  • Dragging widgets to top/bottom of dashboard didn’t scroll up/down
  • CSV export would fail in certain scenarios
  • Chart tooltip would show value of neighbor column in some cases
  • Using gradient colors in area charts would sometimes result in a lot of black
  • Javascript changes SAVE button would sometimes need to be clicked twice

ElastiCube:

  • ElastiCube could enter a deadlock in the ‘initializing’ or ‘finalizing’ phase of certain builds.
  • Accumulative build would fail with “BAT doesn’t exist” error in certain cases
  • Certain scenarios would cause a query to crash and leave the ElastiCube non-responsive in restarting mode
  • Complex ElastiCube Builds would fail with “Object reference not set…” in certain scenarios
  • Previewing a table in ElastiCube Manager would show different results than a Custom SQL table in some cases.
  • Build logs would not show up in ElastiCube Manager in specific failed build scenarios.
  • Queries on Windows Server 2008 would fail on machines with specific old processors.

Other:

  • Installing Sisense with IIS on Windows Server 2008 Datacenter edition would fail in certain scenarios
  • Filter by Attribute in 4.7 didn’t work in side by side installations with V5

 

5.2.0.12

Release Date: July 9th 2014

Release Summary

This release includes upgrades for our native Google providers:

Google AdWords

The Google AdWords API v201309 is scheduled to sunset by Google on July 21st, 2014. This release has been updated with the new API v201402. Once v201309 has sunset, your existing ElastiCubes that connect to Google Adwords will no longer build successfully until you upgrade.

Google Analytics

This release replaces the existing Google Analytics provider to rely only on Google’s OAuth 2.0 authentication method, and removes all dependencies to the previous “ClientLogin” authentication method.

Bug Fixes

  • Low disk space could crash the web server in certain scenarios.
  • Email reports would stop being sent after a while for certain users.
  • The dashboard list and main logo would not load and require a page refresh on some machine configurations.

5.1.5.61

Release Date: June 8th 2014

Bug Fixes

  • Multiple email reports instead of one were sent out in some scenarios.
  • ElastiCube Manager wouldn’t load on some configurations of Windows server 2008
  • Upgrading from Prism V4.7 to Sisense 5 could fail on certain machine configurations with many existing ElastiCubes.

5.1.5.44

Release Date: May 26th 2014

Release Summary

This release introduces the ability to upgrade Prism 4.X installations to Sisense V5. After upgrading, the existing 4.X and new V5 environments work seamlessly side by side. Read more here

Bug Fixes

Sisense Web App:

  • Email reports delivery inconsistencies bug
  • After installing Sisense a “Critical initialization error” would appear when trying to load the Sisense Web Application on certain machines.
  • Changing selections for date filters was not possible for consumers if the filter was collapsed.
  • When using the browser’s native zoom, the widget wizard becomes unusable.
  • Widget description icon would flicker in certain scenarios
  • Area maps would show up partial in email reporting
  • UI glitch in widget hover menus of very small widgets
  • Thousand separator default would show up wrong in tooltips

ElastiCube:

  • Empty column headers in Excel could fail Builds
  • Oracle ‘Timestamp’ fields were skipped by the table import wizard

5.1.0.34

Release Date: May 15th 2014

Release Summary

This is a feature release, introducing the following features:

Improvements

  • Various improvements in scatter map accuracy and performance. Also added excplicit location type selection (Country/State/City…). Read more here.
  • Color and numeric formatting windows have been redesigned.
  • Pivot rendering speed improvements
  • Various Bug Fixes

5.0

Release Date: April 7th 2014

Release Summary

Release Highlights

  • Brand new Sisense web application. Build dashboards in the browser.
  • Built on top of the latest HTML5 technologies
  • Responsive design
  • Mobile
  • Scheduled email reports
  • Statistical Functions
  • New Visualizations
  • Drill to Anything

Important Notes:

Sisense V5 does not support being installed side by side with Prism V4.X. To install Sisense V5 you have to uninstall your existing Prism installation. The ability to upgrade V4.X to V5 and keep working in both old and new web environments in parallel will be released in upcoming versions.

4.7.1030

Release Date: December 30th 2013

Bug Fixes:

PrismWeb:

  • “Cannot read property ‘length’…” error in Pivots and Maps.
  • Scatter could present rendering issues in certain scenarios.

4.7.1020

Release Date: December 2nd 2013

Bug Fixes:

ElastiCube Server:

  • Column names with certain special characters could fail accumulative builds and certain queries.
  • First time accumulative builds could fail in some scenarios.
  • Accumulative builds could fail in ‘Build Changes’ scenarios.

PrismWeb:

  • Certain Google Adwords build failures have been fixed by moving to Google OAuth 2.0. See below.
  • 3 and 4 digit US zip codes were mispresented in Scatter maps.
  • Paging in Pivot isn’t available if Pivot is used as a selector.

Important Notes:

The Google Addwords provider has been upgraded to Google’s latest authentication method – OAuth 2.0. New ElastiCubes will automatically be set up with OAuth 2.0, but existing ElastiCubes will keep on building using the old authentication method. If you are experiencing build errors with existing ElastiCubes, please use the change connectivity feature to update your connection to OAuth 2.0. More on Connecting to Google Adwords Here.

4.7

Release Date: October 16th 2013

New Features & Enhancements

General:

  • Automatic Updates – Now you can update Prism to the latest version with a single click.
  • DB2 Provider
  • Teradata Provider
  • We replaced our email delivery server for more reliable email delivery on dashboard sharing.
  • ServerConsole now displays the last build time for each ElastiCube.

ElastiCube Server:

  • Improved performance for accumulative builds.
  • Improved SalesForce import reliability for big data sets.
  • Support for Dynamic Campaigns in Google Adwords.
  • ElastiCube columns can be set to be hidden from BI Studio & Prism Web.
  • Prism Web:
  • Pivots can be used as selectors.
  • Maps can be used as selectors.
  • Built-in Legends for map widgets
  • Improved preview for map widgets
  • Auto coloring in maps

Bug Fixes

ElastiCube Server:

  • Accumulative builds could import duplicate values of last day in certain scenarios.
  • More fields added to the default fields in SalesForce tables.
  • Installations would fail on Windows 8 machines in which the default FIPS cryptographic algorithm was disabled.
  • License validation error in some non-English Windows installations.

Prism Web:

  • Stacked charts would show horizontal totals instead of vertical totals.
  • Fixed a bug which caused certain dashboards under SSL not to work.
  • Searching for items in member pickers failed on IE9.
  • Switching back from map to pivot would fail in certain scenarios.
  • Some data combinations could fail the Scatter Chart.
  • Logging into Prism Web from BIStudio wouldn’t work if the credentials contained special characters.
  • Chart axes could display big values with non distinctable markers, ie ‘1k’.
  • Complex Pivot tables could display a blank header for the first column & shifted headers in certain scenarios.
  • Fixed decimal point formatting in Scatter Chart tooltips.
  • Tooltips in widgets would sometimes not disappear on time.
  • ScatterChart legend date formatting display fixed.
  • Exporting from PrismWeb to Excel can show mixed cultures in certain scenarios.
  • Concurrency issues could appear on heavy parallel dashboarding.
  • Sharing window wouldn’t work well when sharing with a large amount of users.

4.5.1066

Release Date: July 29th 2013

Bug Fixes:

ElastiCube Server:

  • Changes to support updates in Zendesk API – See Zendesk post. The API update removes private info fields from end users. Important Note: Existing ElastiCubes that are connected to Zendesk need to refresh their connectivity in order for the Zendesk tables to be refreshed with the new Metadat from the updated API. See ‘Refresh’ section here.
  • Google Adwords accounts with no defined email address were not accessible through the Google Adwords wizard.

PrismWeb:

  • Tooltips in widgets would would remain visible even when leaving the widget.

Important Notes

All digital certificates in Prism executables have been renewed. You can continue using your existing version of Prism, but once you uninstall it you will no longer be able to install older versions, only versions starting from build V4.5.1055.

4.5.1055

Release Date:  July 21st 2013

Bug Fixes:

ElastiCube Server:

  • Google API update to v201306
  • Searching for tables in ElastiCube Manager would fail for Postgres databases

PrismWeb:

  • List Widget would be populated with duplicate results after change in scope

4.5.1044

Release Date: July 10th 2013

Bug Fixes:

ElastiCube Server:

  • Very large Data Context files could fail to load
  • Accumulative builds on ElastiCubes from old versions would fail in certain scenarios in 4.5.x versions

PrismWeb:

  • Map doesn’t update tooltips after change in scope

4.5.1038

Release Date: June 22nd 2013

Enhancements

  • Area Maps in Prism Web now automatically assign a default continuous color scheme when colors are not defined in BI Studio.

Bug Fixes

ElastiCube Server:

  • Complex queries would sometimes result with this error: “The size necessary to buffer the XML content exceeded the buffer quota”.

PrismWeb:

  • Resizing widgets would not update until the dashboard was refreshed.
  • Pivot pager would not respond to pivot width changes.
  • Tooltips in Maps would not update after a change in scope.
  • Changing widget position would sometime add a scrollbar to it.
  • Logarithmic scale was not published to Prism Web.
  • Changing colors of chart sometimes wouldn’t update in Prism Web.
  • Pie Charts would get black borders in Prism Web.
  • Selections in Stacked Area charts would misbehave.