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 |