How to create a dashboard in project center

G

gaurshukla

I want to create a dashboard on project server which contain 5 (chart
and summary report snap shot)..condition is that user should be given
option to choose its desired view..and if user cilck on any of the
desired view ..it should be direcly on its desired location ..any
help or some material..
 
M

Manmeet Chaudhari

Hi
To create a dashboard view in PWA you will need to add Excel Services web
parts...
You an also create dashboard in Excel which will have multiple Pivot table
and charts in on Worksheet. These Pivot table can be made to talk directly to
Project Server database and the refresh of Pivot table can be schedule as
frquently as possible
 
H

Hung

Hi Manmeet,

I wonder how we can make Pivot table to talk directly to Project Server. Can
we use MDX query in Excel ?

Thanks
H
 
Top