Capital Assets Dashboard

The Capital Assets dashboard displays the details of your capital assets.

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

The dashboard consists of Capital Assets analysis.

Key Insights

This dashboard answers the following business questions:

  • Which assets are built and placed in service?

  • Which assets don't have a complete asset definition?

  • What's the total cost of each asset?

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 the assets created for a project.

  • Ensure that all assets are defined and that the asset attributes are correct.

What can I do with this dashboard?

You can review:

  • Actual asset in-service date

  • Number of asset units

  • Total asset cost

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 Number

Dashboard prompt

  • Choice list

  • Required

  • Select multiple values enabled

  • Default selection SQL:

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

Task Number

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Task Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

Asset Category

Dashboard prompt

  • Choice list

  • Select multiple values enabled

The following table lists the views in the Capital Assets Report.

View

Displayed Information

View Name

Capital Assets Report

View Sections

None

Table Column and Measures

  1. Asset Category

  2. Asset Type

  3. Asset Number

  4. Asset Key

  5. Asset Name

  6. Estimated In-Service Date

  7. Actual In-Service Date

  8. Asset Book

  9. Book Currency

  10. Estimated Asset Units

  11. Actual Asset Units

  12. Currency

  13. Standard Unit Cost

  14. Estimated Asset Cost

  15. Total Asset Cost