Insite Analytics

NOTE:
  • The currently shipping version of HelpSystems Insite is 3.08.
  • There are no updates for historical releases unless specifically listed.

June 2020

Version: 1.6.0

June 4, 2020

Enhancements
  • Insite Analytics now supports Common Table Expressions in Advanced Mode Queries.
New Features
  • Support added to retrieve JSON data from a RESTFul web service using Web Service APIs and Web Service Connections.
Fixes
  • Removed duplicate mapping value from BRMS status codes.
  • Allow the use of whitespace characters in Data Connection aliases.
  • Upgraded Jackson version to remove security vulnerability.
  • Fixed defect that prevented charting over queries containing UNION.

March 2020

Version: 1.5.1

March 30, 2020

Fixes

  • On newly created BRMS teamplate dashboards using the BRMS_Backups dashboard, the 'Successful Backups' and 'Failed Backups' widgets show the same result

  • A query that with multiple data connections using a COUNT(*) function had no chart elements appear on the dashboard.

  • Drill down from a chart that produced more than 1000 records caused ‘too much data’ error.

  • When applying data decorations to widget on a dashboard, they appeared incorrect in the Preview.

  • When trying to connect to 100 BRMS connections, received error ‘Server not Responding’.

  • In a parameterized Query, clicking Global Filter the query name isn't visible.

  • The custom column formatting was not showing correct format in Query and in Dashboard.

  • The null value appeared under Pie chart if the user selects grouping filed "Last Update" and legends "Inventory ID".

December 2019

Version: 1.5.0
New Features
  • Dashboard analytics tab requires valid IA license.
Enhancements
  • Option to add data connection value to output when download as CSV.
  • Added ability to apply a Data Decorations to any field in a Table.
  • New option to set widget's data source to ALL datasources.
  • Update icons to Insite 2.0 svg icon set. Includes content area and forms.
Fixes
  • Fixed issue where Data Connection metric is removed when Multi-connection Query shows errors on Data panel.

July 2019

Version 1.4.0

(Listed as 1.3.3 in Insite)

New Features
  • On Dashboard Widgets that contain data from multiple Data Connections, Insite Analytics now support the ability to drill down into data coming from both a specific data point and a specific Data Connection.
  • Query Builder is now capable of converting some SQL statement from Advanced Mode back to Wizard Mode.
  • Insite Analytics now allows the user to create a new Query from a predefined Template Query and customize the new Query to fit their needs. In Insite Analytics 1.3, HelpSystems also delivers a set of Query Templates designed to aid BRMS users in monitoring of their backups.

  • Insite Analytics now features a BRMS specific Data Connection type. Creating Data Connections of this type signals to Insite Analytics that the connection points to a known BRMS schema and is ideal for visualizing BRMS data.

  • Users can link a query to a specific driver type having it linked to all the data connections of that type in the future.
  • Users can link a query to several data connections at once

  • Insite Analytics user can query multiple Data Connections at once and combine the results in a single Dashboard Widget, Chart or Table.

  • Insite Analytics now features a service capable of classifying data produced by Query execution by data type and perform statistical analysis on that data. In future releases this service will enable automatic anomalies highlighting, trendlines, and predictions in Dashboards.

  • Query Builder now features the ability to Preview data from each Data Connection individually.

Enhancements
  • Resolved security concern pertaining to too many inadvertent Query executions while designing a Query.
Fixes
  • Caching feature has been disabled on Queries with drilldowns specified.
  • Upgraded distribution of Postgres JDBC driver because of security vulnerabilities.
  • Resolved security concern pertaining to malicious SQL execution.
  • Defect fixed that prevented currency symbols in drilldown Queries.
  • Grant admin access to all Data Connections from all users.
  • Added validation around parameter values in Widget Properties panel.
  • Fixed defect relating to Valueset Parameters.
  • Fixed error on grouping Query with MIN/MAX functions on a Date type field.
  • Fixed SQL parsing error on Queries containing Having condition.
  • Fixed error on DECIMAL column type when Querying DB2.
  • Resolved defect involving calculated fields showing "Invalid" error message.
  • When connecting to a SQLServer database, fields now return according to buffer position rather than alphabetical order.
  • Fixed undesirable formatting in Query Builder preview panel UI when fields names are too long.
  • Fixed undesirable formatting in Query Builder preview panel UI when fields names are too long.

March 2019

Version 1.3.2
  • Licensing changed to a connection count model.

February 2019

Version 1.3.1
Enhancements
  • Added parameter descriptions to IA Parameters in Widget Editor panel.
  • Add display descriptions for BRMS fields.
  • Added message Severity to logging drilldowns.
  • Added Descriptions under Query Template names.
  • Hide exact file and field names on premade dashboards for cleaner presentation.
  • Improved parser to allow for easier transition between Wizard and Advanced Query modes.
Fixes
  • Query Builder now supports Queries built over SQL Views.
  • Fixed defect with tables being removed from multi field joins.

January 2019

Version 1.3.0
New Features
  • On Dashboard Widgets that contain data from multiple Data Connections, Insite Analytics now support the ability to drill down into data coming from both a specific data point and a specific Data Connection.
  • Query Builder is now capable of converting some SQL statement from Advanced Mode back to Wizard Mode.
  • Insite Analytics now allows the user to create a new Query from a predefined Template Query and customize the new Query to fit their needs. In Insite Analytics 1.3, HelpSystems also delivers a set of Query Templates designed to aid BRMS users in monitoring of their backups.

  • Insite Analytics now features a BRMS specific Data Connection type. Creating Data Connections of this type signals to Insite Analytics that the connection points to a known BRMS schema and is ideal for visualizing BRMS data.

  • Users can link a query to a specific driver type having it linked to all the data connections of that type in the future.
  • Users can link a query to several data connections at once

  • Insite Analytics user can query multiple Data Connections at once and combine the results in a single Dashboard Widget, Chart or Table.

  • Insite Analytics now features a service capable of classifying data produced by Query execution by data type and perform statistical analysis on that data. In future releases this service will enable automatic anomalies highlighting, trendlines, and predictions in Dashboards.

  • Query Builder now features the ability to Preview data from each Data Connection individually.

Enhancements
  • Resolved security concern pertaining to too many inadvertent Query executions while designing a Query.
Fixes
  • Caching feature has been disabled on Queries with drilldowns specified.
  • Upgraded distribution of Postgres JDBC driver because of security vulnerabilities.
  • Resolved security concern pertaining to malicious SQL execution.
  • Defect fixed that prevented currency symbols in drilldown Queries.
  • Grant admin access to all Data Connections from all users.
  • Added validation around parameter values in Widget Properties panel.
  • Fixed defect relating to Valueset Parameters.
  • Fixed error on grouping Query with MIN/MAX functions on a Date type field.
  • Fixed SQL parsing error on Queries containing Having condition.
  • Fixed error on DECIMAL column type when Querying DB2.
  • Resolved defect involving calculated fields showing "Invalid" error message.
  • When connecting to a SQLServer database, fields now return according to buffer position rather than alphabetical order.
  • Fixed undesirable formatting in Query Builder preview panel UI when fields names are too long.
  • Fixed undesirable formatting in Query Builder preview panel UI when fields names are too long.

October 2018

Version 1.2.1
  • No updates for this release.
Version 1.2
New Features
  • Within a Query in Insite Analytics, a user can now specify up to 10 columns to be displayed in a table when the user chooses to drill down into that grouping.
  • The User can now override the default Parameter values when downloading the results of a Query to CSV.
  • Queries containing Group By clauses can now provide Drilldown actions when used inside of Insite Dashboards.
  • Down-loadable query meta-information added to assist support specialists.
  • Query Builder is now capable of converting some SQL statement from Advanced Mode back to Wizard Mode.
Enhancements
  • Query Builder is now more user friendly when defining Group By clauses.
  • Query Builder now supports the joining of tables containing multi-field Primary Keys.
  • For DB2 Data Connections, both the column name and the column label will be displayed in the Select Column dialog.
  • Provided better alignment for displaying decimal data in Preview Pane.
  • For DB2 Data Connections, both the column name and the column label will be displayed in the Select Column dialog.
  • Fixed parsing issue when wildcards are used in SQL.
  • Added Drill down functionality on Dashboard Charts.
  • Within Insite Analytics, users can now choose which credentials to use to run a query.
  • Drilldown widget pops up over the dashboard if there is a widget type change from chart view to list view while drilling down
  • Making data connections restricted to all users by default.
  • Support return to Wizard Mode for some Queries created in Advanced Mode.
  • Allow Insite Analytics Dashboard Assets to be viewed by users with no access to Query Builder.
  • Change so only one credential per datasource will be supported.
Fixes
  • In the query designer, when previewing data, if the browser was resized the previewed data did to scroll correctly.
  • Filter conditions are now correctly applied when downloading to a csv file
  • Fixed an issue where Automate Schedule queries and data connections were being displayed in the Insite Analytics homepage when Automate Schedule had not been selected for install.
  • Fixed Internet Explorer issue with Parameterized Queries.
  • Better validation around active licenses.
  • Fixed parsing error in LIKE statements.
  • Caching feature has been disabled on Queries with drilldowns specified.
  • Excel Data Connections are now able to filter by String.
  • Better validation around parameter values on Dashboard Widgets.
  • Improved log gathering utility.
  • New Insite role allows users to create Queries, but not new Data Connections.
  • Spaces are now allowed in Column Aliases.
  • Performance for Postgres connections has been improved.
  • The Datepicker no longer appears off screen in Widget Properties panel.
  • Fixed defect related to Where and Having conditions being deleted.
  • Fixed defect while connecting to Excel worksheets.
  • Temporary licenses will no longer be interpreted as a trial license.

July 2018

Version 1.1.1
Fixes
  • In the query designer, when previewing data, if the browser was resized the previewed data did to scroll correctly.
  • When updating Insite from 2.2 to 2.3, if the user responded 'yes' to stop the Insite Analytics Service, canceled the update, and restarted it later, the IA service did not start.
  • Filter conditions are now correctly applied when downloading to a csv file
  • In the query editor, if a column that is not in a GROUP BY clause is added to a HAVING clause, a message is now displayed indicating that the column is required in the GROUP BY.
  • In query editor, a calculated column could be incorrectly removed when removing a table from the query.
  • When a column format was edited to change the scale, the number of decimals displayed was not correct.
  • The Insite Analytics server failed to start if a port override was performed during the install.

June 2018

Version 1.1
New Feature
  • Parameters can be created in the Query Builder to provide for prompted queries. Various value types can be defined along with default values.
Enhancement
  • Added ability to modify a query's data connection without having to start the new query process.
  • Queries can now be duplicated.
  • When adding multiple tables to a query, the table select panel now remembers the library or schema for the last table added.
  • The Insite Analytics Home Page has been enhanced to show additional metrics regarding IA usage.
  • When adding a new data connection, a url template is now displayed (based on the connection type), to assist the user in defining a valid url for the connection.
  • A new option has been included with bar charts, to determine whether to 'pad' the X-axis values for data points where no data exists. Previously padding was always included. This is the correct option for time-series data (to show the correct timeline on the X-axis) but is often not required for other types of data.
  • Data displayed on certain Dashboard widgets may now be filtered by time ranges such as, Today, Yesterday or this month.
  • Query names can now include spaces.
  • Lifted limitation on 55-character Query name length.
  • Provided the ability for Insite Admin to control which users may define Data Connections and apply Licenses.
  • Provided additional information to User about Caching behavior.
  • Add Insite Analytics log to the Insite Logging Bundle.
  • Oracle 12g is now supported as a data source.
Other Fix
  • Security enhancements have been implemented.
  • The term 'data source' has been replaced with 'data connection'.
  • Drag and drop of a column in the query builder preview was sometimes unstable.
  • Long Query names overlapped adjacent columns in the query list. Now only part of the name is displayed if it is too wide to fit.
  • The License management panel showed overlapping information in some browsers.
  • The ability to 'de-mask' and view a saved password for a data connection has been removed, for security reasons.
  • The Advanced search entry field in the query builder list now resizes automatically to allow display of the full search criteria.
  • When a query was shared with another user, and placed in a widget on on a dashboard, and then the sharing on the query was revoked, the revoked user could still see the query data in the dashboard.
  • The search function for queries did not always return the correct results.
  • The query editor panel experienced layout issues when resizing the browser to a compact format.
  • Fixed lock-out scenario when Product Connection is not configured correctly.
  • When a column alias was defined for a column in a query, and the user switched to advanced edit mode, the alias name was lost.
  • Allow re-establishment of connections after Insite Session timeout.
  • Fixed scollbar issue in Expression Editor.
  • Fixed non-functioning dialogs in Internet Explorer.
  • Fixed tag based search mechanism to support Multi-tag search.
  • Better messaging provided when License expires.
  • Fixed issue around License Agreement failing to display.
  • Fixed issue around reordering columns in the Preview Panel while in Advanced Mode.
  • Fixed stability issue for long running User Sessions.
  • Fixed issue around calculated columns becoming un-editable.
  • Notify User about potential side effects of removing a Table that is referenced elsewhere in Query.

  • A dashboard with a List Widget using a query with the same file twice, did not show values for the field from the second file when an alias was used.

May 2018

Version 1.0.1

No updates for this release.

April 2018

Version 1.0
  • Core Insite Analytics functionality has been added to the Insite Framework including:
    • License Management
    • Query Builder
    • Data Connection Management

 

Back to Insite Products