August 2024 - Dashboard Release Notes

 

  • Customer requested tickets are highlighted with the icon against the title

  • There are x2 Schema Changes included in this release

  • There is x1 Known Issue included in this release


NEW FEATURES

 

Additional Chart Atttribute - Sankey & Chord Charts

pi#2592

32588

Chart Attributes

Additional Chart Atttribute - Sankey & Chord Charts

pi#2592

32588

Chart Attributes

In our July 24 release, we introduced the ability to define a ‘Weight’ object for Sankey Charts and Chord Diagrams. Taking this a step further, we are enhancing this by adding additional settings into the ‘Attributes’ tab of the Chart Editor:

As shown below, you have the option to alter the presentation of the value that shows on the Node/Point tooltip in a couple of ways:

Screenshot from 2024-08-23 14-47-49.png

 

Weight Label:

In the example above, we specify that we want the value that would previously have shown as “Weight” regardless of the object being used to generate it to appear as “Amount” instead. We also have the option to hide the label which in the tooltip above would have resulted in “Amount: “ being removed from the final line. If we don’t specify a label here, the label from the Data Object will be used and if that hasn’t been defined the Display Name of the object will be used e.g. “Transaction Weight” in this example.

Measure Attributes

You can now customise the attributes shown above and they will be reflected in the ‘Weight’ value displayed in the tooltip. Any values not specified here will fallback to those on the underlying Data Object itself and then to their default values. Please note, similar settings are not available when using a Dimension for the Weight Object as that is not currently supported.

 

Report Logging

pi#2460

-

Reporting / Performance / Logging

Report Logging

pi#2460

-

Reporting / Performance / Logging

A new checkbox has been introduced to the Report Editor - ‘Log Report Performance Stats’ to allow users to enable performance logging for report creation and export for a single report. Only the users with ‘debug’ permission will have this checkbox available.

Screenshot from 2024-07-18 13-53-04.png

 

Report performance logging covers the main steps of the report creation and the duration the steps take to complete.

If the checkbox is enabled and when the request to export the report completes, the output of performance stats will be printed in out.log file in tomcat app logs. Example of the output in the logs:

New audit types have also been added to record the export of report in different export formats - Exported Report in PDF, Exported Report in PPT, Exported Report in WORD. Full list:

 

Enhanced Single Chart PowerPoint Exports

pi#2437

29822

Exporting

Enhanced Single Chart PowerPoint Exports

pi#2437

29822

Exporting

We’re excited to offer a completely rebuilt PPT export functionality which is almost instant and reflects any changes you make to charts on your screen (including legend selection).

You can try it out by enabling the beta feature BROWSER_PPT_EXPORT and we’d love to hear your feedback and incorporate feedback into our upcoming releases. At present it only supports certain chart types (highcharts) which doesn’t include tables, card charts, maps and some other types of charts. Any unsupported will simply fall back to the existing export functionality.

Example of the new PPT output:

 We are aware of an issue with this feature, captured in the Known Issues section - this will be addressed in our next release.

 

CHANGES

 

Improved Nulls to 0s, and 0s to Nulls Conversions (Data Tables)

pi#2505

31537

Data Tables / Nulls

Improved Nulls to 0s, and 0s to Nulls Conversions (Data Tables)

pi#2505

31537

Data Tables / Nulls

Improved the handling of converting 0s to nulls and nulls to 0s in data tables;

  • When converting null to zero on cross tabs, empty data cells which do not exist within the database will now be populated with zeros

  • When converting zero to null, values which are rounded to 0 will be converted to null

  • When converting null to zero, prefixes and suffixes will be included. When converting zero to null, prefixes and suffixes will be removed

  • All of the above will also apply to exports of all types, including tables inside of reports

 

When Importing Data Connections, Was Populating With A Blank Password

pi#2493

31451

Data Connections / Password

When Importing Data Connections, Was Populating With A Blank Password

pi#2493

31451

Data Connections / Password

Now, when importing a fresh data connection, or when overwriting a data connection with no password set, when the import also has no password set, it will correctly leave the password blank. The previous behaviour of being able to export data connection passwords when they are set as a variable will be retained.

 

Chrome Closure Reliability Improvement (Renderer)

renderer#118

31121

Browser / Chrome

Chrome Closure Reliability Improvement (Renderer)

renderer#118

31121

Browser / Chrome

Changes have been made to the code that manages the Chrome instances (used by the Renderer), specifically around the reliability of closing the browser when it’s no longer used.

 

MFA Login Loop (Specific Browsers)

pi#2591 & pi#2593

32571 & 32576

MFA / Authentication

MFA Login Loop (Specific Browsers)

pi#2591 & pi#2593

32571 & 32576

MFA / Authentication

Fixed an issue where users were not able to log in to the dashboard using Multi-Factor authentication setup on certain browsers (e.g. Safari, Firefox).

 

Addressed A Performance Regression With Chart Displays (In Larger Environments)

pi#2594

32555

Performance

Addressed A Performance Regression With Chart Displays (In Larger Environments)

pi#2594

32555

Performance

Resolved a performance regression apparent in some larger environments when displaying charts.

 

Library Upgrade - Grails 6.0.2

pi#2145

-

Library

Library Upgrade - Grails 6.0.2

pi#2145

-

Library

The Grails library has been updated from version 5.3.6 to version 6.2.0. This deliveres multiple improvements, whilst addressing a flagged vulnerability associated with SnakeYAML (CVE-2022-41854).

 

Library Upgrade - Tomcat 9.0.91

dd#93 & pi#2558

-

Library

Library Upgrade - Tomcat 9.0.91

dd#93 & pi#2558

-

Library

Tomcat 8.5 has reached end-of-life, and therefore we have upgraded to v9. This version has a significant period of additional support, which allows us to take advantage of future fixes in a timely manner as they become available.

 

Library Upgrade - Apache Commons Compress Library Upgrade

pi#2307

29943

Library

Library Upgrade - Apache Commons Compress Library Upgrade

pi#2307

29943

Library

Upgraded to 1.26.0 to resolve a reported security vulnerability (CVE-2024-26308).

 

Schema Changes

 

Column

Table

 

 

 

log_performance_stats

mis_report_items

pi#2460

 -

 

can_have_child_connections

mis_data_sources

 -

 -

 

 

Known Issues

 

New Exporting Feature - Exporting A Drilldown Chart

pi#2599

 -

Browser Exports

The new browser export feature (PDF and PPT) has an issue when exporting tables and other unsupported chart types that have been drilled to. If a user attempts to export these charts then the export will default to displaying the chart at the top hierarchy rather than using the renderer service for exporting unsupported chart types.

Oct 7, 2024 UPDATE: This issue has since been addressed in our September 24 release.