MSP_TIMEPHASED_DATA

[c.tambone]

Hello,

I have installed Project Server 2007 and Project Professional 2007 and
I need to retrieve timephased data directly using queries on the DB.
In Project 2003 I used the "expand timephased data" option in the File
Options Save dialog box in order to populate that table and then I
queried on the MSP_TIMEPHASED_DATA table.
In Project 2007 I find the table but it is always empty, how can I set
the same option that I do not find anymore in the File Options Save
dialog box, in order to retrieve the planned cost and actual cost,
planned work actual work TimePhased?

Is there any suggestion on how to do it?

Thanks in advance

Claudia

 

[Rod Gill]

If your projects are published to Project Server, then use the Project
Server Reporting database. There are tables in there that have one day per
task, resource or assignment which are much easier to use than the old
MSP_TIMEPHASED_DATA table.

In the reporting db look at all Views ending with "userview". These are very
useful as they automatically have all relevant custom fields added as extra
columns.


--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[c.tambone]

If your projects are published to Project Server, then use the Project
Server Reporting database. There are tables in there that have one day per
task, resource or assignment which are much easier to use than the old
MSP_TIMEPHASED_DATA table.

In the reporting db look at all Views ending with "userview". These are very
useful as they automatically have all relevant custom fields added as extra
columns.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
             http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
             http://projectservertraining.com/learning/index..aspx

---------------------------------------------------------------------------­-------------------------










- Mostra testo tra virgolette -

Thanks a lot, I will try immediately tomorrow!

Claudia