Performance Issue - Time Management Overview - Workforce Management - Reported Time Cards Real Time

Summary:

A customer is experience Performance Issues in OTBI - Workforce Management - Reported Time Cards Real Time

';SELECT
0 s_0,
COUNT(DISTINCT "Workforce Management - Reported Time Cards Real Time"."Reported Time Cards"."Time Card Submitted Time") s_1
FROM "Workforce Management - Reported Time Cards Real Time"
WHERE
(("Time Card Status"."Time Card Status Name" = 'Submitted') AND ("Worker"."Manager User Name" = VALUEOF(NQ_SESSION."USER")))
FETCH FIRST 250001 ROWS ONLY

The Query Times out

HY000. Code: 60009. [nQSError: 60009] The user request exceeded the maximum query governing execution time. (HY000)

This similar to FUSION HCM Team Time Card fusion screen but as a tile on a LM dashboard