OBS Utilization – SQL

This view depicts the Resource Utilization by comparing actual hours booked as a percentage of total resource availability grouped and totaled by OBS Unit in a hierarchical fashion.  Resource availability is determined by the working days and daily availability on the individual Resource Calendar and is depicted on a Monthly basis.  This portlet uses Monthly Times and the Time Slice job may need to run before the end user will see results in the portlet.  The portlet filters for Project Activity, Resource Open for Time, Resource Activity, and Employment time have been added to OBS Type and the Start and Finish dates.