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

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

Viewing 2 reply threads
  • Author
    Posts
    • #2262
      lucas madeira
      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
      lucas madeira
      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
      lucas madeira
      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 2 reply threads
  • You must be logged in to reply to this topic.