Where is "Calculate resource utilization from" stored?

[Silly_King]

This value (set under Resource Plans per project) determines how project
server calculates resource utilization. Where, in Project Server, is it
stored and what's the best way to access it? When getting at the data via
OLAP, both Resource Plan Work and Work are available, and i need to make a
decision which one to use when running reports...

 

[Dale Howard [MVP]]

Silly_King --

The Project Server administrator specifies this value by doing the
following:

1. Log into PWA with Administrator permissions.
2. Click Server Settings - Additional Server Settings.
3. Select one of the two options in the Resource Plan Work Day section.
4. Click the Save button.

The two available options in step #3 above are: Resource Base Calendars and
Hours Per Day. If he/she chooses the second option, he/she must then
specify how many hours constitute a work day, where 8 hours is the typical
value in the US. Hope this helps.

 

[Jonathan Sofer [MVP]]

In the reporting database it is found in the project table/view. Here is a
sample query:

SELECT ProjectName, ResourcePlanUtilizationType,
ResourcePlanUtilizationDate
FROM MSP_EpmProject_UserView

If you look in the reporting schema which comes with the SDK, you will see
the following:

ResourcePlanUtilizationType - Type of resource plan usage,
FromProjectPlan=0, FromResourcePlan=1, FromProjectPlanThenResourcePlan=2
ResourcePlanUtilizationDate - Start date for use of the resource plan. Can
be different than the project start date.

Hope this helps,

Jonathan Sofer