DWH_INV_SUMMARY_FACTS fields calculation
Article ID: 125025
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
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.
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.
Feedback
Powered by
