DWH_INV_SUMMARY_FACTS fields calculation

book

Article ID: 125025

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise - Application STARTER PACK-CLARITY PPM Clarity PPM SaaS - Application Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction



I would like to know where Data Warehouse fields in DWH_INV_SUMMARY_FACTS come from:
EAC_TOTAL_COST
ACTUAL_COST
 

Environment

Release:
Component: ODDWH

Resolution

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.