Unifier - Earned Value Management (Unifier) / Primavera - Earned Value Management (Unifier)
Description: Use this subject area to analyze a project's planned value, earned value, actual costs, and the estimated cost at completion.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Project | EVM Analysis - (Project) | EVM Analysis and P6 Project Information | |||
| Project | EVM Analysis - (Project) | Data Date | Dimension | The data date for the P6 project | Dim_W_EVM_ANALYSIS_D_EVM_Analysis.DATA_DATE |
| Project | EVM Analysis - (Project) | EVM Analysis Name | Dimension | The name of the EVM analysis | Dim_W_EVM_ANALYSIS_D_EVM_Analysis.EVM_ANALYSIS_NAME |
| Project | EVM Analysis - (Project) | EVM Analysis Object Id | Dimension | The Unique ID of the EVM analysis | Dim_W_EVM_ANALYSIS_D_EVM_Analysis.EVM_ANALYSIS_OBJECT_ID |
| Project | EVM Analysis - (Project) | P6 Project Id | Dimension | The Project Id of the P6 project | Dim_W_EVM_ANALYSIS_D_EVM_Analysis.P6_PROJECT_ID |
| Project | EVM Analysis - (Project) | P6 Project Name | Dimension | The P6 project name | Dim_W_EVM_ANALYSIS_D_EVM_Analysis.P6_PROJECT_NAME |
| Project | EVM Analysis - (Project) | Refresh Date | Dimension | The refresh date for the EVM analysis | Dim_W_EVM_ANALYSIS_D_EVM_Analysis.REFRESH_DATE |
| Fact - Primavera - Earned Value Management (Unifier) Folder | |||||
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | Metrics | |||
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | AC | Fact | AC | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.AC |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | BAC | Fact | BAC | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.BAC |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | CPI | Fact | CPI | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.CPI |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | CSI | Fact | CSI | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.CSI |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | CV | Fact | CV | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.CV |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | EAC | Fact | EAC | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.EAC |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | ETC | Fact | ETC | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.ETC |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | EV | Fact | EV | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.EV |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | Forecast | Fact | Forecast | Value Derived From : Fact_W_EVM_F_Earned_Value_Management."FORECAST" |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | PV | Fact | PV | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.PV |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | Remaining Cost | Fact | Remaining Cost | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.REMAINING_COST |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | SPI | Fact | SPI | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.SPI |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | SV | Fact | SV | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.SV |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | TCPI1 | Fact | TCPI1 | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.TCPI1 |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | TCPI (BAC) | Fact | TCPI (BAC) | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.TCPI_BAC |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | TCPI (EAC) | Fact | TCPI (EAC) | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.TCPI_EAC |
| Fact - Primavera - Earned Value Management (Unifier) | Metrics | VAC | Fact | VAC | Value Derived From : Fact_W_EVM_F_Earned_Value_Management.VAC |
| WBS Folder | |||||
| WBS | WBS Hierarchy - (WBS) | WBS Hierarchy | |||
| WBS | WBS Hierarchy - (WBS) | WBS Code (Project Level) | Dimension | A short code assigned to each WBS element for identification. Each WBS element is uniquely identified by concatenating its own code together with its parents codes | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.PROJ_LEVEL_SHORT_NAME |
| WBS | WBS Hierarchy - (WBS) | WBS Name (Project Level) | Dimension | The name of the WBS element | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.PROJ_LEVEL_NAME |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 1 | Dimension | WBS ID Level 1 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV1 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 10 | Dimension | WBS ID Level 10 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV10 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 11 | Dimension | WBS ID Level 11 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV11 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 12 | Dimension | WBS ID Level 12 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV12 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 13 | Dimension | WBS ID Level 13 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV13 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 14 | Dimension | WBS ID Level 14 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV14 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 15 | Dimension | WBS ID Level 15 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV15 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 16 | Dimension | WBS ID Level 16 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV16 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 17 | Dimension | WBS ID Level 17 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV17 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 2 | Dimension | WBS ID Level 2 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV2 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 3 | Dimension | WBS ID Level 3 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV3 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 4 | Dimension | WBS ID Level 4 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV4 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 5 | Dimension | WBS ID Level 5 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV5 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 6 | Dimension | WBS ID Level 6 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV6 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 7 | Dimension | WBS ID Level 7 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV7 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 8 | Dimension | WBS ID Level 8 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV8 |
| WBS | WBS Hierarchy - (WBS) | WBS ID Level 9 | Dimension | WBS ID Level 9 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_ID_LV9 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 1 | Dimension | WBS Name Level 1 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV1 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 10 | Dimension | WBS Name Level 10 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV10 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 11 | Dimension | WBS Name Level 11 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV11 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 12 | Dimension | WBS Name Level 12 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV12 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 13 | Dimension | WBS Name Level 13 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV13 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 14 | Dimension | WBS Name Level 14 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV14 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 15 | Dimension | WBS Name Level 15 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV15 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 16 | Dimension | WBS Name Level 16 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV16 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 17 | Dimension | WBS Name Level 17 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV17 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 2 | Dimension | WBS Name Level 2 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV2 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 3 | Dimension | WBS Name Level 3 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV3 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 4 | Dimension | WBS Name Level 4 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV4 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 5 | Dimension | WBS Name Level 5 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV5 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 6 | Dimension | WBS Name Level 6 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV6 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 7 | Dimension | WBS Name Level 7 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV7 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 8 | Dimension | WBS Name Level 8 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV8 |
| WBS | WBS Hierarchy - (WBS) | WBS Name Level 9 | Dimension | WBS Name Level9 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier.WBS_NAME_LV9 |