Scheduler

  • Fix – Teams Webhooks stopped working due to Microsoft changing the URL format in Jan 2025. This is now caught and shown as an error message explaining that the URL needs to be recreated.
  • Add – New option to shrink Materialized Query Databases. This is useful in keeping the database and log file sizes from growing to big and running out of disk space on the Database Server.
  • Add – New Materialized Query Table refresh option called Override Output Values.  This is useful when creating consolidated opening balance transactions in your MQ Table.  For example, the MQ Table can have details ledger transaction for the year 2024 onwards but just have consolidated transactions for all previous years.  In this case you can override a few Output Values like the Journal Number, Transaction Date etc to reduce the number of records.  This means the reports can still use Year to Date calculations but drill to transactions would only be valid for the current year.  This reduces the overall size and sync time of the MQ Table as the opening balance for historical data would only need to be refreshed once a year.

Publisher

  • Fix – Layouts were broken in a recent build and they were not refreshing correctly.
  • Fix – Spreadsheet number formats with currency symbols like Euros, Pounds and Yen were not displaying correctly.

Query Builder

  • Add – Expression called StatisticsAverage(DataPoint,MovingPoints,dataSeriesList) to complement the existing expressions called StatisticsGrowth() and StatisticsForecast().   StatisticsAverage take a series of values and calculate the running average or a moving average where you can specify how many points of data the moving average is to include. There are three ways the data series can be passed to the function.  One is to make a comma delimited list e.g. StatisticsAverage( DataRowCount(),0,”100,200,300,400,500,600″).  The second is to use a Sub Query and one of it’s output names e.g. StatisticsAverage( DataRowCount(),3,”S153012.Amount”).  Lastly one can set the data as parameters up to 32 slots.  e.g. StatisticsAverage( DataRowCount(),3,{%Jan},{%Feb},{%Mar},{%Apr},{%May},{%Jun},{%Jul},{%Aug},{%Sep},{%Oct},{%Nov},{%Dec})
  • Add – Filter option to Hide Outputs to complement Show Obscured Outputs.  Using this option the user can choose which output columns to hide in a report.  The Show Obscured Outputs is the reverse of this logic where the report has various obscured output columns and the user can choose to make them visible and, in this way, add more details to the report.

Foundry

  • Fix – Resources Folder did not deploy correctly when the Foundry project was compiled on computers that were not the original development computer.