Unifier - Resource Cost Summary / Primavera - Resource Cost Summary
Description: Use this subject area to analyze resource costs. You can capture and view resource cost information based on a timescale, such as quarterly or yearly.
| Folder | SubFolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From |
|---|---|---|---|---|---|
| Project | Baseline - (Project) | Project Baseline | |||
| Project | Baseline - (Project) | Baseline Data Date | Dimension | The data date of the baseline project | Dim_W_PROJECT_BASELINE_D_Project_Baseline.DATA_DATE |
| Project | Baseline - (Project) | Baseline Name | Dimension | The name of the baseline project | Dim_W_PROJECT_BASELINE_D_Project_Baseline.BASELINE_NAME |
| Project | Baseline - (Project) | Baseline Type | Dimension | The type of the baseline project | Dim_W_PROJECT_BASELINE_D_Project_Baseline.BASELINE_TYPE |
| Fact - Primavera - Resource Cost Summary Folder | |||||
| Fact - Primavera - Resource Cost Summary | Costs | Costs | |||
| Fact - Primavera - Resource Cost Summary | Costs | Baseline Actual Cost | Fact | Baseline Actual Cost | Fact_W_RESOURCE_COST_F_Resource_Cost.BL_ACTUAL_COST |
| Fact - Primavera - Resource Cost Summary | Costs | Baseline At Completion Cost | Fact | Baseline At Completion Cost | Fact_W_RESOURCE_COST_F_Resource_Cost.BL_AT_COMPLETION_COST |
| Fact - Primavera - Resource Cost Summary | Costs | Baseline Planned Cost | Fact | Baseline Planned Cost | Fact_W_RESOURCE_COST_F_Resource_Cost.BL_PLANNED_COST |
| Fact - Primavera - Resource Cost Summary | Costs | Baseline Remaining Cost | Fact | Baseline Remaining Cost | Fact_W_RESOURCE_COST_F_Resource_Cost.BL_REMAINING_COST |
| Fact - Primavera - Resource Cost Summary | Costs | Current Actual Cost | Fact | Current Actual Cost | Fact_W_RESOURCE_COST_F_Resource_Cost.CURR_ACTUAL_COST |
| Fact - Primavera - Resource Cost Summary | Costs | Current At Completion Cost | Fact | Current At Completion Cost | Fact_W_RESOURCE_COST_F_Resource_Cost.CURR_AT_COMPLETION_COST |
| Fact - Primavera - Resource Cost Summary | Costs | Current Planned Cost | Fact | Current Planned Cost | Fact_W_RESOURCE_COST_F_Resource_Cost.CURR_PLANNED_COST |
| Fact - Primavera - Resource Cost Summary | Costs | Current Remaining Cost | Fact | Current Remaining Cost | Fact_W_RESOURCE_COST_F_Resource_Cost.CURR_REMAINING_COST |
| Fact - Primavera - Resource Cost Summary | Units | Units | |||
| Fact - Primavera - Resource Cost Summary | Units | Baseline Actual Units | Fact | Baseline Actual Units | Fact_W_RESOURCE_COST_F_Resource_Cost.BL_ACTUAL_UNITS |
| Fact - Primavera - Resource Cost Summary | Units | Baseline At Completion Units | Fact | Baseline At Completion Units | Fact_W_RESOURCE_COST_F_Resource_Cost.BL_AT_COMPLETION_UNITS |
| Fact - Primavera - Resource Cost Summary | Units | Baseline Planned Units | Fact | Baseline Planned Units | Fact_W_RESOURCE_COST_F_Resource_Cost.BL_PLANNED_UNITS |
| Fact - Primavera - Resource Cost Summary | Units | Baseline Remaining Units | Fact | Baseline Remaining Units | Fact_W_RESOURCE_COST_F_Resource_Cost.BL_REMAINING_UNITS |
| Fact - Primavera - Resource Cost Summary | Units | Current Actual Units | Fact | Current Actual Units | Fact_W_RESOURCE_COST_F_Resource_Cost.CURR_ACTUAL_UNITS |
| Fact - Primavera - Resource Cost Summary | Units | Current At Completion Units | Fact | Current At Completion Units | Fact_W_RESOURCE_COST_F_Resource_Cost.CURR_AT_COMPLETION_UNITS |
| Fact - Primavera - Resource Cost Summary | Units | Current Planned Units | Fact | Current Planned Units | Fact_W_RESOURCE_COST_F_Resource_Cost.CURR_PLANNED_UNITS |
| Fact - Primavera - Resource Cost Summary | Units | Current Remaining Units | Fact | Current Remaining Units | Fact_W_RESOURCE_COST_F_Resource_Cost.CURR_REMAINING_UNITS |
| Resource Cost Folder | |||||
| Resource Cost | Dates - (Resource Cost) | Resource Cost Dates | |||
| Resource Cost | Dates - (Resource Cost) | Actual Finish | Dimension | Actual Finish | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.ACTUAL_FINISH |
| Resource Cost | Dates - (Resource Cost) | Actual Start | Dimension | Actual Start | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.ACTUAL_START |
| Resource Cost | Dates - (Resource Cost) | At Completion Finish | Dimension | At Completion Finish | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.AT_COMPLETION_FINISH |
| Resource Cost | Dates - (Resource Cost) | At Completion Start | Dimension | At Completion Start | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.AT_COMPLETION_START |
| Resource Cost | Dates - (Resource Cost) | Planned Finish | Dimension | Planned Finish | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.PLANNED_FINISH |
| Resource Cost | Dates - (Resource Cost) | Planned Start | Dimension | Planned Start | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.PLANNED_START |
| Resource Cost | Dates - (Resource Cost) | Remaining Early Finish | Dimension | Remaining Early Finish | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.REMAINING_FINISH |
| Resource Cost | Dates - (Resource Cost) | Remaining Early Start | Dimension | Remaining Early Start | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.REMAINING_START |
| Resource Cost | Durations - (Resource Cost) | Resource Cost Durations | |||
| Resource Cost | Durations - (Resource Cost) | Actual Duration | Dimension | Actual Duration | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.ACTUAL_DURATION |
| Resource Cost | Durations - (Resource Cost) | Planned Duration | Dimension | Planned Duration | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.PLANNED_DURATION |
| Resource Cost | Durations - (Resource Cost) | Remaining Duration | Dimension | Remaining Duration | Dim_W_RESOURCE_COST_LINE_D_Resource_Cost_Line.REMAINING_DURATION |
| Resource Cost | General - (Resource Cost) | General Resource Cost Information | |||
| Resource Cost | General - (Resource Cost) | Creation Date | Dimension | The date the summary sheet was created | Dim_W_SUMMARY_SHEET_D_Summary_Sheet.CREATION_DATE |
| Resource Cost | General - (Resource Cost) | Creator | Dimension | The name of the user that created the summary sheet | Dim_W_SUMMARY_SHEET_D_Summary_Sheet.CREATOR_FULLNAME |
| Resource Cost | General - (Resource Cost) | Data Date | Dimension | The date the summary sheet was last modified | Dim_W_SUMMARY_SHEET_D_Summary_Sheet.DATA_DATE |
| Resource Cost | General - (Resource Cost) | Description | Dimension | The description of the summary sheet | Dim_W_SUMMARY_SHEET_D_Summary_Sheet.DESCRIPTION |
| Resource Cost | General - (Resource Cost) | Last Modified | Dimension | The date the summary sheet was last modified | Dim_W_SUMMARY_SHEET_D_Summary_Sheet.LAST_MODIFIED |
| Resource Cost | General - (Resource Cost) | Schedule Title | Dimension | The title of the summary sheet | Dim_W_SUMMARY_SHEET_D_Summary_Sheet.TITLE |
| Resource Cost | General - (Resource Cost) | Schedule Type | Dimension | The schedule type | Dim_W_SUMMARY_SHEET_D_Summary_Sheet.DATA_TYPE |
| Resource Cost | General - (Resource Cost) | Type | Dimension | The summary sheet type | Dim_W_SUMMARY_SHEET_D_Summary_Sheet.TYPE |
| Resource Folder | |||||
| Resource | General - (Resource) | General Resource Information | |||
| Resource | General - (Resource) | Resource ID | Dimension | A short code which uniquely identifies the resource | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_ID |
| Resource | General - (Resource) | Resource Name | Dimension | The name of the resource | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_NAME |
| Resource | General - (Resource) | Resource Type | Dimension | Indicates whether the resource is labor, nonlabor, or material | Value Derived From : Dim_W_RESOURCE_D_Resource.RESOURCE_TYPE |
| Resource | General - (Resource) | Unit of Measure | Dimension | Resource unit of measure | Value Derived From : Dim_W_RESOURCE_D_Resource.UOM |
| Unifier Links Folder | |||||
| Unifier Links | Go to Unifier Links | ||||
| Unifier Links | Link to P6 Summary Sheets | Dimension | The link to the project P6 Summary Sheets page in Unifier |
'<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) || '&k=analyticsp6summary">' || 'Link to P6 Summary Sheets' || '</a>'
|
|
| Unifier Links | Link to Project | Dimension | The link to the project landing page in Unifier |
'<a target="_blank" href="' || VALUEOF(NQ_SESSION."DW_UNIFIER_LINK_BASE_URL") || VALUEOF("DW_UNIFIER_LINK_PROJECT_LIST_BASE_URL") || CAST ("P6Core"."Dim - Project"."Project Object Id" AS VARCHAR ( 10 )) || '&k=analyticsproject">' || 'Link to Project' || '</a>'
|