Hide completed projects in Resource Availability Report...

[mike]

Is there any way to hide, or remove completed projects from the Resource
Availability report? We have projects where every task and the project as a
whole is 100% and the project range ended last month. In the Availability
Report, the resources who worked on the project, but completed all of their
tasks still have the projects listed, with 0 hours across the board. As we
continue to use this system, that list is going to get longer and longer,
which will make reading the details of each resource burdonsome. We could be
missing some proceedure of closing a project, but I have not found a
solution. Any help is greatly appreciated!

Thanks,
Mike

 

[.jussi]

Our EPM solution provider told us that you have to delete projects from the
active (published) project database as a maintenance job (manual) for this
exact reason. Our principle is that when a project has been complete for
three months, it is deleted from the active database. It still remains in the
reporting database for trend analysis etc.

If there is another answer, I'd be happy to hear it as well.

- Jussi

 

[mike]

Thanks for the reply .jussi. Do you have any further details on this? When
you say maintenance job, I would guess that you are talking about a SQL
maintenance job that runs an SQL script. Is this true? Do you have any
examples of the script?

Thanks again .jussi!
Mike

 

[Sean Hanson]

Mike, investigate archiving the project, this and removing from the Publish
and Draft DB are Admin activities, PWA - Server Settings - Schedule Backup,
Delete Enterprise Objects, if you need it back Administrative Restore.

Alternatively you could delete from Publish only, but someone could open it
up and publish it by accident.

Warning, deleting from Publish also deletes all history on
timesheets/updates from Reviewed Requests and Applied Requests and Errors.
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting