Capital Asset Lines Dashboard

The Capital Asset Lines dashboard displays the expenditure items and cost distributions that are allocated and assigned to an asset in a given period.

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

The dashboard consists of Capital Asset Lines analysis.

Key Insights

This dashboard answers the following business questions:

• Which asset lines contribute to my assets?

• What's the total capitalized cost of my assets?

• How's an expenditure item allocated across assets?

• Which cost distributions are included in an asset line?

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: Perform detailed analysis to determine which expenditure items and cost distribution lines are allocated and assigned to an asset in a given period. Review how expenditure items are grouped into asset lines.
What can I do with this dashboard?	You can review and analyze: The asset lines that contribute to your total assets. You total capitalized and CIP cost.
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"
Capital Event Number	Dashboard prompt	Choice list Select multiple values enabled
Transaction Number	Dashboard prompt	Choice list Select multiple values enabled
Asset Number	Dashboard prompt	Choice list Select multiple values enabled Values limited by All Prompts
Asset Line Number	Dashboard prompt	Choice list Select multiple values enabled
Accounting Period	Dashboard prompt	Choice list Required Select multiple values enabled

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

View	Displayed Information
View Name	Capital Asset Lines Report
View Sections	None
Table Column and Measures	Asset Category Capital Event Number Asset Number Asset Name Asset Line Number Asset Line Task Number Asset Line Task Name Expenditure Organization Asset Period Transaction Number Transaction Date Expenditure Type Distribution Line Number Currency Capitalized Cost CIP Cost