Reporting Timesheet Data

I

Irish Gues

Hello, I am a senior project manager who is also thrown into the "admin" role
on Server 2003. I am trying to create a report for my boss that shows all
actual work reported through timesheets on all projects that fall in my
division in EPM (the "OPS" group). I have an administrative project that has
everyone on the staff in it. If I run the built-in "task usage" report from
that project, it almost does what I want (shows all resources but it shows
both scheduled and actual work and I only want actual work). So, I modified
the report to show "actual work" instead of work, but now I only get time
entered against the admin project, not all projects. Does anyone have a
thought as to how I can do this? I would love to create a Project Center view
that my team leaders could do to themselves instead of me having to produce
it, but I can't figure out how to get this work. Please help!
 
M

Marc Soester [MVP]

HI Irish,

I assume that you are working with Project Server 2003 and you want to
report against tasks within an Admin project is this right? If so, you have
only 1 "out of the box" reporting possebilities, the one you already
meantioned usign Porject Pro.

If you like to report against this kind of data using Project Server you may
want to check out this add on, which we have been using. It allows you to
extend the OLAP cubes to report against task levels, meaning that you can
easily create the report you are desire.

http://www.bogdanov-associates.com/eng.asp?rubr_id=476

The tool is called Portfolio Analyser Extender for Project Server 2003.
I hope this helps
 
I

Irish Gues

I want a report on ALL time entered against ALL projects in my group, not
just Admin tasks. Like I said, the built in "task usage" report is close, but
it reports planned work as well as actual work. There doesn't seem to be an
easy way to build a report or customize a view in PWA to allow me to do this.
 
M

Marc Soester [MVP]

HI Irish,

If you are after Project Data ( not task data) then you should be able use
the Portfolio Analyser to achieve your report. If you are after task
information ( drill down from Project to task) you will need to look at the
tool that I have given you the link previously
Hope this helps
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com
 
Top