DWH_INV_SUMMARY_FACTS fields calculation

Document ID : KB000125025
Last Modified Date : 23/01/2019
Show Technical Document Details
Question:
I would like to know where Data Warehouse fields in DWH_INV_SUMMARY_FACTS come from:
EAC_TOTAL_COST
ACTUAL_COST
 
Answer:
DWH_INV_SUMMARY_FACTS table:

EAC_TOTAL_COST Total estimate at completion cost from assignments.
It will take and add data from the combined assignments on the investment.

ACTUAL_TOTAL_COST Total actual cost from financial transactions.
ACTUAL_LABOR_COST Actual cost from financial transactions where the transaction type is Labor.
ACTUAL_LABOR_HOURS Actual labor hours from assignments.

The data gets collected from Assignments, and then summarized to Investment level.