November 2023 Official Release (5.0.0.59)

What's New
, ,
1

New Version 5.0.0.59 - 11/08/2023 :tada:

This release we added support for the Planning Analytics TM1ELLIST formula, made several enhancements to our writeback capabilities and enhanced our support for copying groups of worksheets that have formula references to each other. The full release notes are copied at the bottom of this post. Call out to quality control as we’re now up to 1,243 Integration & Regression Tests!

Ready to upgrade?
Simply head to the Software Version tab in ReportWORQ and choose the option to download and run the latest Official Release!

image
image1019×704 63.9 KB

New Audit Logging :spiral_notepad:
The major new addition for this release is the introduction of Audit Logging. This new audit file contains structured data and is designed to be read by a log viewer application or to integrate into an enterprise tool such as Splunk. Terse Audit logging will be enabled by default upon upgrading and will retain 90 days worth of logs. The audit file can be found in the ReportWORQ Repository Directory.

image

Copying groups of worksheets with cross references
This new feature already has a dedicated forum article located here: New Feature - Support for copying groups of worksheets that reference each other. With this feature you can now use ReportWORQ parameters to make a copies of a group of worksheets that have formulas referencing each other. A good example of this is a data worksheet and a report worksheet, where the report worksheet summarizes and presents the data.

image

Data Collection
For our Data Collection customers, we now have support for providing different credentials for distribution and data collection. Upon upgrading, the current distribution credentials will be copied for the data collection configuration, then this can be modified by editing your datasource connection in the Integrations screen.

Spill Formulas
Do you use Spill formulas? In this release, we added support for the TM1ELLIST Spill formula. In order to support this we had to make some changes to how and when our calculation engine calculates and spills data. If you’re using Excel Spill formulas, such as FILTER, please take a moment to review reports with spill formulas to ensure that they run consistently from previous versions.

Release Notes: Downloads and Release Notes

Enhancements

  • Simplified management of all ReportWORQ users versus licensed users count.
  • Performance Enhancements made to AIInput formula processing.
  • Added support for Writeback using credentials other than Data Distribution.
  • Added support for Token-based Authentication in Workday Adaptive.
  • Added support for Planning Analytics Application folders as a ReportWORQ Source Report Provider.
  • Support added for TM1ELLIST function.
  • Added support for copying worksheets, with dependencies, as a group.
  • Activity audit logging has been added and can be configured on the Settings screen.

Fixes

  • Fix error when filter parameter in TM1RPTFILTER function is missing.
  • Fixed issue updating Azure app registration information.
  • Fix for ReportWORQ Bookmarks Offsetting by 1 page.
  • Fix for Excel Allow Edit Ranges not being copied when bursting a worksheet.
  • Fixed for Jobs failing to send when the email message contains bad recipients.
  • Fixed Hold for Delivery release action halting job processing.
  • Fix for Scheduler failing to run for folder selection.
  • Fix for Azure Identity security vulnerability CVE-2023-36414.
  • Fixed issue connecting to a Gen2 Oracle EPM Cloud Instance.
  • Fixed issues for some RWSORT formula use cases.
  • Fixed issue with Writeback email configuration reverting to the wrong email configuration option after ReportWORQ upgrade.