The 'Time Compliance Detail' report is missing the posted timesheets for the previous week. The Load Data Warehouse (DWH) (Full Load) has been run and completed successfully. However, the DWH_TME_SHEET table in the Data Warehouse is still missing the timesheets for last week (Period Starting 5/10/2020).
Release : All Supported
Component : CLARITY DATA WAREHOUSE
The DWH_CMN_PERIOD_V view is populated based on a combination of things such as:
To get the missing week's timesheets to be available it the data warehouse, the following needs to be done: