How do I report on issues / risks from multiple projects in Server

[Matt Kale]

I'm trying to get a PMO level (Consolidated) view of issues and risks across
all projects in the database. (Like a list, not just summary data) I've been
through all the online documentation to no avail. What am I missing? Can I
create a view in Analysis Services that will serve this need?

Is there another way to accomplish the same goal?

 

[Earl Lewis]

Matt,

As far as I know this is not something that's possible without doing your own custom reporting. remember, issues, risks and documents are all hosted by the Windows Sharepoint Services application - so that data is not held in your project server MSSQL database - it's in the WSS database.

And no, I don't think analysis services will help either. Analysis services is focused toward project schedule, resource and budget reporting.

I've also been interested in this so I'm going to be looking into the possibility of doing it. If I make any progress that seems worthwhile reporting I'll post back here.

Earl
I'm trying to get a PMO level (Consolidated) view of issues and risks across
all projects in the database. (Like a list, not just summary data) I've been
through all the online documentation to no avail. What am I missing? Can I
create a view in Analysis Services that will serve this need?

Is there another way to accomplish the same goal?

 

[meharraza]

*Matt,

As far as I know this is not something that's possible without doing
your own custom reporting. remember, issues, risks and documents are
all hosted by the Windows Sharepoint Services application - so that
data is not held in your project server MSSQL dat
abase - it's in the WSS database.

And no, I don't think analysis services will help either. Analysis
services is focused toward project schedule, resource and budget
reporting.

I've also been interested in this so I'm going to be looking into the
possibility of doing it. If I make any progress that seems worthwhile
reporting I'll post back here.

Earl
[vbcol=seagreen]
I'm trying to get a PMO level (Consolidated) view of issues and risks
across
all projects in the database. (Like a list, not just summary data)
I've been
through all the online documentation to no avail. What am I missing?
Can I
create a view in Analysis Services that will serve this need?

Is there another way to accomplish the same goal? *

I've the same problem here. Please let me know if you got any luck.