generating reports based on all published projects

[Elizabeth]

Hi there, Thanks for all the help I have so far recieved on this page.
I am trying to generate a report based on 6 feilds in all of the projects
registered in my project server. I would like to produce a report that shows
the overall alignment of the 60 published projects to our organisational
objectives. When the projects were registered in Excel I could create a pie
chart showing percentages based on data within the six feilds. Can this be
done in Project server? I can find custom reports for single projects but
not a report based on all of the registered projects.
Many thanks in advance,
Elizabeth

 

[Dale Howard [MVP]]

Elizabeth --

Yes, what you wish to do can certainly be done. Your Project Server
administrator would need to begin the process by creating the 6 fields as
custom enterprise Project outline codes in the Enterprise Global file.
After he/she has done this, your PM's will need to open each project that
they manage, click Project - Project Information, select a value for each of
the 6 outline codes for that project, and then click OK. Your PM's would
then need to publish the changes to PWA by clicking Collaborate - Publish -
Project Plan or Collaborate - Publish - All Information. After this has
been done, your Project Server administrator would need to rebuild the OLAP
cube so that the latest project data will appear in the OLAP cube. Then the
Project Server administrator could create one or more Portfolio Analyzer
views that meet your reporting needs, based on the data in each of these 6
custom enterprise Project outline codes, including a pie chart that shows
percentages. Hope this helps.

 

[Elizabeth]

Thanks Dale - you've been great

Elizabeth --

Yes, what you wish to do can certainly be done. Your Project Server
administrator would need to begin the process by creating the 6 fields as
custom enterprise Project outline codes in the Enterprise Global file.
After he/she has done this, your PM's will need to open each project that
they manage, click Project - Project Information, select a value for each of
the 6 outline codes for that project, and then click OK. Your PM's would
then need to publish the changes to PWA by clicking Collaborate - Publish -
Project Plan or Collaborate - Publish - All Information. After this has
been done, your Project Server administrator would need to rebuild the OLAP
cube so that the latest project data will appear in the OLAP cube. Then the
Project Server administrator could create one or more Portfolio Analyzer
views that meet your reporting needs, based on the data in each of these 6
custom enterprise Project outline codes, including a pie chart that shows
percentages. Hope this helps.

 

[Dale Howard [MVP]]

Elizabeth --

You are more than welcome, my friend!