Open

We are pleased to present our latest offering of pi - our April 2021 release! This page helps summarise and familiarise you with the changes we have made, and is supported (where applicable) with useful videos to help explain the changes we have delivered.

Here’s what we’ll cover;

Added

Windows installer will now copy Maria data (from db folder) and themes (from themes folder) and place them alongside the installer into a new clean install. This can be used to setup a pre-customised installation and can also be used with the silent installer for unattended use.

Changed

Description

When Multi-Picker has been selected in a Category Object filter users were previously only able to select one Default Value. The April release of the Dashboard now allows users to pick multiple values from the Default Value field. When users return to the relevant category the Multi-Picker chosen values will appear in the Category Filter section as Default Values.

Screenshots

The following screenshot shows multiple values selected in the Default Value section under Category Objects.

Open

Video

We’ve created a short video to explain this in a bit more detail.

The ‘Help’ option now links, by default, to pi Documentation, where you can search for and find frequently used articles and see our newest content.

Screenshots

The ‘Help’ option can be seen by clicking the ‘More Options’ icon at the top-right of the dashboard.

If you don’t want to use the ‘Help’ option, remove the URL from the ‘System Variables: General’ section on the ‘Setting’s tab under ‘Dashboard Configuration’

Video

This short video shows how you use the ‘Help’ feature and also prevent the option from appearing.

Warnings/ Alerts

This feature will only appear if you do a clean install of the dashboard and do not restore any repositories. If you already have a repository that has a link to an online help URL, the current URL will not be removed or replaced.

Fixed

Description

Charts that contain Targets that are created from a Redshift database were not being displayed correctly. The Targets on the chart were all displayed as 0.

Description

When using a Cross Tab table in the Dashboard that contains a header with special characters, Measure values were not being displayed in the Cross Tab table.

Description

A problem where PostgresSql objects displaying as [object Object] instead of the correct DB values has been fixed in this release. With this change the user does not need to do manual casts for special types from postgresSql.

Description

Schedules in dashboards with the old scheduling system will now be migrated into to the new scheduling system on upgrade.

• The migration will happen automatically on upgrade if there are old schedules (in mis_dashboard_schedules) AND there are no new schedules (in pi_schedules).

• All migrated schedules will be set to suspended, the user will need to reactivate any schedules they wish to keep running.

• Scheduled KPIs will not be migrated as KPIs are no longer supported.

Description

When a Parent Table has been filtered, any sorting options used on a table header in the Parent Table was not being retained.

Screenshots

The following screenshot shows a filtered version of a Parent Table on the right and also shows how the sort order on the ‘Decimals’ column in the Parent Table on the left has been maintained.

Description

A fix has been made to the response of the new API role creation endpoint. Previously successful creation returned the id of the newly created role, in addition it will now also return the whole object with every available field matching the API documentation.

Description

A problem where the API was returning 404 error with new created users has been resolved - this was caused by old flex columns having default as null.

Description

With the introduction of the new table library users were unable to resize columns, this has now being fixed and users will be able to resize a column to whatever size they need.

Video

We’ve created a short video that explains this fix.

When a schedule has been created for the last day of the month it will run correctly on months that have less than 31 days.

• April, June, September and November - last day of the month schedules will run on the 30th

• February - last day of the month schedules will run on the 28th (or 29th in Leap Years)

Last day of the Month schedules will run on the 31st for all other months.

Keeping An Eye On pi