Late Tasks - Reporting and Dashboard Designer Tips Please
-
Friday, 27 April 2012 1:53 PM
Hello,
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.
Current task:
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.
Thank you.
All Replies
-
Friday, 11 May 2012 1:05 PM
Hi Rick,
The easiest way is to create a new enterprise field with the calculation comparing baseline finish date and Status Date for task where work is not complete. This field then insert the PWA view "task schedulle" where each team member can see project tasks.
If you want to make it using dashboards is necessary to modify the default OLAP cubes and add a new dimension attribute ("Status" available in MS project) and than by MDX filter only specific tasks.
Tomas -
Friday, 11 May 2012 1:13 PM
Probably if you want to start with Microsoft Project Server 2010 reporting, then below 3 links are the best place for you:
Reporting with Microsoft Project Server 2010
http://technet.microsoft.com/en-us/library/gg188101.aspx
Microsoft Project Server 2010 Reporting with Excel Services
http://www.microsoft.com/en-us/download/details.aspx?id=26556
Creating Dashboards for Microsoft Project Server 2010
http://www.microsoft.com/en-us/download/details.aspx?id=26557
Hope this helps.Abhijeet M. Mohite