Project Server 2007 Task Update Status

[David Baker]

Does anyone know of a way for me to setup a view that will enable my resource managers to view the status of task updates that have been submitted to the PM?

We require PM approval of task updates before timesheets can be submitted, and I would like the resource managers to see whether thier folks have submitted updates (imported from thier timesheets) to the PM and whether those update requests are pending, approved or rejected.

I can find any fields availabe in the resource assignments view that show (change requested, submission status, etc.) for tasks, nor do I see anything that I can build from the cube. It looks like there may have been an "Assingments view" in 2003 that would enable me to piece something together, though nothing similar in 2007?

As a PM, I can see the log of task request status by date so I know the data is in the system, I just need to pull something together and allow the Resource managers to have a similar view. Any ideas?





Submitted via EggHeadCafe - Software Developer Portal of Choice
Design Pattern Interview questions part 2
http://www.eggheadcafe.com/tutorial...20-2d3c3c35fb66/design-pattern-interview.aspx

 

[HansH]

Task updates do not get into the Reporting Database until they have been
approved, updated into the project and published.
This data is stored in the other databases, but as binary blobs.
Unfortunately, there is no way to report on the status of task updates.

I have been told that Microsoft has some plans to include a stored proc
in the Reporting Database to retrieve this kind of information, but so
far, I haven't seen it yet. Given the fact that this information also is
not available in the 2010 beta release, I suspect this stored proc will
never exist for 2007.

The way I have solved this for one customer is by creating an extension
using Server Side events. Every time a task update is saved, submitted
or approved, I store the task updates information in a separate
database. This database is used for reporting.
A small code sample that can serve as a solution starter is available on
my blog.

I hope this helps,
Hans

Projectopolis <http://msepm.hsquared.be>