Release Name - pi.2023_04_27
Release Date -
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 include any detail the platform changes we have made /are making to piSaaS as we continue to evolve the solution.
| Info |
|---|
Before upgrading, we always recommend that you review ALL release notes, from the version you are considering upgrading from and to. This is essential should there be a material change that could impact you or your customers. Where possible, upgrading to a test instance first can be helpful. |
| Note |
|---|
Before attempting an upgrade, you should always backup your repository. This allows you to quickly roll back should you wish or need to. You can find more information on how to do that here. |
Here’s what’s Here is what is included in the release;.
| Table of Contents |
|---|
Added
Item 1
Gitlab
ZenDesk
Area of Dasboard
Add text here
Item 2
Gitlab
ZenDesk
Area of Dasboard
Add text here
Item 3
Gitlab
ZenDesk
Area of Dasboard
Add text here
Changed
Item 1
Gitlab
ZenDesk
Area of Dashboard
Add text here
Item 2
Gitlab
ZenDesk
Area of Dashboard
Add text here
Item 3
Gitlab
ZenDesk
Area of Dashboard
Add text here
Fixed
Item 1
Gitlab
ZenDesk
Area of Dashboard
Add text here
Item 1
Gitlab
ZenDesk
Area of Dashboard
Add text here
Item 1
Gitlab
ZenDesk
Area of Dashboard
Changed
Remove HSQL to MariaDB migration reference from migrations | migrations-jar#20 | - | Migrations |
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.
Maximum number of columns in a table increased from 100 to 200 | pi#1553 | 22505 | Tables |
The maximum number of columns that the dashboard will allow to be added to the ‘Table’ chart type has increased from 100 to 200.
Upgrade to Athena JDBC driver | pi#1672 | - | Data Connector |
Upgraded Athena JDBC Driver to version 2.0.28:1000. Upgraded JDBC drivers will now contain an information file alongside them, as shown below.
Ability to host custom fonts locally | pi#1491 | 23463 & 19718 | Fonts |
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
Import/Export does not remove Secret Key for an Athena data connection | pi#1562 | 24217 | Data Connection Import/Export |
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.
Issue connecting to MariaDB over SSL | pi#1552 | 23801 & 23815 | Data Connection |
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.
Horizontal Scroll does not work on iOS devices | pi#1560 | 23998, 25061 & 25380 | Data Tables |
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.
Drill to Category failing to select the expected value in a Drop List category object | pi#1574 | 24833 | Drill To Chart |
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.
Improved special character handling on tooltips from i18n | pi#1573 | 24884 | Language / Tooltip |
Handling of special characters in certain tooltips originating from i18n language files has been improved.
Pie chart only taking up full space of its container when container is small enough BOTH horizontally and vertically, when it should be either or | pi#1649 | - | Chart Viewer |
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.
Merged tables need merging correctly when all dimensions match | pi#1517 | 17958 & 18924 | Merged Tables |
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
Horizontal scroll does not work on crosstabs with dimensions | pi#1646 | - | Data Tables |
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.
Horizontal scroll does not work on merged tables on mobile | pi#1644 | - | Data Tables |
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.
| Info |
|---|
|