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>'
|
Related Topics
Primavera Unifier Subject Areas
Unifier - Business Process / Primavera - Business Process
Unifier - Business Process History / Primavera - Business Process History
Unifier - Cash Flow / Primavera - Cash Flow
Unifier - Cash Flow History / Primavera - Cash Flow History
Unifier - Cost Sheet / Primavera - Cost Sheet
Unifier - Cost Sheet History / Primavera - Cost Sheet History
Unifier - Earned Value Management (Unifier) / Primavera - Earned Value Management (Unifier)
Unifier - Generic Cost Sheet / Primavera - Generic Cost Sheet
Unifier - Space Management / Primavera - Space Management
Unifier - Space Management History / Primavera - Space Management History
Unifier - Workflow / Primavera - Workflow
Last Published Friday, December 8, 2023