6. června 2012 20:06
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?
12. června 2012 20:51
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
Hope this helps.
- Navržen jako odpověď TASB Tom 13. června 2012 20:45
13. června 2012 21:15
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.
13. června 2012 21:28
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.