April 2025 - Dashboard Release Notes

April 2025 - Dashboard Release Notes

 

  • IMPORTANT NOTIFICATIONS

    • Scheme Changes - the release contains x4 schema changes - see HERE for more information.

    • Upgrading - please read through all release notes from the version you plan to upgrade from and to, before you conduct an upgrade. Each release contains changes to functionality, therefore its worth being aware of these before your customers raise potential queries with you.


NEW FEATURES

New Magic Variables - Financial Periods

pi#2901

32934

Magic Variables

New Magic Variables - Financial Periods

pi#2901

32934

Magic Variables

The following magic variables have been added to the dashboard to display only the year component of the financial year date, such as '2025' instead of the full date:

  • START_OF_CURRENT_FINANCIAL_YEAR_YEAR

  • END_OF_CURRENT_FINANCIAL_YEAR_YEAR

  • START_OF_LAST_FINANCIAL_YEAR_YEAR

  • END_OF_LAST_FINANCIAL_YEAR_YEAR

  • START_OF_NEXT_FINANCIAL_YEAR_YEAR

  • END_OF_NEXT_FINANCIAL_YEAR_YEAR

  • CURRENT_FINANCIAL_MONTH

  • CURRENT_FINANCIAL_MONTH_SHORT_NUMBER

 

 

Export To CSV - With Translated Data Items (Chart Properties)

pi#2891

34772

Export To CSV

Export To CSV - With Translated Data Items (Chart Properties)

pi#2891

34772

Export To CSV

A new option has been introduced to the dashboard to allow data item translations in CSV exports. Previously, only the original data was included. This functionality can be activated by selecting the new checkbox in the Chart Configuration screen:

csv_translations.png

Please note, this feature is disabled by default and will have to be enabled per chart basis. Once enabled, the exported CSV file will contain the translated data if defined, matching the data display in the UI.

 

 


 

 

CHANGES & MAINTENANCE

 

Maps - Legend Pagination

pi#2907

33453

Maps

Maps - Legend Pagination

pi#2907

33453

Maps

Previously, there was an issue with maps with legend, when a legend was too large and contained too many items, it would spill off the edge of the page and not all legend items would be visible. Now, map legend have been paginated, similarly to all of our other chart types, in the case of a legend containing too many items to fit within the chart container.

Screenshot from 2025-03-10 13-48-12.png

The legend will have a scroll up button, a page indicator (which page you’re on compared to the total number of pages), and a scroll down button. The legend will readjust its total page count upon resizing the chart container vertically, and will scroll back to the top of the legend, whilst retaining the legend’s current state (which items have been clicked).

 

Maps - Minimum & Maximum Zoom Settings

 pi#2908

32772

Maps

Maps - Minimum & Maximum Zoom Settings

 pi#2908

32772

Maps

You can now set none, either, or both of maximum and minimum zoom settings for maps (on a scale of 0-18). This allows you to curate the users view both for the default and the zoom control to avoid a view which is very zoomed out or very zoomed in.

 

image-20250326-083147.png

 

 

New Category Objects Panel - Removed From BETA & Enabled By Default

pi#2691

 -

Category Objects

New Category Objects Panel - Removed From BETA & Enabled By Default

pi#2691

 -

Category Objects

Our fantastic new Category Objects panel is now removed from beta and enabled by default.

This has been rewritten from the ground up to provide the best performance and functionality. For a limited period of time you can use the beta flag NEW_CO_SHOW_OFF to revert this change if you experience any issues, please provide any feedback to support.

 

New Category Objects Panel - Improved Styling Through CSS

pi#2933, pi#2967

31662, 34126

Category Objects

New Category Objects Panel - Improved Styling Through CSS

pi#2933, pi#2967

31662, 34126

Category Objects

A number of improvements have been made to the styling of the new category objects panel. Please see the main changes listed below:

  • Added missing styling to ‘Cancel’ button in a category objects panel. The styling to this button will be derived from .pi-style__btn-default class.

Screenshot from 2025-03-24 14-06-42.png
  • Multi-picker values no longer overflow the input box. max-height has been set to 52px by default to control this behaviour. New CSS class .pi-style__category-objects-top-panel .pi-input.searchable-multi-select-multi-rows-input has been added, allowing users to customise styles for this input box.

Screenshot from 2025-03-24 14-06-42 (1).png
  • New CSS classes have been added to style the buttons in a multi-select modal. This applies to ‘Cancel’, ‘Apply’, ‘Clear’, ‘All’, ‘None’ buttons as per the screenshot below:

Screenshot from 2025-03-24 14-18-13.png

New CSS classes:

.pi-style__btn-multi-select-modal-apply - Default styling for the ‘Apply’ button

.pi-style__btn-multi-select-modal-cancel - Default styling for the ‘Cancel’ button

.pi-style__btn-multi-select-modal-selection - Default styling for the selection buttons ('Clear', ‘All’, ‘None')

 

 

We have even more CSS changes coming in our May 25 release, so be sure to check those out next month too!

 

New Category Objects Panel - Out Of Date Category Object Droplist Values

pi#3033

 -

Category Objects

New Category Objects Panel - Out Of Date Category Object Droplist Values

pi#3033

 -

Category Objects

An issue occurred where list of values for a droplist Category Object could be inaccurate. This was only a problem when using the New Category Object Panel, when the ‘Display on Top’ option was in use. The impact was limited to only droplists that were not excluded from the cascade, and therefore had their values restricted by a previous Category Object.

 

Exporting - Browser Based Exports (Old Method Removed)

pi#2691

 

Exports

Exporting - Browser Based Exports (Old Method Removed)

pi#2691

 

Exports

For a limited period, we provided a fall-back option to use our older, slower export system for many types of charts and tables. After a period of the new functionality being on by default for all customers, we have now removed the fall-back option. Certain types of more complex exports will continue to use the renderer and take longer to generate but where possible the near-instantaneous browser based exports will be used.

 

Reports - Add Charts From A Parent Organisation

pi#2924

34890

Reports & Organisations

Reports - Add Charts From A Parent Organisation

pi#2924

34890

Reports & Organisations

You can now add charts from parent organisations to reports.

In the dropdown menu to select a chart, you will see 2 sections - 1 for the current organisation, and 1 for the parent organisation:

Screenshot from 2025-03-26 16-04-30.png

If you export and import a report with charts from parent organisations, you will get a warning for the report that contains these charts, and upon expanding the information for the report with the warning, you will see a warning for each chart that is from a parent organisation:

Screenshot from 2025-03-27 15-20-29.png

You will still, however, be able to successfully import the report. The charts from the parent organisation, will, however, not be present, and you will have to manually re-add them after the import.

 

Performance - Column Store Built As Required Rather Than All At The Point Of Initialisation

pi#2889

34870

Performance

Performance - Column Store Built As Required Rather Than All At The Point Of Initialisation

pi#2889

34870

Performance

Previously, actions such as navigating to the Configuration Screen would result in the processing of data columns for every Organisation the user had Admin access to.

For users with a lot of access, this could lead to a notable delay between clicking the spanner icon and the initial Organisation being available for editing. This was particularly slow when there were a lot of inherited connections as those require extra processing.

Now, rather than paying the processing cost for all Organisations upfront the ‘Column Store’ is built progressively as access to it is required. For example, opening the Configuration Screen will now initially only process/load the columns required for the Organisation the user will initially land on (usually their Owner Org). Switching to a different Organisation via the dropdown will result in the data columns for that Organisation being processed and loaded. This does mean that switching from one Organisation to another will be slower but unless you end up editing all of the Organisations you have access to the accumulated time should be reduced.

This change also affects the opening of the Chart Editor which behaved in a similar way to the Configuration Screen. Rather than processing all Organisations, only the data columns relevant to the Organisation the data of the chart is from will be loaded. New charts or those that have had all of their data columns removed will still process all Organisations due to the need to have all potential columns available.

 

Custom Maps - Incorrect Navigation After Using Drill To Top Option, On Full Screen Close

pi#2951

35492

Chart Display / Custom Maps

Custom Maps - Incorrect Navigation After Using Drill To Top Option, On Full Screen Close

pi#2951

35492

Chart Display / Custom Maps

Previously, when drilling into a Custom Map with 'Full screen to display this level' and 'Drill to top on full screen close' enabled, exiting the full screen would incorrectly return the user to the Custom Map instead of the Top Level Chart.

Now if both options are selected within the Chart Attributes screen, closing full screen will correctly return to the top-level chart. The video below provided a short demonstration:

recording.webm

 

 

Temporary Chart Filters - Incorrect Category List When Attempting To Save (Organisations)

pi#2994

36470

Temporary Filters / Organisations

Temporary Chart Filters - Incorrect Category List When Attempting To Save (Organisations)

pi#2994

36470

Temporary Filters / Organisations

As mentioned in the 2025_03 Release Notes (Known Issues section), an issue was discovered whereby the Category list when saving Temp Filters would not always list the categories related to the correct Organisation. Rather it would always list the ‘active org’ that would be the user’s Owner Organisation - unless they had happened to pick a different one from the Configuration Screen selector, which has been addressed.

 

Temporary Chart Filters - Not Saved Against The Correct orgId (When Using Subscriptions)

pi#3019

36578, 36579

Temporary Filters / Organisations

Temporary Chart Filters - Not Saved Against The Correct orgId (When Using Subscriptions)

pi#3019

36578, 36579

Temporary Filters / Organisations

Temporary chart filters added by subscribed users were not being saved under the correct orgId.

NOTE: There is still a related issue around the UI not reflecting the saving/deleting of temporary chart filters immediately when you are dealing with Organisations that aren’t currently ‘active’ (either not your Owner Org or for Admins not the last Organisation to have been selected from the Organisation selector in the Configuration Screen). The filters are however corrected after a refresh.

 

Schedules - Empty Tables Being Scheduled Incorrectly

pi#3007

36557

Schedules

Schedules - Empty Tables Being Scheduled Incorrectly

pi#3007

36557

Schedules

Empty tables were being scheduled despite the 'Data' checkbox being selected. The 'Data' flag will now be correctly respected—only tables with actual data will be sent out when this option is selected.

 

Schedules - Encrypted Schedules Failing (Windows Only)

pi#3004

36537

Schedules

Schedules - Encrypted Schedules Failing (Windows Only)

pi#3004

36537

Schedules

As mentioned in the 2025_03 Release Notes (Known Issues section), an issue was discovered whereby Encrypted Schedules (where a password has been defined) would fail to run on Windows only installations.

 

Authentication - Session Identifier Being Reused

pi#2984

35703

Authentication & Security

Authentication - Session Identifier Being Reused

pi#2984

35703

Authentication & Security

Some authentication modes were inadvertently reusing the same session identifier both before and after authentication.

 

Reduced Session Storage

pi#2929

 30822

Storage / User Sessions

Reduced Session Storage

pi#2929

 30822

Storage / User Sessions

Some user messaging has been moved from session storage to other locations to reduce the overall session data stored, the ultimate aim being to remove any stored session state.

 

Library Upgrade - Crypto Upgraded To v0.37.0

scheduler#100, excel-reader#56

36578, 36579

Library

Library Upgrade - Crypto Upgraded To v0.37.0

scheduler#100, excel-reader#56

36578, 36579

Library

To mitigate the CVE-2025-22869 vulnerability around the Scheduler and Excel Reader modules, we have upgraded the Crypto package to v0.37.0.

 

 


 

SCHEMA CHANGES

Change

Reason

Columns

GitLab

ZenDesk

Change

Reason

Columns

GitLab

ZenDesk

Removed

Unused Columns From mis_hierarchy_columns

mis_hierarchy_columns.EDITABLE

mis_hierarchy_columns.SHOW_SUM

mis_hierarchy_columns.SHOW_ROW_SUM

migrations#66*

-

Added

Maps Zoom fields to mis_hierarchies

mis_hierarchies.maps_min_zoom

mis_hierarchies.maps_max_zoom

pi#2908

32772

Added

Org Super Admin to mis_users

mis_users.org_super_admin

pi#2609

31913

Added

Export as csv with translations to mis_defined_charts

mis_defined_charts.export_as_csv_with_translations

pi#2891

34772

*identified around MySQL compatibility