CA PPM Projects missing in DWH_INV_TEAM_PERIOD_FACTS table.

Document ID : KB000097733
Last Modified Date : 23/05/2018
Show Technical Document Details
Issue:
Many projects are missing in DWH_INV_TEAM_PERIOD_FACTS table in the Datawarehouse.
It does not matter if they are older projects or recent projects.  
Cause:
This happens when someone posts actual hours after their actual allocation finish.  
  -- Allocation finish is found on the Team page
Once there are actual hours after the allocation finish, and the load data warehouse completes,  the whole record is removed from the data warehouse.

This has been reported as DE41217.

Three views on the data warehouse are affected:


• dwh_inv_team_ru_per_facts_f_v
• dwh_inv_team_ru_per_facts_m_v
• dwh_inv_team_ru_per_facts_w_v
 
Resolution:
Resolution of DE41217 is scheduled for the next release  (15.4.1).