Budget Versus Actual Cost Comparison Dashboard

The Budget vs Actual Cost Comparison dashboard displays the comparison of budget and actual costs to analyze variances. Results are grouped by business unit and currency.

The dashboard uses the Project Costing - Actual Costs Real Time and Project Control - Budgets Real Time subject areas.

The dashboard consists of the Budget vs Actual Cost Comparison analysis.

Key Insights

This dashboard answers the following business question:

  • How do my actual costs compare to my budget costs?

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 Financials Sample Reports

Who uses this dashboard?

Project Manager

When do I use this dashboard?

When you need to compare the budget and actual costs of a project.

What can I do with this dashboard?

You can view the list of projects by:

  • Project Business Unit

  • Project Manager

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 Business Unit

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL:

    SELECT MIN("Project"."Project Business Unit") FROM "Project Costing - Actual Costs Real Time"

Project Manager

Dashboard prompt

  • Choice list

  • Values limited by Project Business Unit

  • Select multiple values enabled

  • Default selection: All values

The following table lists the views in the Budget vs Actual Cost Comparison by Business Unit analysis.

View

Displayed Information

View Name

Budget vs Actual Cost Comparison by Business Unit

View Sections

  • Project Business Unit

  • Currency

Table Column and Measures

  1. Project Manager

  2. Project Number

  3. Budget Cost

  4. Actual Cost

  5. Variance