Loading...
Quick Links

Calculating Cost Based on Cost Rates from Project Server 2010 Reporting Database

Home Forums Discussion Calculating Cost Based on Cost Rates from Project Server 2010 Reporting Database

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #2262 Reply
    CommunityCommunity
    Keymaster

    The January 24th edition of MS’s Best practices for submitting and reporting on actual work (Project Server 2010) (link) recommends using submitted actual work from timesheets, instead of project plans, for timephased reporting.

    The dbo.MSP_TimesheetActual, found in the …PWAReporting database, contains resource time worked by day, but lacks any rate or cost information.

    In the same MS article, they state, “While many calculations are made in a project plan, such as cost based on cost rates, these can be easily replicated with timesheet data.”

    Can anyone tell me where, in the …PWAReporting database, I can find the cost rates-by time-per resource so I can “easily replicate” the cost figures that are found in the Project Plan’s dbo.MSP_EpmAssignmentByDay table?

    #6772 Reply
    CommunityCommunity
    Keymaster

    As a workaround, you can use assignment work and cost to calculate the hourly rate.  This will only work if you are using single entry mode as you need to protect assignments from being deleted.  Hopefully someone will have a better answer that doesn’t require custom code.  Otherwise I agree with the previous answer provided.

    #10521 Reply
    CommunityCommunity
    Keymaster

    I don’t think Resource rates are exposed in the Reporting db. If you want to work with them you will need to develop PSI code against Proejct Server, or VBA in Project Pro.

Viewing 3 posts - 1 through 3 (of 3 total)
Reply To: Calculating Cost Based on Cost Rates from Project Server 2010 Reporting Database
Your information: