EPS Element by Delegate Dashboard

The EPS Element by Delegate dashboard displays the projects grouped in an EPS element. You can also view the project start and finish dates, and project managers for such projects.

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

The dashboard consists of EPS Element by Delegate Analysis.

Key Insights

The dashboard answers the following business questions:

• Which projects are under an EPS element?

• Who is the Delegate assigned to the EPS element?

• What are the projects assigned to a project manager?

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?	Project Application Administrator and Project Executive
When do I use this dashboard?	When you need to review which projects are grouped under an EPS element, their start and finish dates, and the Project Managers of individual projects.
What can I do with this dashboard?	Review the labor resources of a project.
What type of dashboard is this?	Oracle Transactional Business Intelligence.

Details

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

Column	Type	Rules
Delegate Name	Dashboard prompt	Choice list Select multiple values enabled
Project Name	Dashboard prompt	Choice list Select multiple values enabled Default selection SQL: SELECT "Project Resource Management - Resource Management Real Time"."Project"."Project Name" s_1 FROM "Project Resource Management - Resource Management Real Time" WHERE (("Project Resource Request"."Total Requests" >= 0) OR ("Project Resource Request"."Total Requests" IS NULL)) ORDER BY 1 ASC NULLS LAST FETCH FIRST 75001 ROWS
Project Manager	Dashboard prompt	Choice list Select multiple views enabled Default selection SQL: SELECT "Project Resource Management - Resource Management Real Time"."Project"."Primary Project Manager" s_1 FROM "Project Resource Management - Resource Management Real Time" WHERE (("Project Resource Request"."Total Requests" >= 0) OR ("Project Resource Request"."Total Requests" IS NULL)) ORDER BY 1 ASC NULLS LAST FETCH FIRST 75001 ROWS ONLY
Project Start Date	Dashboard prompt	Calendar Is greater than or equal to Default selection SQLSELECT MIN("- Project Start Date"."Project Start Date") FROM "Project Management - Project Hierarchy Real Time" FETCH FIRST 1 ROWS ONLY
Project End Date	Dashboard prompt	Calendar Is less than or equal to Default selection SQL: SELECT MAX("- Project End Date"."Project End Date") FROM "Project Management - Project Hierarchy Real Time" FETCH FIRST 1 ROWS ONLY

The following table lists the views in the EPS Element by Delegate Analysis.

View	Displayed Information
View Name	EPS Element by Delegate Analysis
View Sections	None
Table Column and Measures	Delegate EPS Element Name Project Name Project Manager