Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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
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.
Tagged:
4