see milesone dates across multiple projects

J

John Horton

I am looking for a view that lets me see milestone dates across multiple
projects. I have looked at using the Cube but since there is not an
associated recourse it does not work. I know I could use SRS or MDX but we do
not have a programmer in house.

Any Ideas?
 
P

Paul Conroy

Certainly SRS would be the best method, however you could achieve the same in
PWA by creating a master project containing all the projects you want to
report on. Then create a project view which filters for all tasks with a
duration of 0d. Open this view for the master project.

This is far from ideal and would need some ongoing maintenance to
add/remove/publish projects from the master. You also need to consider the
performance implications of managing a potentially large plan.

HTH

Paul
 
J

John Horton

Gary,
You are a genius! That solution is so simple, obvious and fool proof.

John Horton
 
J

John Horton

after more thought . . .

I have over 100 projects so if I create a master milestone file with 3 or 4
milestones from each file will I stress the data base? Are external links
really different them internal links?
 
R

Rod Gill

As I find Excel VBA easy, I would use an enterprise field to flag the
Milestones you want reported. I would then add a View to the Reporting db
that showed the Project name, milestone name and dates you are interested
in. Base the View on the View epm_Task_UserView as it includes all custom
fields so you can filter on the enterprise flag you created.

In Excel I would then use oledb to read the contents of that View into a
worksheet so you can manually format it.

--

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
 
J

John Horton

Ok Rod,
You lost me. I can tag the task easy enough. Past that I have no idea what
you are saying. Again I am not really a programer. I do write a but of VBA
but thought I needed .Net to do much with server data.

John Horton
 
Top