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


  • 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 (

    Hope this helps,


    Alex Burton | 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