CA PPM: Baseline information in the Data Warehouse DWH

Document ID : KB000113480
Last Modified Date : 10/09/2018
Show Technical Document Details
Issue:
I am creating an Ad Hoc report and using the Project Domain.  I need to ensure I get the original baseline hours and cost. Not sure which of the attributes are the original ones.
 
Resolution:

The DWH only brings in the current baseline slices. 

The following table and attributes can be queried to show current baseline hour and cost:

DWH_INV_SUMMARY_FACTS: BASE_EQUIP_COST
DWH_INV_SUMMARY_FACTS: BASE_EQUIP_HOURS
DWH_INV_SUMMARY_FACTS: BASE_EXPENSE_COST
DWH_INV_SUMMARY_FACTS: BASE_LABOR_COST
DWH_INV_SUMMARY_FACTS: BASE_LABOR_HOURS
DWH_INV_SUMMARY_FACTS: BASE_MATERIAL_COST
DWH_INV_SUMMARY_FACTS: BASE_TOTAL_COST
DWH_INV_SUMMARY_FACTS: BASE_TOTAL_HOURS
DWH_INV_SUMMARY_FACTS: EAC_BASE_COST_PCT
DWH_INV_SUMMARY_FACTS: EAC_BASE_COST_VAR
DWH_INV_SUMMARY_FACTS: EAC_BASE_HOURS_PCT
DWH_INV_SUMMARY_FACTS: EAC_BASE_HOURS_VAR