I have some experience deploying and using Project server but I am just getting started when it comes to reports, Analysis Services and extracting useful data from it. I would like some tips for creating some simple reports that can be displayed in a SharePoint/Project
site or printed.
Specifically, right now I need to create a simple report I plan to display on each project site showing
which tasks from that project are late at the moment.
Does anyone have any tips or know of any guides to help with this specific task?
That would be really appreciated.
I am trying to use Dashboard Designer and Score Cards.
The easiest wayisto create a new enterprise
field with the calculationcomparingbaselinefinishdateandStatusDate for task where work is not complete.
ThisfieldtheninsertthePWAview"taskschedulle"whereeachteam member can see project tasks. Ifyouwant tomakeitusingdashboardsisnecessary to modify thedefaultOLAPcubesand
available in MS project) and than byMDXfilter onlyspecific tasks.