Clarity PPM: DWH_TME_ENTRY_FACTS table is missing data

Document ID : KB000124240
Last Modified Date : 09/01/2019
Show Technical Document Details
Issue:
The DWH_TME_ENTRY_FACTS table is missing data. There should be multiple entries for every week for each person entering their time.
Why is there missing data?
 
Cause:

Has there been any recent opening and closing of time periods recently?

Run the following query to see if there is any missing data:

select * from DWH_TME_ENTRY_FACTS_V

Resolution:

Make sure the full Load DWH job has recently completed.

Run the following query to check:

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