Managing Closed Projects???

[Andrea]

Hi,

since we have implemented MsProject Server in January 2004, we have a long
list of projects on the server. Some of them are still open but some of them
are completed and must be closed. I don't think that Microsoft thought of a
way to close completed projects so that users won't see tasks coming from
projects that are closedin their time sheet.

In fact, we have a lot of complaints coming from users who have over a
thousand tasks in their time sheet and 50% of these tasks are coming from
completed projects.

Is there a way to manage completed project so that we can still see them in
the OLAP cube but not in timesheet.

Thanks for your help.
Andrea

 

[Dale Howard [MVP]]

Andrea --

If you want to leave the closed projects in the Project Server database and
still see the hours in the Portfolio Analyzer views, you can remove the
tasks for all closed projects from the timesheets of those projects' team
members by doing the following:

1. Open a closed project
2. Click Tools - Build Team from Enterprise
3. Set the Booking Type for each team member to Proposed
4. Click the OK button
5. Click Collaborate - Publish - All Information
6. Repeat steps 1-5 for every closed project

Hope this helps.

 

[Bryan Andrews]

Is there anything programmatically that can be done?

Seems like it would be simple enough to create a isClosed bit column and
alter the Stored Procedure to not show these by default...