none
Resource Allocation Report RRS feed

  • Question

  • Hello guys,

     

    I have looking at the cubes, dimension and measures that come along with project server 2010, I have observed that on measures carters for reporting on the allocation status of a resource i.e over-allocation or  otherwise. How can I generate a report thats shows the allocation of a resource?

     

    Thank you

    Tuesday, December 28, 2010 12:59 AM

Answers

  • Hi,

    The information you are after should be available from the reportingdb, specifically checking out the assignment tables (i.e. tasks with resources assigned). There are special epm_resource tables that there are more tailored at the the available capacity.

    Apologies, but I don't have a local SQL instance available to check and am doing this from the reportingdb schema overview in the SDK (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=46007f25-b44e-4aa6-80ff-9c0e75835ad9&displaylang=en).

    Hope this helps,

     


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    • Marked as answer by ghostme Tuesday, December 28, 2010 4:02 PM
    Tuesday, December 28, 2010 4:33 AM
    Moderator