Timesheet Report Needed

[JMW]

I am piloting a Project Server 2007 implementation and I need to create a
report for our payroll department showing the number of hours worked on each
day for each enterprise resource, for a 2-week period of time, broken down by
the following categories:

Project Work (included total of all hours posted to projects tasks)
PTO (Paid Time Off - a field I created)
Bereavement
Holiday
Leave of Absence

What is the best way to go about creating this report? Do I need to build
an OLAP cube, or can this be accomplished by customizing a view of some sort
and importing the data into excel? Unless I'm missing something, the custom
enterprise fields seem to pertain to projects instead of timesheets and the
OLAP cube building feature seems to be based on custom enterprise fields.

Is there a timesheet report or view that already exists in Project Server
that I can modify?

Any help or suggestions on this topic would be greatly appreciated!
Thanks!

 

[Rod Gill]

If you want this report in Excel, you can link to the Timesheet data in the
Reporting database. The schema is in the Project SDK which you can download
from microsoft.com

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Marc Soester [MVP]]

Hi JMW,

you have several options. As Rods excellent suggestion already outlined you
could use the Reporting Database for Project Server to create your own
reports in excel.
you could also ( which I find most helpful) use the Data Analyser (OLAP
Cubes) you get most of what you need of the OLAP cubes. Project Server
creates 14 cubes out of the box and some are dedicated to timesheets. The
problem you will have is if you need printable reports. OLAP cubes are
generally not so good when it comes to printing them ( the layout doesnt look
appeeling to everybody). In this case you could create reports of the
reporting DB. In fact Microsoft has some pre-defined reports useing reporting
services and some of them are Timesheet reports. You will be able to find
them in the Project Server 2007 SDK.
Have lots of fun creating your reports and let me know if you have more
questions.

 

[Paul Conroy]

In additional to Rods post, you can leverage SQL Reporting Services. There
is an example timesheet report in the Project Report Pack which is
downloadable with the SDK. SRS can be exported into excel if needed, they
can also be scheduled to run periodically and emailed to those that need
them. You also have greater control over the security of who can access
these reports.

 

[JMW]

Thanks Rod! I appreciate the help.
--
JMW

If you want this report in Excel, you can link to the Timesheet data in the
Reporting database. The schema is in the Project SDK which you can download
from microsoft.com

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[JMW]

Thanks Paul.
--
JMW

In additional to Rods post, you can leverage SQL Reporting Services. There
is an example timesheet report in the Project Report Pack which is
downloadable with the SDK. SRS can be exported into excel if needed, they
can also be scheduled to run periodically and emailed to those that need
them. You also have greater control over the security of who can access
these reports.

 

[JMW]

Thank you Mark. I'm having some trouble understanding how the OLAP cubes
work. I would also need to print the report so I'm not sure if that would be
the best approach. I will download the SDK and check into all the suggestions
and see what works best for my organization. thanks again for all the good
info!

 

[MSPLearner]

I am looking for instructions/information on how I can connect to the
Reporting Database via Excel (ODBC?). Appreciate any help.

Thanks