Přihlásit
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Calculate resource from - location to pull into field

Proposed Calculate resource from - location to pull into field

  • 6. června 2012 20:06
     
     
    Přihlásit se a hlasovat
    0

    I'm working with Project Server 2010 on resource management.  After troubleshooting I now understand the importance of the calculate from field (project plan, resource plan, project plan until).

    However, it is set incorrectly in many projects and we will have multiple users who have access to change it.  Therefore, I need a way that I can see it for all projects at a glance (without opening the project).

    I'd planned to create a custom field, however, I can't find the data element to reference to be able to see it.  I've also looked through the database schema, but it isn't jumping out.  Could you help me identify where the "calculate from" in resources is stored?

    Thanks!

    jb

     

Všechny reakce

  • 12. června 2012 20:51
     
     Navržená odpověď
    Přihlásit se a hlasovat
    0

    jb,

    There is a field called ResourcePlanUtilizationType in the Reporting Database, in MSP_EpmProject_UserView which should give you this info for all published projects.

    The enum is

    • FromProjectPlan=0
    • FromResourcePlan=1
    • FromProjectPlanThenResourcePlan=2

    Hope this helps.

    Treb Gatte

    • Navržen jako odpověď TASB Tom 13. června 2012 20:45
    •  
     
  • 13. června 2012 21:15
     
     
    Přihlásit se a hlasovat
    0

    Treb -

    Thanks for your reply.  I'm trying it, and will reply back if I can get it to work.  At first try, I'm getting an error when trying to reference the field in a custom column (so that it will display in the project center), but I'm probably doing something wrong, so I've asked someone to double check me.

    Jason

    jb

     
  • 13. června 2012 21:28
     
     
    Přihlásit se a hlasovat
    0

    Jason,

    Be aware, this field isn't available for views, only for server reports. You will have to use Excel or any other favorite tool to create a report to access this information.

    --Treb