Deleting Users and Resources, how it impacts timesheets

[m2mteck]

Hi,
I've reviewed the information in the "Implementing and Administering MS
Office Project Server 2007" bible about how to do this and what happens, it's
great info but I didn't see anything about on what happens to the timesheets
and timesheet OLAP cubes where the resource exists.

I'm assuming the timesheet data is a separate table and the data will stay
in tack if I delete an ex-employee resource, is that correct? I would test
this myself but the restore doesn't seem very pretty. I do know if I
delete a project, I can still run my timesheet data analysis and see the
timesheets data on that project which is why I assume deleting users will
work the same way.

 

[Jonathan Sofer [MVP]]

Timesheets have their own set of tables for holding resources and project
references. Deleting resources and projects from PS will not delete these
timesheet references. This data will only be visible in the timesheet olap
cubes.

Jonathan