Skip to main content

System Status: 

Department Operations Dashboard

This Dashboard provides Year-To-Date overall net financial surplus or loss by Managerial Fund categories, Mission, or Project Classification. 

The Department Operations Dashboard is available from the Business Analytics Hub (bah.ucsd.edu) under the Budget and Financial Management tab. Anyone with the Oracle BI Consumer JR role can access the Dashboard.

Overview

Access has been provisioned to anyone with the Oracle BI Consumer JR role.  Staff who do not have access should request the Oracle role. Access failure appears as error "Unable to load requested view. Displaying home view instead."
  1. Navigate to bah.ucsd.edu. 
  2. Select Budget & Finance. 
  3. If using the List View, look for Department Operations 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 Department Operations Dashboard tile 
  4. Use your Active Directory credentials to sign in, if prompted. 

Additional Information: 

  1. Fiscal Year and Accounting Period are required prompts
  2. Financial Unit prompts
    1. These are cascading prompts so selection in one area will filter the options available
    2. Single Select for Level 2 (VC Area) and Level 3 (School). To remove your selection, hold CTRL and click
    3. Multi Select for Level 4 (Department) or Financial Unit. To remove your selection, click “Deselect all”
  3. This 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.
  4. This Dashboard includes values for Project 0000000 – No Project. It will be classified as No Reporting Category-NRC. Default Projects are also classified as No Reporting Category-NRC.
  5. Until such time as revenue for Contracts and Grants can be captured at the Project level, all Contract and Grant revenue can be found in Project 0000000 – No Project.
  6. All pages have on-page prompts that allow the user to include or exclude data without having to go back to the prompt page. All on-page prompts affect the data displayed in all tabs. For example, if you select “Yes” on the “Exclude Contracts & Grants” prompt on the page, all tabs will then exclude “Contracts & Grants”
  7. A link in the upper right corner “Raw Data Download Here” allows users to download all data into an .xlsx file only utilizing the Accounting Period and Financial Unit prompts. Any on page prompts will not alter the data in the download.

Dept Ops

  • Results display in a table with Managerial Fund hierarchy across the top by Managerial Account Hierarchy on the far left
  • Amounts can be clicked on to provide a Fiscal Year to Date Ending Signed Balance by FinU, Project, Fund and Account. Balances can be further drilled through to the Transaction Details report.
    dept-ops.png

Missions

  • The missions of UC San Diego are broken out using custom logic based on the fund, which groups them into Academic, Clinical, or Research.
  • The Research mission includes Contracts and Grants, Specified State Appropriations, as well as specific funds 18127, 19954, 19956, 19968, and 19981.
  • This enables specified research balances that are the Core or Operating Managerial Fund Hierarchy to be grouped into Research. For example, recipients of California Conservation Genomics Project, Tobacco Related Disease Research, or AIDS Research funds are found in the Managerial Fund Hierarchy in Core or Operating, but on the Missions tab, these balances would be grouped under Research.
  • Amounts can be clicked on to provide a Fiscal Year to Date Ending Signed Balance by FinU, Project, Fund and Account. Balances can be further drilled through to the Transaction Details report.

dept-ops-missions.png

Project Classification

  • Provides ending balance by groups of projects according to their classification.
  • The project classifications can be clicked on to then drill to the GL Project Balances report that displays the balances and any projections by project.

dept-ops-project-classification.png