Project 2007 report

  • Thread starter Andrzej Jaworek
  • Start date
A

Andrzej Jaworek

I'm using Project Web Access and Project 2007 to create and edit projects.
I would like to create a report in the Project 2007 that presents work
hours and overtime for any resource and for ALL projects. It should show
one sumarizered report for all projects that resource was assigned to. I
found such report in Project 2007 but only for one specific project :(


Please help.

andy
 
D

Dale Howard [MVP]

Anrzej --

For this purpose, you should use a Data Analysis view, based on the
MSP_Portfolio_Analyzer cube. Add the following Dimensions and Total Fields
to the PivotTable:

Row Fields drop area - Resource List and Project List
Total Fields drop area - Work and Overtime Work

Be sure to add the new custom View to at least one Category so that users
can see it. Hope this helps.
 
A

Andrzej Jaworek

Dale Howard [MVP] pisze:
Anrzej --

For this purpose, you should use a Data Analysis view, based on the
MSP_Portfolio_Analyzer cube. Add the following Dimensions and Total Fields
to the PivotTable:

Row Fields drop area - Resource List and Project List
Total Fields drop area - Work and Overtime Work

Be sure to add the new custom View to at least one Category so that users
can see it. Hope this helps.
Click to expand...

Ok.
To do this I must configure PWA to using cube building service. I have
SQL Server 2005 Analysis Services installed. I go to Server settings ->
Build settings in PWA. After filling Server and Database box I receive
an error:
"Analysis Services session failed with the following error: Failed to
connect to the Analysis Services server <AnalysisServicesServerName>.
Error: The connection string to repository needs to be specified in the
9.0 server properties "

Do you know maybe the easy tutorial that describes how to configure PWA
to using data analysis?

Andy
 
D

Dale Howard [MVP]

Andrzej --

The installation of Project Server 2007 is a very complex process. There is
no "easy" way to do it. For a thorough treatment of the entire installation
and configuration process, you might want to purchase our "Implementing and
Administering Microsoft Office Project Server 2007" book at:

http://www.projectserverbooks.com

Beyond this, I am not a DBA or network administrator, I believe you should
repost your question in this newsgroup so our technical folks can help you.
Be sure to describe the error message you see. Hope this helps.
 
Top