1. Creating and Administering Analytics and Reports for Project Management
  2. EPS Element by Owner Dashboard

EPS Element by Owner Dashboard

The EPS Element by Owner dashboard lists the projects overseen by an EPS element owner, the start and end dates for projects, and the total cost incurred by each project.

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

The dashboard consists of EPS Element by Owner Analysis.

Key Insights

The dashboard answers the following business questions:

  • Who are the direct owners of an EPS element?

  • Which projects are active in a specified year?

  • Who should I contact for explanation on EPS elements that have measure that are out of tolerance level?

  • What's the start date and end date for projects under an EPS element?

  • What's the total cost of each project under an EPS element?

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 Administrators

  • Project Executives

When do I use this dashboard?

When you want to review:

  • Start and finish dates for projects under an EPS element

  • Owners of EPS elements

  • Total cost incurred by each project

What can I do with this dashboard?

You can:

  • Review the total cost for each project under an EPS element

  • View the owners of EPS elements

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

Project Start Date

Dashboard Prompt

  • Calendar

  • Is greater than or equal to

  • Default selection SQL:

    SELECT 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 Owner Analysis.

View

Displayed Information

View Name

EPS Element by Owner Analysis

View Sections

None

Table Column and Measures

  1. Project Hierarchy

  2. Owner

  3. Project

  4. Total Cost