How To Obtain Baseline Information in the Data Warehouse DWH

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Baseline object is not included in the DWH by default.

How can this information be obtained?

 

Environment

Release: All 

Resolution

The DWH only brings in the current baseline slices. For more detailed information on historical baseline information, see Article ID: 107884.

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

Additional Information

The following query can be used:

select usage_sum/3600 from prj_baseline_details where
baseline_id in (5xxxxxx, 5xxxxxx)
and object_type = 'PROJECT'

The following tables can also be joined:
prj_baseline_details
prj_baselines