Assignment values on the time scale of the Resource Allocations and Assignments report are incorrect after running an incremental instance of the Load Data Warehouse (DWH) job.
Load DWH job produces inconsistent data tables results. The incremental job runs successfully but produces different data table values & counts between each hourly run
This is due to fact records being removed from the DWH_INV_ASSIGN_PERIOD_FACTS table in the Data Warehouse.
Steps to Reproduce:
Expected Results: The two queries above still return the same results
Actual Results: The Clarity query returns the same results, but the DWH query returns 0 rows
Caused by DE48508
Release: 15.6, 15.6.1, 15.7
Component: Clarity Data Warehouse
DE48508 is fixed in 15.7.1 and also in patch 126.96.36.199 and higher.
Workaround: Run a full load instance of the Data Warehouse job as this will re-include the missing fact records.