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?
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.
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.