1. Creating and Administering Analytics and Reports for Project Management
  2. Change Order Details Dashboard

Change Order Details Dashboard

The Change Order Details dashboard displays the change order details and impact assessments by project.

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

The dashboard consists of Change Order Details Report and you can drill down to the following analysis from the Change Order Details Report.

  • Change Orders by Participant Status Report

Key Insights

This dashboard answers the following business questions:

  • What's the effort required to process the change order?

  • What's the estimated cost and revenue for the change order?

  • What's the current stage and status of the change order?

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 details and impact assessments of the change orders for your projects or change orders you own.

What can I do with this dashboard?

You can:

  • View change orders by:

    • Project Name

    • Change Order Priority

    • Change Order Owner

  • View total number of change orders for a project.

  • Drill down to the Change Order by Participant Status analysis using the Change Order Owner 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

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 Reason

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 Details analysis.

View

Displayed Information

View Name

Change Order Details

View Sections

None

Table Column and Measures

  1. Project Name

  2. Change Order Owner

  3. Change Order Priority

  4. Change Order Name

  5. Change Order Reason

  6. Change Order Status

  7. Change Order Stage

  8. Currency

  9. Effort in Hours

  10. Estimated Cost

  11. Estimated Revenue

  12. Contract Amount