Unable to get some VIEW's in Project Server 2007 !!

[Psk]

Hi,

I am using project server 2007, in earlier version 2003 i have used some
VIEWS that are
MSP_VIEW_PROJ_ASSN_TP_BY_DAY,
msp_view_proj_tasks_cf,
msp_view_proj_assn_std.

But i am unable to use the same above VIEWS in the version 2007.

If any one help me out, really useful. Thanks in Advance ..

Regards,
Psk

 

[Ray McCoppin]

The Following table/views should have the same and more data in them.
MSP_EpmAssignmentByDay
MSP_EpmTask_UserView
MSP_EpmAssignment_UserView

These are not the same schema.

Hope this Helps
--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts
ULS Log Reporting for Project Server 2007

 

[Guest]

Hello Psk,

The bad news is that the tables you are looking for do not exist
or are at least are not available in the same way on projeject server 2007.

The good news is that the data you are looking for is probably available
in the Reporting Database on your new project server.

I would suggest the following:

First download the Project 2007 SDK and read through the section
titled "Using the Reporting Database". This will will give you a
good overview of the new architecture.

Then open the Reporting Database using SQL Server Management
Studio or SQL Server Enterprise Manager depending on which SQL
version you are using. Browse through the various tables and
views to familiarize yourself with what is available.

Avoid the temptation to access data in the Archive, Draft and Published
databases using SQL queries. They are not documented and Microsoft has
taken a hard stand against this practice. The information in these databases
should only be accessed through the PSI.

If you can't find a specific piece of data in the Reporting database or if you
can't figure out how to retrieve it through the PSI interface, ask for help in
this news group. Someone will be happy to help.

Bob Segrest

 

[Psk]

Thank you ALL !!
I can see the informations through following tables, but some of the
FIELDS(in project server 2003) are not able to identify on the table..

1. MSP_EpmAssignmentByDay
Missing Fields : ASSIGNMENTTIMESTART,ASSIGNMENTTIMEFINISH,
ASSIGNMENTTIMEACTUALWORK

2. MSP_EpmTask_UserView
Missing Fields : TASKTEXT30,CF_PROJECTUNIQUEID,CF_TASKUNIQUEID

3. MSP_EpmResource
Missing Fields : PROJ_ID

Note: The above missing fields are available on the earlier version(Project
server 2003), but the related tables in Project server 2007 as per your
knowdlge i could not get those missing fields here..

Kindly suggest me !! more helpful..

Regards,
Psk

 

[Psk]

Hi Ray McCoppin,

Thanks for your input !!
I can see the informations through following tables, but some of the
FIELDS(in project server 2003) are not able to identify on the table..

1. MSP_EpmAssignmentByDay
Missing Fields : ASSIGNMENTTIMESTART,ASSIGNMENTTIMEFINISH,
ASSIGNMENTTIMEACTUALWORK

2. MSP_EpmTask_UserView
Missing Fields : TASKTEXT30,CF_PROJECTUNIQUEID,CF_TASKUNIQUEID

3. MSP_EpmResource
Missing Fields : PROJ_ID

Note: The above missing fields are available on the earlier version(Project
server 2003), but the related tables in Project server 2007 as per your
knowdlge i could not get those missing fields here..

Kindly suggest me !! more helpful..

Regards,
Psk

 

[Psk]

Thanks for your input !!
I can see the informations through following tables, but some of the
FIELDS(in project server 2003) are not able to identify on the table..

1. MSP_EpmAssignmentByDay
Missing Fields : ASSIGNMENTTIMESTART,ASSIGNMENTTIMEFINISH,
ASSIGNMENTTIMEACTUALWORK

2. MSP_EpmTask_UserView
Missing Fields : TASKTEXT30,CF_PROJECTUNIQUEID,CF_TASKUNIQUEID

3. MSP_EpmResource
Missing Fields : PROJ_ID

Note: The above missing fields are available on the earlier version(Project
server 2003), but the related tables in Project server 2007 as per your
knowdlge i could not get those missing fields here..

Kindly suggest me !! more helpful..

Regards,
Psk

 

[Rod Gill]

Hi,

Try the View MSP_EpmAssignmentByDay_UserView

and

MSP_EpmAssignment_UserView

The Epm resource view won't have a project ID as it lists all enterprise
resources. Assignments define what resources are on what tasks in what
project. MSP_EpmResource_UserView is better than the table as all _UserView
views automatically have all custom fields appended to the end of them.


--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Psk]

Hi,

Great !! I can able to figure out the data. Only thing is i am strucking
for getting Task local custom field(text30) data. I have created local cf for
the project and i assigned the column as "cost category"(text30), value added
eg. 'MANAGEMENT'.

How can i get the local CF "text30" value on the particular project TASK
?. The earlier version 2003, i can get through "msp_view_proj_tasks_cf" in
"TASKTEXT30".

Regards,
Psk