Skip to end of banner
Go to start of banner

April 2023 Dashboard Release Notes

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Current »


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 detail the platform changes we have/are making to piSaaS as we continue to evolve the solution.

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.

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 is what is included in the release.


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.


  • pi News - have a look at this area on our website, you’ll be able to see all the latest Panintelligence news

  • pi Documentation - this area is where we store all our documentation. Please take a look - you can see what’s been added recently in the ‘Recently Updated’ section on the Home Page or by clicking the Pages link on the left-hand side of the screen.

  • pi Community - this is an area where you can see recently asked questions and ask your own questions and connect with other pi users from other companies - designed to help you connect and get the most from our community of users. You can register for an account really quickly by clicking the link at the top right of the screen or if you prefer you can even ask a question without creating an account

  • Customer Portal - don’t forget to download the latest release from here.

  • SupportDesk - log all your support tickets and see what’s happening on your previously logged tickets through our Support Portal

  • pi Academy - try one of our training courses or watch one of our training videos

  • No labels