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.