Actual Cost Analysis by Resource Type Dashboard

The Actual Cost Analysis by Resource Type dashboard displays the budget and actual costs for projects for a particular resource type.

For example, the dashboard displays the actual and budget costs for various resource types such as resource, job name, event type, expenditure type, and item name.

The dashboard uses the Projects - Cross Subject Area Analysis - Real Time subject area.

The dashboard consists of the Actual Cost Analysis by Resource Type analysis.

Key Insights

This dashboard answers the following business question:

What are the budget and actual costs for projects for selected resource 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 pane - Shared Folders - Projects - Project Financial Sample Reports
Who uses this dashboard?	Project Manager
When do I use this dashboard?	When you need to view the variance between the actual and budget costs for projects for a particular resource type.
What can I do with this dashboard?	You can drill down to the Actual Cost Analysis by Resource Type Drill in analysis using the Actual Cost 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
Organization	Dashboard prompt	Choice list Required Select multiple values enabled Default Selection: SQL Results SELECT "- Business Unit"."Business Unit Name" FROM "Projects - Cross Subject Area Analysis - Real Time" FETCH FIRST 1 ROWS ONLY
Project Name	Dashboard prompt	Choice list Required Select multiple values enabled Default Selection: SQL Results SELECT MIN("Project"."Project Name" )FROM "Projects - Cross Subject Area Analysis - Real Time" FETCH FIRST 65001 ROWS ONLY

The following table lists the views in the Actual Cost Analysis by Resource Type analysis.

View	Displayed Information
View Name	Actual Cost Analysis by Resource Type
View Sections	Graph Table Resource Type Column Selector
Table Column and Measures	Budget Cost Actual Cost Variance Resource Type