1. Creating and Administering Analytics and Reports for Project Management
  2. Baseline Trend Dashboard

Baseline Trend Dashboard

The Baseline Trend dashboard displays the baseline trend for project tasks by effort, cost, and dates. You can analyze the incremental progress on the project and better plan for similar projects in future.

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

The dashboard consists of the Baseline Trend Analysis.

Key Insights

This dashboard answers the following business question:

  • How do I compare multiple baselines and view the baseline trend by effort, cost, and schedule?

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 Manager

When do I use this dashboard?

When you need to review the progress of your project and view the baseline trend.

What can I do with this dashboard?

You can drill down to the subtasks using the Top Task Name column.

What type of dashboard is this?

Oracle Transactional Business Intelligence

Details

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

Column

Type

Rules

Project Name

Dashboard prompt

  • Choice list

  • Default selection: SQL

    SELECT "Project"."Project Name" FROM "Project Management - Baseline Versions Real Time" FETCH FIRST 1 ROWS ONLY ORDER BY "Project"."Project Name"

  • Presentation Variable: PRJ_NAME_PV

Top Level Task Name

Dashboard prompt

  • Choice list: SQL Results

    SELECT "Task Hierarchy"."Top Level Task Name" FROM "Project Management - Baseline Versions Real Time" WHERE ("Project"."Project Name" IN (@{PRJ_NAME_PV}['@']{' '}) AND ("Baseline Version Details"."Baseline Name" IS NOT NULL)) FETCH FIRST 65001 ROWS ONLY

  • Select multiple values enabled

The following table lists the views in the Baseline Trend Analysis.

View

Displayed Information

View Name

Baseline Trend Analysis

View Sections

  • Graph

  • Table

Table Column and Measures

  • Graph view:

    1. X-Axis: Baseline Name

    2. Y- Axis: Effort

    3. Y- Axis: Cost

  • Table view:

    1. Project Name

    2. Top Task Number

    3. Top Task Name

    4. Baseline Name

    5. Primary Baseline

    6. Baseline Version Start Date

    7. Baseline Version Finish Date

    8. Baseline Version Labor Cost

    9. Baseline Version Expense Amount

    10. Baseline Version Effort