Capital Asset Assignments Dashboard

The Capital Asset Assignments dashboard displays how your assets and asset costs are assigned to your projects and tasks.

The dashboard uses the Project Costing - Assets Real Time subject area.

The dashboard consists of Capital Asset Assignments analysis.

Key Insights

This dashboard answers the following business questions:

  • What's the total cost of assets assigned at the project level?

  • Which assets are assigned to a task?

  • Which assets aren't assigned?

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

Who uses this dashboard?

Project Accountant

When do I use this dashboard?

When you need to:

  • Review how assets are assigned to projects and tasks.

  • Group your assets by asset type and category.

What can I do with this dashboard?

You can view:

  • Assets grouped by

    • Asset type

    • Asset category

  • Costs for these asset groups.

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 Number

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL:

    select min("Project"."Project Number") from "Project Costing - Assets Real Time"

Asset Category

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Task Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Values limited by All Prompts

Task Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Grouping Level Type

Dashboard prompt

  • Choice list

  • Select multiple values enabled

The following table lists the views in the Capital Asset Assignment Report.

View

Displayed Information

View Name

Capital Asset Assignments Report

View Sections

None

Table Column and Measures

  1. Project Number

  2. Project Name

  3. Asset Category

  4. Asset Type

  5. Grouping Level Type

  6. Asset Number

  7. Asset Name

  8. Asset Key

  9. Currency

  10. Estimated Asset Units

  11. Actual Asset Units

  12. Estimated Asset Cost

  13. Asset Cost

  14. Asset Task - Task Number

  15. Asset Task - Task Name