P6 - Resource Utilization / Primavera - Resource Utilization

Description: Use this subject area to analyze resource utilization details including actual, available, planned, remaining, at completion, and resource limit units.

Folder	Subfolder	Field Name	Dimension/ Fact / Lookup	Description	Values Derived From / Calculated By
Fact - Primavera - Resource Utilization	Metrics			Metrics
Fact - Primavera - Resource Utilization	Metrics	# Of Resources	Fact	# Of Resources	count(distinct Fact_W_RESOURCE_LIMIT_F_Resource_Limit.RESOURCE_WID)
Fact - Primavera - Resource Utilization	Usage/Capacity			Usage/Capacity
Fact - Primavera - Resource Utilization	Usage/Capacity	Actual Units	Fact	The actual number of units incurred	Value Derived From : Fact_W_RESOURCE_LIMIT_F_Resource_Limit.ACTUAL_UNITS
Fact - Primavera - Resource Utilization	Usage/Capacity	At Completion Units	Fact	The sum of the actual units and remaining units for the resource assignment on the activity. Calculated as Actual Units plus Remaining Units.	P6Core."Fact - Resource Utilization"."Actual Units" + "P6Core"."Fact - Resource Utilization"."Remaining Units"
Fact - Primavera - Resource Utilization	Usage/Capacity	Available Units	Fact	Available Units	Value Derived From : Fact_W_RESOURCE_LIMIT_F_Resource_Limit.AVAILABLE_UNITS
Fact - Primavera - Resource Utilization	Usage/Capacity	Limit	Fact	Limit	Value Derived From : Fact_W_RESOURCE_LIMIT_F_Resource_Limit.LIMIT
Fact - Primavera - Resource Utilization	Usage/Capacity	Planned Units	Fact	The planned units of work for the resource assignment on the activity.	Value Derived From : Fact_W_RESOURCE_LIMIT_F_Resource_Limit.PLANNED_UNITS
Fact - Primavera - Resource Utilization	Usage/Capacity	Remaining Units	Fact	The remaining units of work to be performed by the resource on the activity. Calculated as Planned Units minus Actual Units.	Value Derived From : Fact_W_RESOURCE_LIMIT_F_Resource_Limit.REMAINING_UNITS