Loading...
Quick Links

Where is the Resource Utilization Coming From? – Project Online/Project Server 2013

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.

ResourceUtilization1

 

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.

ResourceUtilization2

ResourceUtilization3

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.

ResourceUtilization4

 

A small improvement, but will help reduce confusion, and help the Resource Managers!

 

 

Share This Post
6 Comments
  1. 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.

    Reply
  2. 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.

    Reply
  3. 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.

    Reply
  4. Thank you Prasanna,

    How can I generate such report using Project Professional 2013 .

    Reply
  5. Do you know which table this is in with project online, using odata?

    Reply
  6. 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.

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

Thanks for submitting your comment!
You must be logged in to comment.