How to see the assignments data in CrossTab format in Project Serv

B

Barb PMO

My company uses Project Pro 2003 and Project Server

I would like to build a custom Project Server view to view resource
assignments, but instead of a Gantt Chart, I would like to have a CrossTab
view with the Work grouped by month.

I do this in Project Pro for each project. I use the CrossTab view to
portion out the work across the months. For example a task may be a 24 hours
task, with 2 resources, and we assign 12 hours of work for 2 resources, 6 in
August and 6 in Sept. Note; We do it this way, because the client cannot
handle more than 6 hours of work in a month.

We use Portfolio Analyzer (to view all of the work for all projects by
team), and that is very helpful for capacity planning, but Portfolio Analyzer
doesn't provide the data at the assignments level.

The people working on the projects would really like to be able to view
their upcoming work on task assignments for all projects in the same way, but
I can't figure out how to see the assignments data in a CrossTab format in
Project Server.
 
K

Kevin W Flanagan

I believe that a custom ASP report will provide you that information in the
most painless manner. You can extend your OLAP cube for the assignments to
be included - search for Portfolio Analyzer OLAP Extensions for an article
that will explain how to extend the OLAP cube.

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top