March 2025 - Dashboard Release Notes

We have introduced the ability to define a theme, at both individual report level or globally for all reports.

Report Level

Within the Report Editor screen, the option to specify a theme on an individual report has been added (as highlighted in the image below).

A theme can be selected by either manually typing a theme name, or by choosing from the themes dropdown list.

Open

Global Report Theme

A new System Variable PI_STYLES_REPORTS has been added to the Dashboard Configuration screen (under the Global Variables tab), which allows you to specify a theme that will be applied to ALL reports in the system. This PI_STYLES_REPORTStheme will take precedence over the Global System Level theme - however it can be overridden by using an individual Report Level theme.

Open

Please refer to the following documentation for more information around the options to define a theme for reports - https://panintelligence.atlassian.net/wiki/spaces/PD/pages/2228256799. More information about system variables can be found onhttps://panintelligence.atlassian.net/wiki/spaces/PD/pages/246906905

Previously, when editing a chart filter that appears within the temporary filter panel, it would appear as if you have edited the original chart filter itself rather than a ‘temporary’ version of the filter, as the chart filter would disappear. However, after saving and applying the temporary filter panel, the original chart filter would re-appear. This behaviours makes it unclear what is happening within the temporary filter panel when you edit pre-defined chart filters within it.

We have made some improvements to the way chart filters are displayed and can be edited within this panel, providing clarity and preventing the appearance of unnecessary duplication.

1. Chart filters within the temporary filter panel will now be displayed with a ‘Chart Filter’ tag

2. The column for these filters can not be edited, as chart filters cannot be removed & saved from within this panel, so any attempt to do so would mean that we would have to create a new filter with the newly defined values

3. Once the values of a chart filter within the temporary filters panel are edited, you will see 2 filters - a temporary filter with your newly added values, and a chart filter with the original values, which will appear greyed out at the bottom of the filters list with an ‘Overridden’ text tag. Chart filters cannot be changed or deleted from within here, so we must create a temporary filter from it once the values are changed. The temporary filter will always override the chart filter, providing the column is the same.

4. Once a temporary filter - either the one you created from editing a chart filter, or a freshly created one - has values, a column and an operator that match that of a chart filter, the temporary filter and chart filter will be merged together and display as a regular, non-overridden chart filter

If you start with 2 pre-defined chart filters before editing them within the temporary filters panel, like this:

Open

And edit the filter with the ‘ends with’ operator, you will end up with this:

Open

An arm64 image for the Scheduler has been added to our base of docker images, to run on machines with an arm architecture.

You can access this image simply by adding an “_arm64” suffix to the end of a regular docker image, i.e. registry.panintelligence.cloud/panintelligence/dashboard/scheduler:dev_master becomes registry.panintelligence.cloud/panintelligence/dashboard/scheduler:dev_master_arm64.

Previously, when using a Drill To Chart all defined filters and drills filters from the higher-level chart would restrict the data of the chart you drilled to. In most scenarios, this is exactly what you want but there are cases where this behaviour is limiting. For example:

• A chart that shows all the Managers of an Organisation using a defined filter, but then drills to a chart that should display anyone within their Department:

  • For this, you would want to be able to ignore the defined filter but retain the drilling down by Department

• A chart that recursively calls itself to explore data with parent/child relationships:

  • For this, you would want to drill down on on the id of the parent but only use the higher-level drill filter for replacement within a defined filter mapping id to parentId. You would also want to ignore higher-level defined filters so that the only active ‘mapping’ filter is the one for the current level.

These new options are under the Filters tab of the Edit Chart screen beneath the slightly redesigned ‘Apply category filters’ within a collapsible section. Whilst they can be viewed and modified on any hierarchy that displays filters, these settings are defined for the entire chart not just that hierarchy.

Upgrades have been applied to the following libraries to resolve vulnerabilities and improve overall resilience:

• Netty upgraded to 4.1.118.Final

  • Addresses CVE-2025-24970

• Snowflake JDBC driver upgraded to 3.23.1

  • Addressed CVE-2025-24789

• Tomcat upgraded to 9.0.102

  • Addresses CVE-2025-24813

• Java upgraded to v17

The Average Target Line was previously calculated by taking the Total Value of each stack item (in every column), leading to duplication when calculating the average for the target line. Since each stack item (in one column) has the same total value applied, we only take one instance of the total value per column for calculations.

This ensues that the average value calculated is the same for both stacked and non-stacked bar/column/area chart types when using the same data.

In case of a failure in the SSH tunnel connection, the system now immediately attempt to reconnect and retries several times over the next hour. If the connection cannot be re-established at this point, it will be retried every hour from that point onwards.

Some PDF/Word exports with multi-line X-Labels would result in an SVG where parts of those labels were all overlapping one another in the bottom-left corner of the image, rather than respecting their own areas.

When using the new segemented CSV mode, Merged Tables were unable to be exported to CSV. Merged Tables can be successfully exported in both default segmented CSV and non-segmented CSV modes.

When the Category Objects panel was used in an embedded window, with the enableDynamicFilterPanel query parameter in the URL, a blank space appeared where the panel should be on the initial load. The panel is now pinned when enableDynamicFilterPanel is enabled across all category modes.

When using an SQL Server Data Connection an issue occurred that would prevented users from saving a table as the 'CUSTOM_FIELDS' type. The issue was caused by the addition of [] syntax to the table type, which resulted in the value always resolving to 'STANDARD'. The correct table type is now being saved to the database.

When viewing a Custom Map, should the SVG fails to load (likely due to a server side cors error), an error is now displayed in the Chart Panel to inform the user.

The ‘port’ and ‘host’ variables for the database, as defined in the Configuration Tool or through Environment Variables, were not being collected during the migration process when creating the initial set up of an instance, or when upgrading one. This is now the case on Linux, Windows and Containers.

A disabled user in a child organisation, with a subscription to the parent oragnisation was still able to login, despite being disabled.

In addition to BETA features being controlled through the PANCREDIT_PARAMETERS tables in the Repository DB, we have now enables this to be possible through the UI. For more information, see https://panintelligence.atlassian.net/wiki/spaces/PD/pages/2306179074

After upgrading the JAVA version, an issue insued with the ability to draw charts when using Snowflake data object.

An error of ‘There is a problem when displaying the category objects for category [with the category_ID being returned here]. Please contact the administrator’ when using the old style Cayegory Objects panel - caused by a NullPointerException.

• Go - upgraded to v1.23.8

  • Resolves the CVE-2025-22871 vulnerability, around the Scheduler and Excel Reader

• Go Crypto - upgraded to 0.37.0

  • Resolve the CVE-2025-22869 vulnerability, around the Scheduler and Excel Reader

Added

theme_name to mis_report_items

pi#2801

31539 & 32900

Added

restrictiveDrillFilters to mis_defined_charts

pi#209

8728 & 35188

Added

restrictiveDefinedFilters to mis_defined_charts

pi#209

8728 & 35188