PANINT-6499 Variables can now be flagged as secure and used for database username and password. Secure variables will not work in locations other than those. Use of secure variables for database username and/or password will disable any connection pooling for that connection. To improve security and facilitate a smooth upgrade any global variables used in data connection usernames will be upgraded to secure variables.

PANINT-8780 Added a docker health check to the all in one docker container and each individual container, except the database container. The health check checks the relevant process and the “/version” endpoint to report if the service is up and OK. Running docker ps will give a list of running containers, showing their health. Running docker inspect <container_id> will provide further information on the container health.

PANINT-8731 Currently the size of text in Card chart types changes depending on the size of the cell. There is now an option to turn on/off auto scale. Turning this option on will scale the content to fit the size of the chart, any sizes defined on the card chart (text size, custom HTML style sizes) will be proportional to the chart cell size.

PANINT-8676 Pi pi Analytics is now referred to as pi Predict Predicts in all user visible text.

PANINT-8729 A ‘Reset All Category’ filters button has been added to the navigation bar. The Category Object reset button has been removed with this release. The ‘Reset All Category’ filter button will reset:

• Category Objects to default values

• Parent filters to none

• Temporary filters to none

• Drilldowns to the top level

PANINT-7303 Dimension Subtotal Breaks. This functionality creates a sub total at each break in items in a Dimension. This works by sorting the data in a dimension into ascending order (although the sort order can be changed on the Sorting tab) and a sub total is then added at each change in data.

PANINT-8653 Dynamo DB Connector

To use this connection, you will need:

• To specify the AWS region that you want to connect to

• AWS credentials

  • Access key ID (for connecting to the Dynamo DB service) – entered as your Username

  • Secret access key (corresponding to your access key ID) – entered as your Password

A Product Licence will be required for the connector, which can be obtained from https://www.simba.com/product/amazon-dynamodb-drivers-with-sql-connector/ 

PANINT-8884 Advanced Tomcat setting “Maximum Spare Threads” removed because it is no longer supported by Tomcat

PANINT-8771 When users have changed one of our default themes, during an installation the following will happen:

• Windows – a backup is taken of the themes folder before an upgrade. Users will be able to retrieve a modified piTheme from the backup folder if they made changes to it

• Linux – when upgrading, only user created themes will be copied into the new dashboard

• Docker – when upgrading, all piThemes will be overwritten

PANINT-8389 Table libraries changed from Handsontable to Ag-grid Community Version. Changing a table library is a critical change and as such your tables may feel and look slightly different than before. With this change we have fixed many issues we had previously with Handsontable and we have also successfully implemented one of our ROADMAP items Hierarchical Data Grids / Dimension Sub Total Breaks you can find information on this implementation in the Added section under PANINT-7303.

Ag-grid by default contains a padding-left and padding-right of 13px this is necessary because when there’s only vertical scroll on a Ag-grid table, instead of drawing the vertical scroll bar outside the table it draws it directly inside the table. This means that if we override the default values of padding-left and padding-right to a value lower then 13px the vertical scroll bar will draw on top of the cell content. If you are affected by this then you would need to change your themes padding settings on .pi-style__table-body-cell so it’s bigger than 13px. We created Migration for themes, that replaced padding:5px into padding-top:5px and padding-bottom:5px, but if a user has additional styling changes to our default theme then they would need to check to see if they need to apply the changes above.

Due to browser security improvements, embedding charts in other applications using Chrome may require HTTPS and extra cookie configuration. Support can provide further assistance if required.

PANINT-8766 Sub Total Data is not displaying correctly with a top ten filter on Measures.

REN-9 An issue on older upgraded Windows deployments where Excel export columns were hidden has now been resolved

PANINT-8688 Fixed Chart Fetch From DB run times not showing in MIS_AUDITS. We also added a new audit type for recording the Total time spent to fetch a chart.

PANINT-8764 Fixed redirectToDefaultCategoryState functionality not applying Date Range Category Objects correctly into iframe Categories due to missing locale on urls.

PANINT-8763 If a Crosstab tables had row totals and colour was then also applied to the same measure the data in the table was not displayed correctly, this has been fixed by changing the table library.

PANINT-8397 The Rotated Table chart type was not displaying row Headers correctly, this has been fixed by changing the table library.

PANINT-8452 When right-hand alignment had been used on Column Headers, the sorting arrow that should have been visible at the top of the column was not displayed correctly, this has been fixed by changing the table library.

PANINT-6720 HANDSON ISSUE. Column totals were not always displayed correctly when scrolling in Data grids, this has been fixed by changing the table library.

PANINT-7702 HANDSON ISSUE. Table totals were not always displayed, this has been fixed by changing the table library.

PANINT-7629 HANDSON ISSUE. Table chart scroll issue causing cells to not align correctly, this has been fixed by changing the table library.

PANINT-7625 HANDSON ISSUE. Duplicated Table totals were displayed when scrolling or when the data was too close to the bottom of the chart, this has been fixed by changing the table library.