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
Tony, I learned about this anomaly the hard way. Is there any help for those of us still on Project Server 2010? If I new which field, from which table, in which DB to look for, then I could create a report. Any help would be appreciated.
Prasanna Adavi
Tom,
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
Thank you Prasanna. It seems like a great feature, and one that allows two perspectives on resource utilization: the project manager’s perspective and the resource manager’s perspective. Until now it required a convoluted workaround to isolate utilization data summaries to a project level.
Ahmed
Thank you Prasanna,
How can I generate such report using Project Professional 2013 .
Darryl Sly
Do you know which table this is in with project online, using odata?
Sunil Kumar Guntupalli
Hi Prasanna,
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.