Project Resource Assignment History by Resource Pool and Resource Dashboard

The Project Resource Assignment History by Resource Pool and Resource dashboard displays the project resource assignment details for assignments that are confirmed, pending adjustment, or canceled for resources in the specified resource pool and current assignment finish date range.

The dashboard uses the Project Resource Management - Resource Pool Real Time subject area.

The dashboard consists of the Project Resource Assignment History by Resource Pool and Resource analysis.

Key Insights

This dashboard answers the following business questions:

How many assignment adjustments are made to my resources' assignments?
What assignments do my resources currently have and are any assignments adjusted from their original schedule?

Frequently Asked Questions

The following table lists the frequently asked questions about this dashboard.

FAQ	Answer
How do I find this dashboard?	Reports and Analytics pane - Shared Folders - Projects - Project Execution Sample Reports
Who uses this dashboard?	Resource Manager
When do I use this dashboard?	When you need to review your resources' assignment and assignment adjustments if any.
What can I do with this dashboard?	You can view the assignment details for resources sorted by the resource pool.
What type of dashboard is this?	Oracle Transactional Business Intelligence

Details

The following table lists the prompts and filters used in this dashboard.

Column	Type	Rules
Resource Pool Name	Dashboard prompt	Choice list Required Select multiple values enabled Presentation Variable: RESRC_POOL_V
Project Resource Assignment Finish Date	Dashboard prompt	Calendar Required Default Selection: SQL SELECT TIMESTAMPADD (SQL_TSI_MONTH, -3, CURRENT_DATE) FROM "Project Resource Management - Resource Management Real Time" Presentation Variable: CURR_ASSIGN_FINISH_DT_V
Variable	Dashboard prompt	Text Field Data Type: Date Required Default Selection: SQL SELECT TIMESTAMPADD(SQL_TSI_MONTH, +3, CURRENT_DATE) FROM "Project Resource Management - Resource Management Real Time" Presentation Variable: CURR_ASSIGN_FINISH_DT2_V

The following table lists the views in the Project Resource Assignment History by Resource Pool and Resource analysis.

View	Displayed Information
View Name	Project Resource Assignment History by Resource Pool and Resource
View Sections	None
Table Column and Measures	Resource Pool Assignment Status Resource Name Project Name Original Assignment Start Date Original Assignment Finish Date Original Hours Per Day Current Assignment Start Date Current Assignment Finish Date Current Hours Per Day Number of Schedule Adjustments