sisense release notes

Popular Searches Release Notes Connectors Using R in Formulas. This functionality was previously available only over API, Users created by SSO over SAML can now be associated with all roles of the system, except Administrator and Data Administrator, Performance improvements for queries on Live models, Significant improvements to Oracle and Snowflake connectors performance, Change your Sisense password from within the User Profile area (, Unsubscribe from your dashboard reports (, Sort your dashboards when displayed in the List view on the Analytics page (, Duplicate multiple dashboards with a single click (, Change data sources of individual widgets (, Sisense Administrators can control whether to update dashboards on every filter change (, Support for equal distribution of widgets across a row in a dashboard added (, The Plugins section within the Admin page was renamed Add-Ons. Sisense 6.5 requires .NET version 4.5.2. To use Fivetran with Sisense V7.3, follow the setup instructions for V7.3. Note for TeamConnect Business Intelligence 6.0: Since emails must be configured ON at the Sisense Server level for clients to receive scheduled reports, users will receive an account activation email when their accounts are automatically created in Sisense. 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. Connect natively to Java applications and databases with the new Sisense JDBC connector (Documentation) Duplicate Data Models. Sisense has developed a new Sisense SalesForce connector that supports v37.0 of the SalesForce API. Unless this action is taken, your ElastiCube build will fail due to the change in Google AdWords schema. Starting from version 7.4, the header: "X-Frame-Options: sameorigin" is added to Sisense web pages. In some cases, the chart widget displayed as empty due to negative values in the data. (, Query ElastiCubes during accumulative builds, Automatic roll back to your last successful build if an issue occurs, Support added for the POST HTTP method and HTTPS redirect URLs, Support added for unicode character-sets and floating point data types, Salesforce's latest TLS encryption protocol, Custom SQL statements when importing tables, Support added for the new Splunk SDK (2.0), Sisense now supports users and groups from multiple Active Directory domains. In addition, Sisense has updated the Google Adwords connector that is 10x faster and more robust than its predecessor. For more information, see, Automatic retry mechanism for Facebook Ads to improve build success, Customizable ODBC connections to support more data sources (, 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, 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, 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, Easily copy dashboards across environments from the Sisense Web Application, Import and export multiple dashboards in a single .dash file, 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 (, Define default languages for new users and groups, Improved security for Sisense user passwords which are now encrypted with a stronger encryption methodology, 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. Please note that due to an upgrade to the Javascript Infrastructure in V6, custom Javascript functionality & plugins might need to be adjusted. Looking For an Earlier ... V7.2 Sisense V7.1. The script will export and email the dashboards that are owned by a given Sisense user (see parameter dashboardOwnerSisenseEmail below). Sisense now uses OpenJDK libraries. Google sheets with column headers that contain text and special characters in the column's headers are now supported. 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. 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. The /settings/sso endpoints in the REST API V1.0 have a new attribute syncGroupsFromSamlToken. Then, download and install the latest version. Easily map dashboards, widgets and Pulse alerts to an alternative ElastiCube, Save drafts of unfinished custom SQL queries for later and revert back to previous queries (, Sort, filter, and sample your data when previewing your tables (, Schedule ElastiCube builds from the web-based ElastiCube Manager (, Upload Excel and CSV files to the web-based ElastiCube Manager (, Define custom SQL queries for Oracle, PostgreSQL, Redshift, SQL, and MySQL databases (, Duplicate values straight from the Sisense Web Application without having to copy existing formulas, Import relationships directly from your data source, Administrators can access and control all dashboards across their system from the Analytics page (, Significant improvement in dashboard load time, Immediate transition when moving from a widget view to a dashboard view, Improved ElastiCube build time and memory consumption, especially for ElastiCubes with custom tables and ElastiCube to ElastiCube imports, Easily define when your Fiscal year begins across your system or per ElastiCube (, Publishing dashboards for a large number of users took longer than expected in some cases, Calendar date filters could become misaligned when using the browser’s native zoom, When drilling down into Date dimensions, the menu was not displayed in the translated language Pulse alert tooltip was not translated as expected, Long labels names are not displayed in widgets correctly in some cases, Auto-Zoom could not be disabled in Line widgets in Sisense V7, In some cases, when sorting a Column chart, the loading indicator was still displayed after the sorting was completed, Values could not be renamed in the Formula Editor in some cases. Support was added for Azure Premium Disk Storage Therefore, this script needs to be created for each dashboard owner. For more information, click. Release Notes. It can display the number of leads, qualified leads, opportunities, and won deals. Contact Sisense Technical Support if you believe this may have any negative effect on your performance before making any changes. Starting from Sisense versions 8.1.1 & L8.2.1, a new version of Sisense.js is available. This enhancement allows you to embed SisenseJS on sites in which Angular 1.x and 2.x have been implemented. Sisense has significantly upgraded several data connectors: The current features are not supported by live connections: The current plugins are not supported in Sisense Reports: To increase Sisense server security, starting from Sisense v6.6, user passwords stored in the Sisense server are encrypted with a stronger encryption algorithm. Limiting Access to the Application Database, 7.0.0.21003 - Service pack update including several bug fixes - December 27, 2017, 7.0.0.20135 - Improved relationships workflow, performance enhancements, and bug fixes - December 19, 2017, 7.0.0.10700 - Bug fixes - November 30, 2017, 7.0.0.10065 - Official release of Sisense V7.0 - October 30, 2017, Are you upgrading from a pre-6.7 version of Sisense? For more information, see the, Queries with the error: “Threads Stuck waiting for Critical Section Lock on QOT statistics”, IIS did not work as expected and returned the error: “ParserLogger - Non-negative number required”, Pivot tables could not be exported to Excel when a Base URL was defined, Refreshing a schema did not work as expected after importing a new query, Gather insights on dashboard interactions, performance, and viewer activity across your deployment, Filter and drill-into activity of specific users or dashboards to the finest level of detail, Monitor user behavior across dashboards to improve user adoption and engagement, View detailed build logs for each ElastiCube build, Download and save your build logs in JSON (, The new Multi-Node Deployment Wizard assists you to install and set up Multi-Node deployments by automating almost all of the configuration process (, Added a note “Powered by Sisense” to the User Profile box under the Sisense version number (this can be removed through the, If you have rebranded Sisense, Administrators now see the default Sisense Analytics homepage when the, From Sisense V7.3 onwards, Sisense uses OpenJDK libraries. Exporting dashboards through the REST API would not work for specific dashboards. Login attempts resulted in "Problem During Operation" errors for certain IIS configurations. (, The Angular library was updated to version 1.7.9, In Sisense Mobile, some dashboards did not open when using the Jump to Dashboard add-on, When configuring SSO and Session Management, the default user login did not work as expected, If the connection to the web socket was lost, a warning message did not appear, Forecast and Trendline features did not render properly for the widget when SisenseJS was used, ODBC connectors that are incompatible with Snowflake and Redshift still appeared in, If SSO was enabled in the system, an Administrator was unable to change dashboards to Owner view, When MySQL Java Virtual Machine (JVM) was enabled in, The Google Sheets connector took a long time to load the list of sheets, When saving a PDF layout, the Shared Users' PDF Layout and Settings was not updated, The JAQLine add-on did not show the relationship icons, In certain scenarios, the Sort behavior on columns using the RSUM() formula was incorrect, If End User Scheduling was turned on, reports were triggered (but failed) when the system level “Send Emails” was disabled, In some cases, SisenseJS did not display ScatterMap and TreeMap widgets, When the Fiscal Year Start date was set to 1 February, and there is a filter for the "This Quarter (FY)", the error "Year Month and Day parameters describe an un-representable DateTime" appeared, In some cases, when Narrative was set to ON, the resulting narrative text was based on an incorrect row, If a widget had two values, the Narrative text would sometimes not appear, In some cases, a console error appeared when attempting to show the Narrative text, When adding a value to Break-by, an error would display instead of the Narrative text, The Safari browser did not support creating or editing custom queries, In very specific cases, when changing the data source provider for a table from MongoDB to an Excel table, the preview was empty, When a value is NULL, the Grand Total value of a cumulative ratio showed 200%, instead of 100%, In some very specific cases, Accumulative Builds failed, When SSO was enabled, if the session became inactive, sometimes the Home page opened instead of the last opened dashboard, Sometimes after installing and occasionally after upgrading, Sisense provides a new tool to easily configure, Forecast Boundaries are added to enable you to prevent Forecasts from displaying unreasonable values. If you backup your Sisense application database, or use scripts that routinely do this for you, the location of the application database has been changed from: Backing up the Sisense Application Database, %ProgramData%\Sisense\PrismWeb\Repository\DB. Manage your plugins from a centralized UI in the Sisense Web Application, Control which plugins are enabled or disabled. Sisense Cloud Native Linux Click to open the Sisense Cloud Native Linux Release Notes See the, 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 (, The Sisense application database (MongoDB) could be corrupted following a system restart due to a MongoDB bug, Exporting Pivot tables to Excel might fail in some systems. Learn more about the complete list of features and enhancements from Sisense 8.0.1, as well as many bug fixes, in the release page and the developer notes. This feature is being released gradually and has a waiting list. Unless this action is taken, your ElastiCube build will fail due to the change in Google AdWords schema. TCE 6.2.5. Export pivot tables to Excel while maintaining your pivot’s layout and structure (, Export pivot tables into customizable, multi-page PDF reports (, Add automatically generated text to popular widgets that communicates your analytics and provides insights of your data. The values in Stacked Column charts have been enriched to include: Presentation of the contribution of negative values within a stacked column, Percentage labels on each value in a Stack 100 Column chart, In a multi-server deployment, the distribution of, The Google BigQuery connector supports importing nested data and querying partitioned tables only in, Oauth is not available when working with the generic JDBC connector that was defined as system user (, The Salesforce connector has a different naming convention for custom objects compared to older versions of the Salesforce connector. Release Notes The Tabber add-on creates a new widget that allows you to switch between views easily and quickly without changing the dashboard. This significant change in infrastructure also allows for superior performance. New filtering functionality included in the Sisense mobile app. Exporting a Pivot table to PDF is supported for up to 10,000 rows only and the following plugins are not support: 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. (documentation). Available for download from the Sisense documentation site. In the event that you need to downgrade from Sisense 6.5 to an earlier version, please contact Sisense Support who can guide you. Unable to connect to some/all ElastiCubes from the Sisense Web Application in certain scenarios. Improved Google Analytics connectivity during high loads by using, New Ordering() R function that allows you to control the order in which data is sent to R (. These tables can be deleted from the Live Data Sets section without impacting your ElastiCube. Prerequisites. Note. The Sisense build node that distributes ElastiCubes to your query nodes does not support concurrent builds. Query simulation cannot take place. For more information, see Replica Sets. Improved Google Analytics connectivity during high loads by using, New Ordering() R function that allows you to control the order in which data is sent to R (. For more information, click here. The tables will appear in the ElastiCube Manager stacked on one another until you reorder them. 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. 7.1.3.16003 - Service Pack - March 5, 2019, 7.1.3.15004 - Service Pack - February 21, 2019, 7.1.3.14001 - Service Pack - December 26, 2018, 7.1.3.13005 - Service Pack – October 25, 2018, 7.1.3.12002 - Service Pack – September 20, 2018, 7.1.3.11003 – Service Pack – August 13, 2018, 7.1.3.10025 - Official release of Sisense V7.1.3 - July 22, 2018, 7.1.2.10076 - Official release of Sisense V7.1.2 - May 30, 2018, 7.1.1.10089 - Official release of Sisense V7.1.1 - May 6, 2018, 7.1.0.12003 – Service Pack – April 24, 2018, 7.1.0.11010 – Service Pack – April 12, 2018, 7.0.2.14004 – Service Pack – April 22, 2018, 7.0.2.13001 – Service Pack – April 2, 2018, 7.0.2.12002 – Service Pack – March 23, 2018, 7.0.2.11001 – Service Pack – February 22, 2018, 7.0.12003 - Service pack - January 31, 2018, 7.0.1.11006 – Service pack – January 24, 2018, 7.0.1.10061 – Official release of Sisense V7.0.1 – January 15, 2018. Sisense 6.5 requires .NET version 4.5.2. Sisense now supports the following for Splunk: Importing the latest artifact from a list instead of the first (oldest) one, ElastiCube performance enhancements including faster queries when used in conjunction with Rank filtering, Statistical functions, and Distinct Count, More PSM.exe commands added for automating ElastiCube model changes (, In some cases, builds failed with the message: “Failed to Load Elasticube 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, Some functions are not currently supported, Changing live data sources for dashboards, 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, 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, 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, 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, Conditional statements are now supported in widget formulas using IF and CASE functions. JAQL Syntax Reference. If you apply a break-by field after sorting, the sort order is maintained. Due to the updated API, the following fields are no longer supported by Google: This update affects the following tables: The Sisense Custom REST API now supports: Sisense has removed the REST API token from the Admin page. Specify “true” to synchronize the user’s groups on each login via SAML SSO. Setting ElastiCube set permissions via the API prevented designers from creating dashboards. Fixed: The error "There was an error reading from the pipe" occurred under high loads and required an ElastiCube restart, When working with Pie charts, the data labels were not always displayed as expected, In some scenarios, filters are being reset after data security is applied, Fixed: "There was an error reading from the pipe" error could occur under high loads and required restarting the, Grand totals did not take data security into account when using an Elasticube set in some scenarios, Values that included special characters, such as ‘$’, were not filtered as expected, Value labels in some scenarios were not displayed as expected, In some scenarios, numeric fields were not imported as expected from Postgres data sources, In certain scenarios, a catalog file would become corrupted resulting in lost build schedules, Updating data security rules did not reset dependent filters selections, In some cases, when republishing a dashboard, widgets which were deleted from the original dashboard appeared for shared users, Custom SQL queries with NOT EXISTS did not return the correct results in some scenarios, When applying a filter of the same time resolution on a multi-pass aggregation with a date field, the grand total was returned, When changing the system’s language, Date filters were not translated as expected, Some values were not displayed as expected when translated to Japanese, When translating Sisense metadata, some custom titles were not displayed in the translated language, In some cases, when downloading filtered data as a CSV file, all the results were displayed, Fiscal Years can now be defined to start at any month across your system or per ElastiCube (, Connectivity settings can be updated for supported web-based data sources (, Build settings have been updated to be more intuitive and you can limit the number of rows included per build (, When sharing a dashboard, if the data source was not previously shared with the user, the user could not view the dashboard, Data Administrators could not add new hierarchies, In some cases, changes that were made by Dashboard Designers to their dashboard’s copy might be republished to all users, In some scenarios, some values were missing when working with Polar charts, When changing column types and refreshing the schema, the column’s type was not recognized, Data Designers could not preview ElastiCubes in some scenarios, In some cases, ElastiCubes with special characters in the table names were not displayed as expected, In some scenarios, the Data page failed to load, When changing a connection for a table where the build behavior for a column is Accumulate By, and the column doesn't exist in the new table, the connection change fails, In some scenarios, an error occurred when adding a data source from the Quick Access list when working with the latest Chrome version (version 66), Pivot table grand-totals were not translated as expected, When the ElastiCube or server name had a period in its name, dashboard filters were not saved, The auto-complete functionality in the SQL editor in the web-based ElastiCube Manager did not work as expected in some scenarios, Building an ElastiCube from the web-based ElastiCube required more memory resources than expected, In some scenarios, when working with the web-based ElastiCube Manager, the Build button was disabled after a build failure, No table preview was available when restoring the last valid custom column expression, Dashboard filters were not applied on all widgets in some scenarios, In some scenarios, when having many categories, some of the categories' labels were not displayed as expected in Bar and Column charts, In some cases, Pie charts were not displayed as expected after applying a filter, Ticker Indicator widgets were not displayed as expected in some cases, When exporting Pivot tables to Excel, tables with custom currency were not formatted as expected, Max value labels were not always displayed as expected when working with Bar and Column charts, Abbreviated numbers were not translated in Chinese as expected, In some cases, builds failed when connecting two tables through text fields, Widgets were not displayed as expected when a new widget was added to a new row in the dashboard, Unable to dismiss the 100% Zoom warning message, Some Date fields formats in Excel were not imported as expected when working with the web-based ElastiCube Manager, Filters were not applied to all widgets the first time they were loaded in some scenarios, “Error in deserializing body of reply message for operation describeSObjects” when working with SalesForce connector, Organize your data easily with pinned tables, View related columns from the schema by hovering over their relationships, Understand your schema with a descriptive legend, See what Sisense entities, such as dashboards or Pulse alerts, rely on your ElastiCubes with dependencies (, When deleting an ElastiCube, view the dependencies prior to deleting a cube.

Dose Of Colors Mauve Lipstick, Ed Stafford: First Man Out, Best Coach In Premier League 2021, Crypto Google Sheets Template, Seance Movie 2021 Trailer,