22 mai 2012 14:23
We have installed and configured Project Server 2010. How to achive the below KPI or Grapical Indicators(Cost, Resources, Risk, Quality). Normally schedule idicators will be arrived using formula with the fields finish date and %Completed. How to manage and achive Cost, Resources, Risk, Quality status. Is it inbult are we need formulate or configure.
Thanks in advance
Thanks in advance
22 mai 2012 20:16Moderator
I believe that this report was specifically developed in SSRS. You should be able to review the .RDL file to assess how it was created.
You could also do something similar with a PerformancePoint Scorecard. There should be resources online and on Technet to walk you through it.
Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
23 mai 2012 06:52
We have built the similar report using "Creating Dashboards for Microsoft Project Server 2010" & Cost, Resources, Risk, Quality status is calculated using the MSP_EpmProject_UserView fields & this is not inbuilt.
You can downlaod the whitepaper:
Go to Appendix B & see the Stored proc which gets the data.(You may need to create the custom fields so that the project user view gets all columns)
SELECT SUM(CASE WHEN p.[Project Health] = 'Green' THEN 3 WHEN p.[Project Health] = 'Yellow' THEN 2 WHEN p.[Project Health] = 'Red' THEN 1 ELSE 0 END) AS 'ProjectHealthScore' ,SUM(CASE WHEN p.[Project Health] = 'Green' THEN 3 WHEN p.[Project Health] = 'Yellow' THEN 2 WHEN p.[Project Health] = 'Red' THEN 1 ELSE 0 END) / CONVERT(DECIMAL(12,6),(COUNT(p.ProjectUID) * 3)) AS 'ProjectHealthScorePercent' FROM PWA_Reporting.dbo.MSP_EpmProject_UserView AS pHope this helps.
If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
14 august 2012 21:35
I've been following the same whitepaper, and I'm not entirely sure that it's complete, or maybe I'm missing something.
I created the Enterprise fields, and lookup tables, as well as the stored procedures, but I don't believe it's working. Most of the fields that the stored procedure is looking for don't exist in the view.
Also, where exactly do the fields get their values from?
Hopefully these aren't painfully obvious questions.
Any help is appreciated.