ReadStatusTimephasedData slow

[ballycroy]

Hi,

I need to pull timephased data from project and I am using PSI calls
to do this. I have to make a call to get this information for each
assignment, which is very slow (in one case I have 50 assignments).
This is need for our project to display to managers as we have
integrated with a custom timesheet site we built. We do not want to
use the Timesheet services in project. In project 2003, there was a
table we could query directly to get this information using a stored
procedure (table is called MSP_WEB_WORK). Is this data stored in a
2007 table or is there a more efficient way of retrieving time phased
data for an individual. A database call would be the desired method.
Thanks!

 

[Stephen Sanderlin [MVP]]

The Reporting Database has several ByDay views... take a look at
MSP_EpmAssignmentByDay_UserView.

--
Stephen Sanderlin, Project MVP
VP of Technology
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com