June’s release of ReportWORQ 5 has a short but exciting list of enhancements and fixes! We made a number of general improvements to our scheduling capabilities, as well as some datasource specific updates to IBM Planning Analytics and Workday Adaptive Planning that you can read more about below.
Some of the other highlights: Those of you who use Pivot Tables and Charts will be glad to know that ReportWORQ can now refresh those for you, too. We also added support for the RWSQLUPSERT formula for Excel OleDB and ODBC connections-- an “UPSERT” is a handy way of updating a record in a table, but in a way that automatically inserts the record it if it doesn’t already exist!
Lastly, we are delighted to share that we now have over 1,100 integration & regression tests passing in this release (1,119 to be exact!). Here’s the complete list of changes made in this release:
Enhancements
-
Added support to RWSQLUPSERT Formula for Excel OleDB and ODBC connections.
-
Added Last Run and Next Run time columns to the Scheduler screen.
-
Support added for refreshing Pivot Tables and Charts.
-
JSON API Specification has been updated for running ReportWORQ Jobs outside of ReportWORQ. Refer to the following documentation links to create new IBM Planning Analytics Turbo Integrator (TI) and Powershell scripts to run ReportWORQ Jobs:
Fixes
- Fixed issue with enabling a scheduled event running immediately instead of at the next scheduled time.
- Fix for some remote access login issues.
- Fix for Adaptive Access Rules not being applied properly on filters.
Upgrades from ReportWORQ 4.4
No changes or updates to ReportWORQ 4.4 were released this month. If you have not upgraded to version 5 and would like to discuss the path to upgrade, please contact us at support to schedule a discussion. Take a look at the following demo for a sample of the ReportWORQ 5 experience and features: