none
Project Server 2010 Graphical indicators and KPI RRS feed

  • Question

  • Hi All,

    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

    Tuesday, May 22, 2012 2:23 PM

All replies

  • 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

    Tuesday, May 22, 2012 8:16 PM
    Moderator
  • Hi Arun--

    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:
    http://www.microsoft.com/en-us/download/details.aspx?id=26557

    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 p
    Hope 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

    Wednesday, May 23, 2012 6:52 AM
  • 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.

    Thanks,

    Mike Scott

    Tuesday, August 14, 2012 9:35 PM