Enterprise Fields and Regular Reporting

[Haluk]

We are using MS Project 2003 and Project Server 2003. We have couple of
projects. We have defined some enterprise fields for our projects. We would
like to take weekly reports of projects and their status in terms of these
enterprise fields.
Is it possible to take such a regular report and show all project status in
terms of enterprise fields in a sheet or file?
Thank you.

 

[Krishna Alavala]

Hi Haluk

Yes, it is possible. It all depends on the what enterprise fields you have
used. Can you run the query in database?

If it is text field you need to link to msp_text_fields, it it outline
msp_code_fields and msp_outline_fields.

or you can use Project Web Access, create a view with the enterprise fields
and access them.

Thanks
Krishna

 

[Haluk]

Hi Krishna,

We cannot access to the database directly. What we need is not just the
snopshot of time. We need the historical info as well. For example lets say
our field is called as X and we have 2 projects with the names A and B. We
need to see the projects progress in time as :
Field X Week-1 week-2 Week-3 Week-4 Week-5
Project A 0.6 0.6 0.7 0.8 0.9
Project B 0.3 0.3 0.5 0.5 0.6

We want such an management review for all projects.

 

[Dale Howard [MVP]]

Haluk --

When you created the custom fields for the projects, did you create them as
custom enterprise Project outline codes? If so, you could probably extract
the project information you seek in a Portfolio Analyzer view. Hope this
helps.

 

[Krishna Alavala]

Hi Haluk

You want historical data. In order to achieve this you need to need to go
the database and dump the data (by scheduling the job) into sperate table at
the end of the week. Get the report from that table. Otherwise I don't think
it is possible.

Thanks
Krishna

 

[Haluk]

Dale,

Yes. However important point in our issue is to take the historical data of
a project. Let say our field is X and our projects are called A and B. We need
Week-1 Week-2 Week-3
Project A 0.5 0.6 0.6
Project B 0.4 0.5 0.7

Is it possible?

 

[Dale Howard [MVP]]

Haluk --

I am assuming the numbers represent % Work Complete for each project. To
accomplish this, you would need to create a custom calculation called
Progress or something like that, and the formula would be Actual Work/Work.
Why don't you try creating a custom Portfolio Analyzer view and see where
that leads you?