Tracking project planned/actuals, by phases, across all projectsconsistently

[projserverpm]

I have a template which we use across all projects containing the
following structure:

Phase 1
Task a
Task b
Phase 2
Task c
Task d

How do I track time we spent in phase 1 and phase 2 for ALL projects
deployed on my project server. How do I specify/identify these phases
as “trackable” in MS Project client? Detailed, how-to instructions
would be appreciated.

 

[Mark Everett | PMP]

I have a template which we use across all projects containing the
following structure:

Phase 1
  Task a
  Task b
Phase 2
 Task c
 Task d

How do I track time we spent in phase 1 and phase 2 for ALL projects
deployed on my project server.  How do I specify/identify these phases
as “trackable” in MS Project client?  Detailed, how-to instructions
would be appreciated.

You don't specify which version you are using, so I will assume that
you are using 2007.

There are a couple of approaches you could take.

Using a Data Analysis view, insert Task List Level 3 (that's if you
use Task 0 for the Project Name) which will provide summary level
information. You can insert different task list levels if necessary.

So, in Data Analysis view area, insert your projects and drop the Task
List Level x into the Row area. Expand the Level and you should see,
for each project, the summarys and the applicable hours or dollars or
whatever you need to measure.

The other approach, and one that I can't provide much detail on, is to
use SQL Reporting Services (SRS). This however requires someone with
a fairly deep understanding of the schema for Project Server's
Reporting Database.

Hope this helps,
Mark Everett PMP | MCITP
www.catapultsystems.com

 

[Paul Conroy]

These phases can be identified as through the field [is summary].

You could certainly produce this report through Reporting Services. It's
probably quicker and easier to contract someone to create this report for you
if you don't have the skills.

Paul

--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[projserverpm]

Guys, thanks.

I am able to see it by Task List Levels in Data Analysis, however one
project at a time. I am looking for -- show me # of planned and
actual hours throughtout the organization, across all projects. A
rollup if you will, but not project by project, however across the
board.