A Resource Manager came to me years ago with a perplexing issue. When she was looking at the allocation for a resource on a particular project, she could not figure out why the resource seemed allocated – even when the project schedule does not have any tasks assigned to that resource.
Long story short, after a lot of head scratching, I figured out that there was a project that was using a resource plan, as opposed to a project schedule to consume the resource’s availability. You can see below a screenshot from Project Server 2010, where there is no indication of whether the utilization was from a Resource Plan or Project Schedule.
If you have been in this scenario, you will know how painful it was to figure out where the utilization was coming from. Either you needed a custom report or you would have had to open each plan/resource plan to see where the utilization is coming from.
However, Project Online/Project Server 2013 has a cool feature improvement that will help this, as I describe below.
In this example, I built a resource plan for one of the projects. I made sure that I set the Resource Utilization to come from Resource Plan, and published it.
Now, when we look at the resource allocations/availability in Resource Center, we can clearly see where the utilization is coming from, as shown below.
A small improvement, but will help reduce confusion, and help the Resource Managers!
Tom Herrington
Prasanna Adavi
You could easily pull a report using this query:
select
Projectname,
ResourcePlanUtilizationType,
ResourcePlanUtilizationDate
from
MSP_EpmProject_UserView
The field ResourcePlanUtilizationType will indicate the utilization, with ‘1’ being resource plan, and ‘2’ being project plan. The ResourcePlanUtilizationDate will give you the date until which the Project Plan is used for calcuation, and when it will switch to Resource Plan.
Tim Shaw
Ahmed
How can I generate such report using Project Professional 2013 .
Darryl Sly
Sunil Kumar Guntupalli
I have few projects having ‘ResourceUtilizationType’ set to ‘Resource Plan’ and those Projects are not appearing in the ‘Resource Availability’. What could be the reason ?
Is there any way to set the ‘ResourceUtilizationType’ on a Project ?
Regards,
Sunil G.