All Assignments - SQL Server

theBasiX

The All Assignments portlet displays resource assignments across multiple projects. Currently, assignment information displayed for the project, in OWB, or MSP is limited to a single project. This portlet will provide a single view of the assigned data for all assignments across multiple projects. The portlet displays project actuals and estimates from the project (datamart tables). The Days Late field is calculated by the baseline date, while the Days Old field is calculated by today’s date.
Note: Only the projects that the user has viewer rights to will show up in the list.

Filters provide the PM, RM, and individual resource the ability to monitor work progress across multiple projects. For example:
• PMs can filter for all assignments that were to be completed by a given date but still have “Started” or “Not Started” status.
• If multiple projects are utilizing the same resource, the PM or RM can filter for assignments utilizing that specific resource to prevent over-utilization.
• A resource may filter for all assignments assigned to them, providing a picture of their total body of work.
• A RM or PM can filter on Active or Inactive resources. Inactive resource filter can be helpful to make sure tasks and other assignments are re-assigned with the departure of a resource.

Download Details
Submission Date Jul 6, 2012 3:22 pm
Submitter Rego
Content Type Portlet
Database Architecture Microsoft SQL Server
Work Type
Work Categories
Related Content
Supported Versions 12.x, 13.x, 14x, 15.x
Company Rego Consulting