The DWH_TME_ENTRY_FACTS table is missing data. There should be multiple entries for every week for each person entering their time.
Release: All
Component: Clarity Data Warehouse (DWH)
This can happen if there was any recent opening and closing of time periods
Run the following query to see if there is any missing data:
select * from DWH_TME_ENTRY_FACTS_V
Run the following query to validate:
SELECT dwh_tme_entry_facts.PERIOD_KEY,
dwh_tme_entry_facts.TIME_HOURS,
dwh_tme_entry_facts.TIMEENTRY_KEY,
DWH_CMN_PERIOD.PERIOD_START_DATE
FROM dwh_tme_entry_facts
INNER JOIN DWH_CMN_PERIOD
ON DWH_TME_ENTRY_FACTS.PERIOD_KEY = DWH_CMN_PERIOD.PERIOD_KEY
--AND DWH_TME_ENTRY_FACTS.PERIOD_KEY IN (x,y,z)
order by period_start_date
If the issue still persists:
truncate table rpt_calendar;
See also: Load DWH job frequently reported issues