PS 2007 Reporting Database

T

TroyS

Does the Reporting Database get updated immediately? OR is there some sort of
job that runs ?

I've created a Resource Text Field (Employee Number) and i'm not seeing it
in Project_Reporting Database....

Is there a schema definition out there from microsoft that tells us where
number/formula/text fields end up at in Project_Reporting Database?
 
B

Ben Howard

The reporting db is updated when a project is published, and it takes its
feed from the published db and relevant WSS db. Therefore, I would expect
you would have to publish a project before you see this.
 
T

TroyS

I tried publishing a project that had a resource in question with the newly
added Resource Field and i'm still not seeing where the Project_Reporting has
the field at?

This is a Resource Level Text Field called Employee Number. I don't see in
which table or view this should be in as it is not a lookup table. We are
expecting to have to interface time from Project Server 2007 to finanicals
and would need to map the Employee Number.
Of course there are other Resource fields to map in an interface.

Any other ideas on how to locate it in the Reporting db?
 
R

Rod Gill

Hi,

The best way to see custom fields in the Reporting db is to use the Views.
The Views ending with _userview all have custom fields automatically added
to the end of their list of columns. I think therefore to see your Resource
Custom field look at the View msp_Resources_userview (or similar!).

--

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
 
T

TroyS

Thanks so much... that is indeed where the field is at...
MSP_EPMResource_UserView
 
Top