Open

We are pleased to present our latest offering of Pi - our March 2022 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

Sub-query will enable users to introduce charts as filter values, this means that charts are run as sub-queries which will help build the data of the main chart.

How does Sub-query work:

• when using an in/not in operator - the first column of the data from the sub-chart is used (this may contain multiple values)

• top/bottom operator - when using a top/ bottom operator, the option to select a chart to filter on will not be available

• single value operator e.g. Like - the first data point (first row of the first column) is used as the filter value

After selecting what you want to filter on and the operator you want to use you will then be able to select from data or a chart when picking the value. The type of charts allowed to be used as sub-query are similar to the options that you can select from when using merged charts/ tables. If a chart can be used as a sub-chart of a merged chart or table, it can be used as sub-query. This means that

• lines, bars, tables are allowed

• pies, special shapes, maps, merged charts/tables and so on can not be used

The ‘Type to filter’ screen has now been split into two sections - Data and Charts. The Data screen is used in the same way as it was previously (please see this page for more information).

New functionality has been added to support multi-select parent filters for most of the Cartesian chart types and data tables. Users will be able to select multiple chart blocks/ table rows and apply these filters as a list to other elements on the same category, the items selected will be identified on the parent chart with highlighting.

In addition to this, users will also be able to select multiple Legend items on a parent chart as a filter. This will filter all other charts/ data tables on the same category and highlight the selected values on the Legend itself.

We have added a new data connection type to the dashboard for SQream, allowing you to connect the dashboard to a SQream database. Configuration options include:

• Ability to enable SSL

• Ability to enable clustering

• Ability to specify a service (‘sqream’ is selected by default)

Open

Session synchronisation can now be enabled through Tomcat clustering. A new section has been added to the configuration tool GUI, which will allow the user to specify if they wish to have session sync turned on with the option to specify both Broadcast and Listening Ports:

Open

If enabled, a number of .xml files will be amended in the Tomcat folder, which will enable session synchronisation. The files which will be rewritten are as follows;

• INSTALLATION_DIR/Dashboard/tomcat/conf/server.xml

• INSTALLATION_DIR/Dashboard/tomcat/conf/context.xml

• INSTALLATION_DIR/Dashboard/tomcat/webapps/pi/WEB-INF/web.xml

• INSTALLATION_DIR/Dashboard/tomcat/webapps/panMISDashboardWebServices/WEB-INF/web.xml

As a part of this feature, a few changes have been made to configuration tool GUI as well, which will now display collapsed Proxy, Session Sync and Advanced options in the tomcat config tab.

Open

New functionality in this release will allow users to make categories scrollable. Users will be able to alter the height of a selected category by choosing from Default, 1.5x or 2x height options. If one of the larger sizes is chosen, a scrollbar will be automatically added to the category. This has been introduced to allow users to add more charts to the selected category without having to reduce their size in order to display them.

The option to change category height will be available when creating new categories or editing existing categories.

Open