We are pleased to present our latest offering of pi - our April 2023 release! This page helps summarise the areas of the dashboard we have Added, Changed, or Fixed meaning you can make a quick and informed decision on when to upgrade to the latest release.

For our piSaaS customers, we also detail the platform changes we have/are making to piSaaS as we continue to evolve the solution.

Here is what is included in the release.

Changed

We have removed the functionality that deals with HSQL to MariaDB migration from the migration-jar project. This migration option will no longer be available to be ran in the command line.

The maximum number of columns that the dashboard will allow to be added to the ‘Table’ chart type has increased from 100 to 200.

Upgraded Athena JDBC Driver to version 2.0.28:1000. Upgraded JDBC drivers will now contain an information file alongside them, as shown below.

It is now possible to host custom fonts locally in the Pi application, allowing them to be accessed and used offline. All standard fonts supplied with the dashboard are now hosted locally as standard. When adding a new font, it is now possible to download the necessary files, save them in the Pi application and use the locally hosted files to provide fonts in the dashboard. It is also still possible to use a URL for a font API as previously when adding new fonts.

For more information on how to add and remove fonts see Adding New Fonts and Removing Fonts

Fixed

Fixed an issue whereby the secret key was not being removed when exporting an Athena Data connection. The secret key now displayed as a randomised string in the export. Once the user imports this connection, the data connection will be shown as invalid due to the secret key no longer being valid. When updating the existing valid data connection, the secret key will be maintained.

Fixed an issue whereby connecting to a MariaDB database with the “Use SSL” option enabled would fail. Now, attempts to connect to a MariaDB database through SSL are configured correctly.

Resolved an issue with the horizontal scrollbar not working on iOS devices due to the changes in one of the iOS upgrades, which removed the support for the custom scrollbars. The horizontal scrollbar becomes available when the user touches and drags under the table.

The changes affect the standard, rotated, editable and crosstab tables that have measures. Please refer to the ‘Known Issues’ section below for the limitations.

Previously, when drilling from a chart to a category that has the same dimension object as a drop list picker, the value was not being inherited and so no filtering would take place and the drop list would instead function as if no or all options had been selected.

Now, drilling to a category will correctly apply the relevant filter to the drop list and all applicable charts in the category will be filtered by the expected value.

Handling of special characters in certain tooltips originating from i18n language files has been improved.

Previously: pie, doughnut, variable pie, and variable doughnut charts would only conditionally re-size to consume the full space of their container - while the container is reduced to a smaller size - when the container was reduced BOTH horizontally and vertically.

The dashboard now correctly resizes when the container is reduced EITHER horizontally or vertically. The image below shows how the container is reduced vertically, but not horizontally, yet the chart takes up the space of its container correctly.

Previously: when merging tables where all dimensions are shared between all the tables being merged, it would only merge on the first matching dimension and leave a series of empty cells in the table result.

We have now added a new algorithm which - upon the condition that all of the dimensions shared between the tables being merged have the same name and are coming from the same data connection - will now merge all the matching dimensions together correctly.

Additionally, it does not duplicate any measures shared between the tables being merged as it needs to when all dimensions do not match. See below:

This continues to work when you have filters/sorting to change the order of the dimensions, and if you have the dimensions/columns in different orders/positions on different tables. It works with any number of dimensions so long as they all match. It works with 2 or 3 tables being merged.

On top of this, when using this new algorithm, we have fixed a bug where if an additional data column exists in one table but is visible in another being merged, it correctly includes the column in the table - see the final column of the merged result - this bug, however, still persists when using the old algorithm where all dimensions do not match.

Known Issues

If you have a crosstab table that contains dimensions only, the horizontal bar will be invisible, and therefore some content could be missing if the chart container is too small to fit all the columns.

When using a mobile device to view the content in the dashboard (either iOS or Android), the horizontal scrollbar will not be available when viewing merged tables.

piSaaS Platform - Coming Soon

We are currently working on our next piSaaS release, which is likely to be availabe mid May 23, here are some highlights of what will be included.

• Controls around terminating piSaaS production instances

• User capability to manage images, themes, SVG, custom JDBC drivers

• Notifiction/Alerts if a piSaaS instance becomes inactive

Once the release has been made available in full, we will update this page with further details on all the changes.