DWH_INV_SUMMARY_FACTS table: No data for Material and Expense resources

Products

• Clarity PPM On Premise
• Clarity PPM SaaS
• Clarity FedRAMP

Issue/Introduction

Material and Expense resource cost data is not populated on the DWH_INV_SUMMARY_FACTS table 

STEPS TO REPRODUCE:

1. Create a project
2. Add a Labor resource and a Expense, Material and Equipment type non-labor resources as Staff members
3. Create a task and assign all 4 members to the task and add some ETC
4. Add the rate matrix information to the project for the 4 type resources
5. Run the Rate Matrix Extraction job and Update Earned Value and Cost Totals job
6. At assignment, task and project level we can see the ETC Cost populated
7. Run the Load DWH job
8. Look at the DWH_INV_SUMMARY_FACTS table in the Data Warehouse. Look at columns like: etc_expense_cost, etc_material_cost, etc_equip_cost, etc_labor_cost  

Expected Results: Data is populated for all type of resources
Actual Results: Data is only populated for Labor and Equipment resources. Data for Material and Expense resources is not populated

Same happens to EAC Cost, Allocation Cost ... Only labor and Equipment data semes to be populated at the DWH_INV_SUMMARY_FACTS table

Environment

Clarity 16.2.3.5, Clarity 16.3.3, 16.4.0

Cause

DE176048

Resolution

Fixed in:

• Clarity 16.4.1
• Clarity 16.4.0 Patch 1 (16.4.0.1)
• Clarity 16.3.3 Patch 2 (16.3.3.2)

Additional Information

• In Broadcom SaaS Prod this will be fixed together with Production upgrade to 16.4.0 as per SaaS Upgrade Schedule