locked
Project Server 2010 Project Status Custom Fields RRS feed

  • Question

  • Hi All,

    We are trying with project server 2010. I have seen some demos where the custom field with graphical indicators for Project Schedule,Project Cost, Project Health, Project Quality, Project Resource, Project Risk,Project Issues. How this will be calculated. According to my understating Project schedule can be calculated using  start , finish date and % completed. Also Project Costing can be calculated using cost and actual cost. How rest of the fields will be calculated. Or is it automatically calculated and  available reporting in DB.

    Thanks in advance


    Thanks, Arun
    Sunday, October 9, 2011 7:36 AM

All replies

  • Hi Arun,

    Yes, You have information available in Reporting database. Project estimated Cost will be calculated based on the Assiged work* Resource rate. Actaul cost will be based on actual work & resource rates plus some other factors like material/cost resources. Project risks & issues are based on the issues/risks cretaed in project workspace.

    Project server & professional has a complex scheduling engine which does all the calculations. You have options in MS project for auto-calculation on/off.

    Almost all of the information is available in Projects erver reporting database. I would suggest to downlaod the Projects erver 2010 SDK & see the reporting database schema.
    http://www.microsoft.com/download/en/details.aspx?id=15511

    Please see more information in below msdn article:
    http://msdn.microsoft.com/en-us/library/ee767700.aspx 
    http://office.microsoft.com/en-us/project-server-help/health-task-field-HA010371117.aspx

    e.g: About the Views, which contains the project health information
    MSPLT_Health_UserView
    Project Health: Default values are On Schedule, Late, Early, Blocked, Completed, Not Specified.

    Hope that helps.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Monday, October 10, 2011 5:14 AM
  • Hi Amit,

    Thanks for your information. I have checked the virtual lab, available in microsoft site, they have created the custom fields for Project Schedule,Project Cost, Project Health, Project Quality, Project Resource, Project Risk,Project Issues with look up table values red,green,yellow. But there is no formula. But the value for the custom field automatically set when the project created/published, i want know how to set this. Please find the below virual lab reporting db, project view with custom field values.

    I have created similar custom field, edit and published the projects, but the custom field values are null. 

     

     


    Thanks, Arun

    • Edited by arun_2014 Tuesday, October 11, 2011 3:47 AM
    Tuesday, October 11, 2011 3:09 AM
  • Mate, add a custom field or two to play with some real schedule data from your projects. The "pick a lie" subjective PM fields are for those that don’t want to know the truth ;-)

    PS2010 has a plethora of Data that will make your PMs shake. Start with this one;

    Create a Project Level, Number type, Custom field called Cost Indicator. Choose Formula as the Custom Attributes and enter this;

    Int((([Cost] - [Baseline Cost]) / [Baseline Cost]) * 100)

    This gives you a neat percentage figure to use. Now you may want to leave that raw figure or you can make the Field a Graphical Indicator (click the option in “Values to Display”).

    Set your first test to be is 'equal or less than', and your value to 5 (well,  whatever your PMO wants really) set the image to a Green Ball. Set the second test to be 'equal or Greater' than 15 with an image of a red ball, lastly do a test of 'equal or greater than' 10 use the yellow ball image. Note the order, as the tests work down the list to check the test, ending when it finds a true state, so highest number first (except the first).

    Great. Now you should have this field to use in Schedules (it rolls down into the tasks too) or add it to a view in Project Centre. The good news too is if your using  SSRS the raw figure is now available in the Project Servers Reporting database in the MSP_EpmProject_UserView View, the Custom fields are right down the bottom of the list, so scroll right down.   

    One last note, the projects need to be published before this custom filed is populated.

    Good luck and have fun with reporting.

    Tuesday, October 11, 2011 4:45 AM
  • Hi Simon,

    Thnaks for your help, already we have created simlar fields for cost,schedule etc with formula and garphical indicators. Just I am wondering how  Project Health, Project Quality, Project Resource, Project Risk,Project Issues fields created to display the graphical idicators without any formula in Demo images / virtual labs.

     


    Thanks, Arun

    • Edited by arun_2014 Monday, January 25, 2016 9:26 AM
    Wednesday, October 12, 2011 2:52 AM