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

OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date column

Received Response
edited Sep 21, 2023 2:39PM in Reporting and Analytics for HCM 4 comments


This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards.

Content (required):

1- Response time of reports built using "Workforce Management - Workforce Trend Real Time" can be improved by applying following report-filter:

"Time"."Calendar Month End Date" IN (date '2021-11-30',date '2021-12-31',date '2022-01-31',date '2022-02-28',date '2022-03-31',date '2022-04-30')

2- Please note that the report_filter needs to strictly use "IN" operator. Any other operator such as between, less-than, greater-than etc will not yield desired performance improvement.

Howdy, Stranger!

Log In

To view full details, sign in.


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