Tuesday, August 21, 2012 6:36 PM
We do use Project Srvr.2010 with roghly 100 ressources and approximately 15 projects. For each single project i can get a standard (excel)report about ressource usage.
How can i get a report about ressource allocation taking all projects into account? actually it should look like the ressource allocation view in the ressource center, but only in excel.
plz advise, tnx!
Tuesday, August 21, 2012 6:52 PM
You could use the "ResourceCapacity" report under Sample reports in Business Intelligence Center. you could even make some modifications per your need.
Alternatively, you could use this technique to build your own report: http://www.mpug.com/News/Pages/Building_a_Resource_Usage_Report_in_ProjectServer2010.aspx#.UDPY5qmPW30
Prasanna Adavi, PMP, MCTS http://thinkepm.blogspot.com
Tuesday, August 21, 2012 8:23 PM
I would agree with Prasanna. Using the Sample Report "Resource Capacity" would be your best bet. Or you could make your own report using Excel Services functionality. It would bring you a long way. And you could create a similar report as in the resource center but only without the capacity line in it.<o:p></o:p>
With Kind Regards,<o:p></o:p>
Technical Consultant EPM