Project Server 2003 and Sharepoint 2003

J

JimmyFo

Hi folks, not sure where to post this: I am trying to do two things:

1) Take data from a Project Server 2003 installation (tasks and who
they are assigned to, projects, etc) and have them displayed in a
Sharepoint 2003 installation in a list.

2) Take two of these created lists and merge them to a "parent" list
of sorts, where the data is joined and visible in a single list.

Is there any way to do this? I know that SP 2007 can merge lists, but
how about in 2003? And getting data from PS2003 seems extremely
difficult, I haven't yet found a way to access tasks with PDS.

Thanks,
James
 
B

Ben Howard

Hi James, without lots of custom development this is not possible. However,
this type of data can be stored in the OLAP cube that builds with 2003, but
you would have to extend the cube to include tasks (2007 does this OOTB).
There is an SDK article on extending the cube to include tasks if you are
dev, or you could by a commercial cube extender which will do it for you.
Then you can get at the task data by resource. It won't bring it into a
sharepoint list, but it will give you agregated data that you can work with.
 
J

JimmyFo

Hi James, without lots of custom development this is not possible. However,
this type of data can be stored in the OLAP cube that builds with 2003, but
you would have to extend the cube to include tasks (2007 does this OOTB).
There is an SDK article on extending the cube to include tasks if you are
dev, or you could by a commercial cube extender which will do it for you.
Then you can get at the task data by resource. It won't bring it into a
sharepoint list, but it will give you agregated data that you can work with.
--
Thanks, Ben.http://appleparkltd.spaces.live.com/









- Show quoted text -

Yeah, from what I could tell, it didn't look easy by any means - I
hadn't found anything about an OLAP cube though, so I will look into
it.

Thanks for the time -
James
 
Top