none
Baseline work by resource in database RRS feed

  • Question

  • Hi,

    We are not able to find baseline work by resource in Reporting database. Any ideas?

    We need to calculate work variance by resource, not by project or task.

    Thanks in advance!

    Thursday, February 6, 2014 4:10 PM

All replies

  • Hi E_FG,

    Are you using PS2010 or 2013?

    Please look at dbo.MSP_EpmAssignment_UserView table in the Reporting DB.

    Also download the SDK with full RDB schemas documentation here:

    http://www.microsoft.com/en-us/download/details.aspx?id=15511

    Hope this helps.


    Guillaume Rouyre - MBA, MCP, MCTS

    Thursday, February 6, 2014 4:45 PM
    Moderator
  • Thanks Guillaume, but that table only gives work variance by assignment, not by resource... And adding them up doesn't make sense.

    PS: We are using Project Server 2010

    Friday, February 7, 2014 1:21 PM
  • Try downloading the free Project SDK and reading the Reporting db schema.It shows what's in all available reporting db tables.

    I think you need to create a view grouped by Resource UID to sum work from the dbo.MSP_EpmAssignmentBaseline or dbo.MSP_EpmAssignmentBaselineByDay tables.

    Rod Gill
    Author of the one and only Project VBA Book
    www.project-systems.co.nz

    Saturday, February 8, 2014 11:47 PM
    Moderator