Project Server Reporting

Question

Hello,

I'm using Project server 2007 SP2.

After the success of creating and publishing project plans on the server, I'm trying now to know if i can make a custom reports on PS, related to all projects i have on PS (like how many issues, tasks and risks i have in a project, how many resources i have in a specific project, and so on)....is that possible to do? and how can I start?

 

regards, 

Scott.

Answer 1

Hi Scott (again :-) ),

 

OK, so what you are trying to achieve is more thn possible.  There are two main ways I would suggest doing this:

 

1. Using Data Analysis views by creating an OLAP Cube and reporting against this.  It is possible to create a view from here to fulfil your requirements.  The following Technet article will help you to configure this - http://technet.microsoft.com/en-us/library/cc303402(office.12).aspx
2. SQL Reporting Services.  To get started with this there is something known as the Project Server Report Pack (http://msdn.microsoft.com/en-us/library/bb428831(office.12).aspx) which has been released by Microsoft which is a starter kit on some pre-canned reports to get you going.

 

To begin with I hope that this helps.

 

Regards,

 

Dharmesh

Answer 2

In addition to Dharm's suggestions, have you already tried using custom fields

and Project Center views? Things like # of tasks or variance can all be

indicated there with custom enterprise formulas.

 

Just checking.

 

 

- Andrew Lavinsky

Blog: http://blogs.catapultsystems.com/epm

 

 

Answer 3

Thanks All,

Dharmesh, how are you again :)

I'm trying to follow the instruction for making a report, but until now, it still hard for me to do it...i don't know, maybe i make some mistakes.

Can you simplify it more for me.. I mean can you give me an example of how to report on the number of tasks in a project...step by step

 

Thanks in advance

 

Scott.

Answer 4

Hi Scott,

Right, firstly I would try to build the OLAP Cube..... use the following Technet article to configure and build the cube - http://technet.microsoft.com/en-us/library/cc197552(office.12).aspx

Once you have done this, we can then advise you to on how to create reports.

Also Andrew is also correct - you could create a Project Center view.  This is done by going to PWA - Server Settings - Manage Views - Create a new view.  Here you can either create a Project Center View (portfolio view of all your projects) and view information which you require / group your projects.

If you are able to give an exact report that you are trying to generate we can give you some clear direction.

Regards,

Dharmesh