OBS Utilization with Resource Details – SQL

This portlet 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.  The OBS summary totals show on a single line, but can be clicked (+) to roll out the details behind each OBS total.