Project Management Dashboard

Access the dashboard through the Business Analytics Hub 

Access has been provisioned to anyone with the Oracle BI Consumer JR role. (Staff who do not have access should request the Oracle role.) To access the dashboard:

1. Navigate to bah.ucsd.edu. 
2. Select Budget & Finance. 
3. If using the List View, look for Project Management Dashboard in the list or use the search bar at the top right and click the dashboard name  
   • If using the Card View, click the Budget & Financial Management tab and click Launch on the Project Management Dashboard tile 
4. Use your Active Directory credentials to sign in, if prompted. 

Navigation

• Horizontal tabs at the top of the report under the Project Management Dashboard heading can be used to run each report 

Prompts

Business Scenarios

• What actions do I need to take on my projects?
• What are the balances on my projects that are ending soon?
• Which projects are overspent or ended and need to be closed?
• What are the balances of my projects after planned payroll?  Does payroll need to be adjusted to prevent overspending or underspending?
• Do adjustments need to be made to projects that are being overspent or underspent?
• Are funds available that need to be added to the project budget?
• What are the balances on my non-sponsored projects and tasks?

Report Views 

• Summary displays a high level view of a project portfolio consisting of Sponsored Projects and Non-sponsored projects.  Both GL-based and PPM-based balances are displayed for non-sponsored projects.
• See Faculty and Researcher page for more information about the Sponsored Projects view and differences between GL-based reporting and PPM-based reporting.
• PPM-based balances for non-sponsored projects are displayed in four separate tables depending on project classifications (only a subset of the four tables may display depending on the projects in the portfolio).  Generally, projects for annual operations are reported on a year-to-date basis and projects funded one time or irregularly are reported on an inception-to-date basis.  Line of Service projects are reported year-to-date but include an informational column for Contract Revenue.  Service Agreement projects are reported inception-to-date and include balance calculations based on both the Budget Amount and the Contract Revenue Amount.  See Balance Calculations for more information.
• The dashboard displays financial statement signage. Positive balances represent funds available to spend. Positive resources and non-operating transfers represent an increase in funds. Positive expenses represent a decrease in funds.
• End dates displayed in red shows dates that have passed

Business Scenarios

• Are there old purchase orders that should be closed?
• Who placed the order?
• What requisitions need to be approved or cancelled?

Report Views

• Approved and unapproved commitments are displayed in 2 tables 
• Unapproved commitments are requisitions that have been saved but not submitted, rejected but not canceled, or submitted but not yet approved.
• Only approved commitments are included in the Summary report 
• Links on the Commitment Number go to Oracle (Purchase orders and Invoices) or Kuali (KRS subaward commitments) to view additional details about the commitment.  Commitments starting with TE are Concur requests and no hyperlink is available.  To view details of Concur requests, search for the four-digit request ID within Concur.

Business Scenarios

• Are there GL-PPM differences or payroll costs sitting on default project that are causing my sponsored project balances to be inaccurate?
• Have award increments been obligated in Kuali but not yet reflected in Oracle?
• Have award increments been funded in Oracle but not yet reflected in a project budget?

Report Views

Misplaced Costs on Sponsored Projects:

• Expenses Only in GL: Displays expenses in General Ledger that should post to PPM. Click the amount to view details on the GL-PPM Reconciliation report.
• Payroll on Default Project: Displays payroll amounts that are on the project in the Labor Ledger (UCPath) but on the default project in Oracle. Click the amount to view details on the Default Project Payroll report.

Kuali Oracle Comparison:

• This table compares amounts obligated in Kuali Award to Oracle Award Funding Amounts (external funding only), as well as Project Funding Amounts with Project Budget Amounts.
• This table only shows variances. If an award/project does not have any differences, the row will not appear.
• If Kuali Obligated to Date Amount and Oracle Award External Funding Amount have differences, it may indicate that award funding amounts have not been updated in Oracle Financials.
• If Project Funding and Project Budget Amounts have differences, the Project Unbudgeted Amount shows available amounts to be budgeted for a project.
• Project Status prompt parameter is defaulted to Active, but can be changed on the prompt page. See Prompts under Navigation for more information. 

• An additional table is available to help identify discrepancies between award dates in Kualia and Oracle.

Business Scenarios

• Complete monthly payroll reconciliation

Report Views

• The report defaults to displaying payroll that posted in the last 30 days.  The date range can be changed by entering different to and from dates at the top of the report.
• Click on the Original Transaction Reference number to view the corresponding Oracle transaction on the Transaction Details report.

Business Scenarios

• View a big picture display of payroll based on earnings period
• Provide faculty with a view of how their people were funded over time

Report Views

• Results display a big picture of payroll analysis based on the earnings periods separated by months
• The report defaults to displaying payroll earned in the last six months.  The date range can be changed by entering different to and from dates at the top of the report.

Business Scenarios

• View big picture display of a project's overall expenditures by month

Report Views

• The table displays a project's overall expenditures by specific task, expenditure categories, and months
• The report defaults to displaying expenditures from the last three months.  The date range can be changed by entering different to and from dates at the top of the report.
• Click on an amount to view the transactions that make up the amount on the Transaction Details report.