Christophe Fiessinger's Blog - Dashboard configuration.

[Vit]

Hi All,

I'm trying to deploy a full EPM solution with Portfolio Server 2007
and Project Server 2007...

I have found the Christophe Fiessinger's Blog and I have found lots of
interesting resources there!!! (THANKS CHRIS TO SHARE ALL YOUR
KNOWLEDGE.....)

I'm referring in particular to the following:
http://blogs.msdn.com/chrisfie/arch...rvices-sample-reports-for-project-server.aspx
where is possible to create dashboard using MS Excel Services in
MOSS....

I have analysed all the MS Excel that is possible to download from his
blog, and I have found that there are basically two kind of MS Excel:

- the ones that refer to Project Server DB (and in particular to the
Cube MSP_Portfolio_Analysis.xlsx)
- the ones that refer to Portfolio Server DB

I have some question about how import data from portfolio BD into an
Excel stored in a document library and make it regualarry update...

I have followed the following steps:

- Created a Document library to store the Excel files
- Saved into the library the Excel files downloaded from Chris's Blog
- Created a custom web part page and inserted the excel web access web
parts

it works fine, but I cannot refresh the data from portfolio server...
how can I do it??? how should it be done???

thanks all

Vit

 

[Andrew Lavinsky]

Good question. Prompted me to look it up myself.

Have you referred to this article?

http://technet.microsoft.com/en-us/library/cc262899.aspx#section5



- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm