Delete old timesheets - please help!

[Rickard]

We've been using the timesheet function in PWA 2007 for a couple of years
now, and lately we've noticed it takes a very long time for a user to create
a new timesheet. It's probably because of all the old timesheets stored in
the Project Server databases, so we're planning to delete some of them (in
Server Settings - Delete Enterprise Objects - Timesheets). My question is;
could this have any effect on our published projects actual work (the
timesheet data has been imported to the projects tasks earlier and maybe some
kind of synchonization will delete the data as well)?

Another question; we need to create copies of some of the timesheet tables
(in the Project Server 2007 Reporting database) before removing the old
timesheets because the data needs to be included in many of our SQL Reporting
Services reports. Is it okay to create these "copies" in the Reporting
database or could that mess up anything?

 

[Jonathan Sofer [MVP]]

I'm not saying your approach of deleting old timesheets is right or wrong
but here are some insights into your questions.

1) Deleting timesheets should not affect actuals that exist in the project
schedule. The timesheet tables store data separately from the project
actuals.
2) Probably not a good idea to create custom tables in the reporting
database directly. Upgrades and hot fixes might cause an issue with custom
tables in the future. Best to probably create a separate database and
change the SQL Reports to read across from the reporting database to the
custom database.

Jonathan

 

[Rickard]

Thank you Jonathan, I really appreciate your help!
Good news! After removing some of the old timesheets it takes less time to
create new timesheets.

 

[Jonathan Sofer [MVP]]

Great, I'm glad you were able to get the result you wanted.

Jonathan