There are many ways to improve the performance of reports in Workday. But when the usual methods failed, Agilysis took a creative approach to reduce report run time for a client.
The client had many Talent Management reports that used a ‘Date in Role’ calculation. This ‘Date in Role’ field was used to make employee related decisions such as movement, trainings, succession planning, etc.
The ‘Date in Role’ calculation was based on very complex logic with multiple conditions. Due to its complexity, it had a large impact on the run time performance of the reports in Workday. In some cases, the run time performance took hours while a few simply failed. Agilysis referred this issue to Workday, but all they could suggest was to reduce the complexity of the calculated field, which was not possible for the client.
Instead, we used a creative approach to develop an out-of-the-box solution.
In order to help the client address the challenge and improve report performance in Workday, we created a custom object, ‘Date in Role – All’. We also created two custom fields, ‘Date in Role’ and ‘Date in Role (exception cases)’, to store the ‘Date in Role’ value on the employee record.
Next, we built an integration with required logic to update the value in the ‘Date in Role’ custom field for all impacted employees. For exception cases, we updated the ‘Date in Role (exception cases)’ custom field via EIB for such employees.
Finally, we included in the required reports a ‘Date in Role’ calculated field that would pull values from the custom fields in the custom object.
This custom solution improved Workday report performance significantly. Reports that originally took over five hours now ran in minutes, and exception cases were being handled without any issue.