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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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

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

Summary:

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.

Register

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