Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Project Server 2007: Resource Usage View Displays Incorrect Work Values

Posted on 2009-07-08
Medium Priority
Last Modified: 2013-11-15
In testing various project plans in MS Project Server 2007, weve found that the Work numbers on the Resource Usage view arent correct for the other projects on the server.  Ive done some looking and found the three postings below.  Can you tell me if there is a fix for this yet or if there is one planned?  Given the size of our department, opening all the plans the resources are in isnt going to be a reasonable solution.   If there isnt a fix or a planned fix, do you have any suggestions on how to get the total resource allocation / availability information?  Keep in mind that we dont plan on letting Project do the resource leveling for us; we just want to know who is over allocated so we can have the discussions on how to best resolve the issues.
Id like to make sure I understand the issue with the Resource Usage view.  When we open up a project plan (that has been published on the server) and look at the other projects on the view, the Work numbers dont look correct.  To me, this means that I cant really tell if someone is over allocated or not.  Is my understanding correct?

Here are the posts I found:
The ability to determine over allocations and availability is a huge piece of our project so I would greatly appreciate any help or direction you could offer.  

Question by:Patrick_Anderson
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 13

Expert Comment

ID: 24824284
Generally only Microsoft people will know what fixes are on the way. You may want to get a support case logged with Microsoft Support: This will help this issue get attention, and should help you get a notification if the issue is resolved in a future fix.

Dale's advice is good, in the last link you posted. He suggests that Project Pro shouldn't be used for Resource Allocation (Turn off Load Summary Assignments in the Project Server Connection dialog.)

 View Availability views (from the Resource Center in PWA), Data Analysis views, and SQL Server Reporting Services (SSRS) can all provide this information. SSRS requires some development/SQL skills, but the first two options are relatively simple.

Please let me know if you'd like more details on these.
James Fraser

Author Comment

ID: 24824829
Thank you for your comments.
Since posting the question I found a possible solution from Microsoft.  Please take a look and see if you agree.

Any examples of the Data Analysis views or SSRS reports would be appreciated.
LVL 13

Accepted Solution

jbfraser earned 2000 total points
ID: 24824940
I haven't evaluated that Hotfix, but the problem resolved certainly looks like the problem you and the posts above mentioned.

For creating a Data Analysis view, you need to create a calculated member for availability. Instructions are at:
(Make sure to read the two comments, they address errors in the instructions.)
Although the instruction page looks intimidating,  you can safely ignore most of it, and just use the first formula provided for availability.
Then this field can be added as a measure to any Data Analysis view.

SSRS can do similar things but with a huge amount of flexibility; Resource capacity is available in the reporting database, and then you can subtract what ever work you want from that to get availability. For example, you could make an "Other Projects" report that asks the user what project they are managing, and then, for every resource assigned to that project, lists (and/or totals) their work in other projects. The trade off here is that you will need some SQL development and SSRS familiarity to build this.

I'm not able to share any code for this, all the related code I have belongs to my company and my clients.

James Fraser

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.


Author Comment

ID: 24825041
Thanks.  I'll take a look at the site you provided and let you know how it works out.

Author Comment

ID: 24897798
Just wanted to let you know I'm still working on testing this (as I get time).  

Author Comment

ID: 24925444

I have created a reporting cube with the basic calculation for availability from the link you provided (thank you).  I can create the report and everything seems to run just fine.  The problem is that Im not sure I understand what the data is telling me.  
I want to create a report that lists each resource, the projects they are working on and what percent they are allocated to that project by month.  We are needing to see who is over allocated in the next 6 to 18 months so that we can work on fixing those problems.  On the flip side of that I also want a report that lists the projects and the resources that are assigned to them (with percent allocation by month).  The other projects example you mentioned sounds very close to what Im needed.  I understand you cant give me the code but could you give me screen shots of the output?  
I appreciate your help.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question