1. Creating and Administering Analytics and Reports for Project Management
  2. Award Administrator Dashboard

Award Administrator Dashboard

Grants administrators can review award summary and award financial analyses on the Award Administrator dashboard. You can modify the set of reporting and analysis object to meet your requirements.

The dashboard uses the Projects - Grants Management - Award Funding Real Time and Projects - Cross Subject Area Analysis Real Time subject areas.

The dashboard consists of the award summary and award financials analyses.

Key Insights

This dashboard answers the following business questions:

  • Which awards are currently active and which have expired?

  • Which awards are past their end dates, but still open?

  • What's the allocated and unallocated funding amount for each project of an active award?

  • What's the total cost of all awards?

  • How many overspent or underspent projects exist?

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 - Dashboards

Who uses this dashboard?

Grants Administrator

When do I use this dashboard?

When you need to review award statuses and project funding details for an award project.

What can I do with this dashboard?

You can:

  • Review award statuses to understand which awards are currently active and which have expired or nearing expiry.

  • View the total unallocated and unbudgeted funding amount for awards.

  • Gain insight into the total cost and percentage of cost budget spent on award projects.

  • Review overspent and underspent award project budgets.

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

Accounting Year

Dashboard prompt

  • Choice list

  • Values limited by All Prompts

  • Select multiple values enabled

  • Default selection: All values

Fiscal Quarter

Dashboard prompt

  • Choice list

  • Values limited by All Prompts

  • Select multiple values enabled

  • Default selection: All values

Accounting Period Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Award Business Unit Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Award Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Award Type

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Award Owning Organization

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Principal Investigator

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Sponsor

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

Keyword Name

Dashboard prompt

  • Choice list

  • Select multiple values enabled

  • Default selection: All values

The following table lists the views for the Award Administrator analysis.

View

Displayed Information

View Name

Award Administrator

View Sections

  • Award Summary

  • Award Financials

Graphs and Measures

  1. Award Summary Measures and Graphs

    • Award Started Within 60 Days

    • Draft Awards in Next 7 Days

    • Award Expiring

    • Award Certification Expiring

    • Unallocated Funding Amount

    • Unbudgeted Amount

    • Active Award Contribution Report

    • Active Award Total Unallocated Funding

    • Active Award Trend

    • Active Award Direct Vs Indirect Amount Comparison

  2. Award Financials Measures and Graphs

    • Project Cost

    • Percentage Cost Budget Spent

    • Overspent Projects

    • Underspent Projects

    • Expenditure by Sponsor and Expenditure Category

    • Cost Trend

    • Top 10 Active Award by Budget

    • Top 10 Overspent Projects

    • Indirect Cost Recovery