1. Creating and Administering Analytics and Reports for Project Management
  2. Change Orders by Reason Dashboard

Change Orders by Reason Dashboard

The Change Orders by Reason dashboard displays the change orders grouped by reason in form of pivot table and pie chart.

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

The dashboard consists of Change Order by Reason Report and you can drill down to the following analyses from the Change Orders by Reason Report.

  • Change Orders by Participant Status Report

  • Change Order Details Report

Key Insights

This dashboard answers the following business questions:

  • What are the reasons for change orders?

  • What's the count of change orders for a given reason?

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

  • Change Order Owner

When do I use this dashboard?

When you want to know the reasons of the change orders for your projects or change orders that you own.

What can I do with this dashboard?

You can

  • View change orders by project name.

  • Drill down to the view Change Order Details and Change Order by Participant Status analysis.

    • Change Order Details analysis by using the Reason Name column.

    • Change Orders by Participant Status analysis by using the Owner column in the Change Order Details analysis.

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

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Change Order Priority

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Change Order Owner

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Change Order Status

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

  • Default selection SQL:

    SELECT "Change Order Status"."Change Order Status Name" FROM "Project Management - Change Management Real Time" WHERE "Change Order Status"."Change Order Status Code" IN ('IN_PROGRESS', 'APPROVED') FETCH FIRST 65001 ROWS ONLY

Change Order Stage

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

  • Default selection SQL:

    SELECT "Change Order Stage"."Change Order Stage Name" FROM "Project Management - Change Management Real Time" WHERE "Change Order Stage"."Change Order Stage Code" IN ('APPROVAL','IMPACT_ANALYSIS','IMPLEMENTATION','REVIEW') FETCH FIRST 65001 ROWS ONLY

The following table lists the views in the Change Order by Reason analysis.

View

Displayed Information

View Name

Change Orders By Reason

View Sections

  • Pivot table

  • Graph

Table Column and Measures

  1. Project Name

  2. Change Order Reason Name