P6 - Role Utilization / Primavera - Role Utilization
Description: Use this subject area to analyze role utilization details for resources.
Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
Fact - Primavera - Role Utilization | Costs |
|
| Costs |
|
Fact - Primavera - Role Utilization | Costs | Actual Cost | Fact | Actual Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.ACTUAL_COST |
Fact - Primavera - Role Utilization | Costs | Actual Overtime Cost | Fact | Actual Overtime Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.ACTUAL_OVERTIME_COST |
Fact - Primavera - Role Utilization | Costs | Actual Regular Cost | Fact | Actual Regular Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.ACTUAL_REGULAR_COST |
Fact - Primavera - Role Utilization | Costs | At Completion Cost | Fact | At Completion Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.AT_COMPLETION_COST |
Fact - Primavera - Role Utilization | Costs | Planned Cost | Fact | Planned Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.PLANNED_COST |
Fact - Primavera - Role Utilization | Costs | Remaining Cost | Fact | Remaining Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.REMAINING_COST |
Fact - Primavera - Role Utilization | Costs | Remaining Late Cost | Fact | Remaining Late Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.REMAINING_LATE_COST |
Fact - Primavera - Role Utilization | Costs | Staffed Remaining Cost | Fact | Staffed Remaining Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.STAFFED_REMAINING_COST |
Fact - Primavera - Role Utilization | Costs | Staffed Remaining Late Cost | Fact | Staffed Remaining Late Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.STAFFED_REMAINING_LATE_COST |
Fact - Primavera - Role Utilization | Costs | Unstaffed Remaining Cost | Fact | Unstaffed Remaining Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.UNSTAFFED_REMAINING_COST |
Fact - Primavera - Role Utilization | Costs | Unstaffed Remaining Late Cost | Fact | Unstaffed Remaining Late Cost | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.UNSTAFFED_REMAINING_LATE_COST |
Fact - Primavera - Role Utilization | Metrics |
|
| Metrics |
|
Fact - Primavera - Role Utilization | Metrics | # Of Projects | Fact | # Of Projects | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.PROJECT_WID |
Fact - Primavera - Role Utilization | Metrics | # Of Resources | Fact | # Of Resources | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.RESOURCE_WID |
Fact - Primavera - Role Utilization | Metrics | # Of Roles | Fact | # Of Roles | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.ROLE_WID |
Fact - Primavera - Role Utilization | Units |
|
| Units |
|
Fact - Primavera - Role Utilization | Units | Actual Units | Fact | Actual Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.ACTUAL_UNITS |
Fact - Primavera - Role Utilization | Units | At Completion Units | Fact | At Completion Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.AT_COMPLETION_UNITS |
Fact - Primavera - Role Utilization | Units | Limit | Fact | Role Limit | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.LIMIT |
Fact - Primavera - Role Utilization | Units | Planned Units | Fact | Planned Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.PLANNED_UNITS |
Fact - Primavera - Role Utilization | Units | Primary Resources Limit | Fact | Primary Resources Limit | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.PRIMARY_RESOURCES_LIMIT |
Fact - Primavera - Role Utilization | Units | Remaining Late Units | Fact | Remaining Late Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.REMAINING_LATE_UNITS |
Fact - Primavera - Role Utilization | Units | Remaining Units | Fact | Remaining Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.REMAINING_UNITS |
Fact - Primavera - Role Utilization | Units | Staffed Remaining Late Units | Fact | Staffed Remaining Late Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.STAFFED_REMAINING_LATE_UNITS |
Fact - Primavera - Role Utilization | Units | Staffed Remaining Units | Fact | Staffed Remaining Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.STAFFED_REMAINING_UNITS |
Fact - Primavera - Role Utilization | Units | Unstaffed Remaining Late Units | Fact | Unstaffed Remaining Late Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.UNSTAFFED_REMAINING_LATE_UNITS |
Fact - Primavera - Role Utilization | Units | Unstaffed Remaining Units | Fact | Unstaffed Remaining Units | Value Derived From : Fact_W_ROLE_LIMIT_F_Role_Limit.UNSTAFFED_REMAINING_UNITS |
|
|
|
|
|
|
Role Folder |
|
|
|
|
|
Role | General - (Role) |
|
| General Role Information |
|
Role | General - (Role) | Datasource Id | Dimension | A unique source Id created for the Primavera data source being used. Used to identify data sources when using multiple Primavera data sources. | Value Derived From : Dim_W_ROLE_D_Role.DATASOURCE_ID |
Role | General - (Role) | Role ID | Dimension | A short code which uniquely identifies the role | Value Derived From : Dim_W_ROLE_D_Role.ROLE_SHORT_NAME |
Role | General - (Role) | Role Name | Dimension | The name of the role | Value Derived From : Dim_W_ROLE_D_Role.ROLE_NAME |
Related Topics
P6 - Activity / Primavera Activity
P6 - Activity History / Primavera - Activity History
P6 - Activity Period Actuals / Primavera - Activity Period Actuals
P6 - Burn Down / Primavera - Burn Down
P6 - Project History / Primavera - Project History
P6 - Resource Assignment / Primavera - Resource Assignment
P6 - Resource Assignment History / Primavera - Resource Assignment History
P6 - Resource Period Actuals / Primavera - Resource Period Actuals
P6 - Resource Utilization / Primavera - Resource Utilization
P6 - Spread Snapshot History / Primavera - Spread Snapshot History
P6 - Work Planning / Primavera - Work Planning
Last Published Friday, December 8, 2023