1. Creating and Administering Analytics and Reports for Project Management
  2. Issue Analysis by Project Dashboard

Issue Analysis by Project Dashboard

The Issue Analysis by Project dashboard displays the number of issues by the issue types for all your projects. You can also view the issues grouped by project managers or project statuses.

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

The dashboard consists of Issue Analysis by Project Report and you can drill down to the following analyses from the Issue Analysis by Project Report.

  • Issue Details Report

  • Action Item Details Report

Key Insights

This dashboard answers the following business questions:

  • What are the total number of issues for a project?

  • What are the total number of issues for each issue type?

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 - Shared Folders - Projects - Project Execution Sample Reports

Who uses this dashboard?

Project Manager

When do I use this dashboard?

When you need to know how many issues are open for each project and their types.

What can I do with this dashboard?

You can:

  • View the number of issue types by:

    • Project

    • Project Managers

    • Project Status

    • Project End Date

  • Drill down to the Issue Details analysis using the Count of Issues column.

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 Name

Filter

Is not null

Project Manager

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection SQL:

    SELECT "Project"."Primary Project Manager" FROM "Project Management - Project Issues Real Time" WHERE "Project"."Primary Project Manager" =VALUEOF(NQ_SESSION.USER)

Project Status

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection SQL:

    SELECT "Project"."Current Project Status Name" FROM "Project Management - Project Issues Real Time" where "Project"."Current Project Status Name" = 'Active'

Project Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Project Finish Date

Dashboard prompt

  • Calendar

  • Default selection: None

  • Presentation Variable: PROJ_END_DT

The following table lists the views for Issue Analysis by Project Report.

View

Displayed Information

View Name

Issue Analysis by Project Report

View Sections

None

Table Column and Measures

  1. Sort Count

  2. Project Name

  3. Count of Issues

  4. Issue Type