You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

Tuning a rolling 12 Months turnover report

edited Oct 9, 2020 5:17PM in Reporting and Analytics for HCM 4 comments

Summary

How to performance tune a trend based report when using Ago and Rolling Period

Content

Hello Experts!

In my ongoing saga of working with the trends subject area to build a turnover report I've hit the next stumbling block. I've successfully created a rolling period turnover calculation but the report takes 7 minutes to run which isn't acceptable.

 

Our turnover Metric is calculated by taking the sum of terminated headcount for the past 12 months and dividing by the average between the period open headcount from 12 months ago and the period end headcount from this month. From my testing, the calculations are working as expected but the analysis takes too long to run. I'm already using a subquery as recommended by Raghu in a previous post but I'm not sure if there's more tuning I can do.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!