You are here

Data Resources for Research Administration Community

General Tips

  1. Use eResearch for simple queries. Use this ITS Guide: Search for Awards.  (SAW was decommissioned in 2019).
  2. If your unit does not have access to BusinessObjects and its U-M-Maintained/Research Reports, contact 4-HELP or email [email protected] with the Subject: "eRPM ORSP Tier 3" and the details of your request. 

Training and Support for BusinessObjects

If you need training and support or an introduction to Business Objects, be sure to check out:

This page summarizes some of the excellent resources available at U-M for the research administration community.

The data resources available to the research community include: 

  • a catalog of Research Administration reports in Report Library
    • an expanding suite of visualizations in Tableau
    • new/updated reports in BusinessObjects

In some cases, you may need access privileges granted by OARS (the Online Access Request System). Learn more below! 

Report Library


The Report Library is a list of curated reports from multiple reporting tools, and it is available to research administrators in the Report Library via Wolverine Access.
Report Library - M-Reports

Direct Link: Report Library in M-Reports

  1. Filter “Business Process” by “Research Administration”

Via Wolverine Access: Faculty & Staff > Reporting > Report Library

Once in the Report Library, filter the Business Process by “Research Administration.” (See Image 1 below)
The results include finance and human resources reports related to research administration.

Image 1 (click image to see detail)

 

Tableau 


A series of RAAC Metrics Tableau visualizations were first published in June 2017 with the intention to help schools/colleges/units/departments explore trends in their research administration data.

The visualizations are accessed via Wolverine Access and contain valuable information related to Proposals, the ORSP Deadline Policy, Success Rates, Awards, Budget Period Funding, Expenditures, and Receivables.

 

Tableau button

Direct Link: Tableau Table of Contents

Via Wolverine Access: Faculty & Staff > Reporting > Tableau > RAAC Metrics

Who has access? 

  • MCommunity Groups: 
    • RAAC Committee-at-Large
    • Deans
    • Research Associate Deans
    • Budget Administrators Group
    • Additional groups are maintained by units (contact RAAC Metrics for more info)
  • OARS Proposal Management BusinessObjects users (for Proposal/Award reports)
  • OARS Financials BusinessObjects users (for Expenditures/Receivables reports)

 

Business Objects

There are two collections of reports you may want to access in Business Objects. 

UM-Maintained:  This is a collection of reports formally maintained by the ORSP Data and Reporting team. Some examples are: Proposals, Awards, Other Reports. [ See image]
  • Via Wolverine Access: Faculty & Staff > Reporting > U-M Data Warehouse (BusinessObjects ) > Public Folders > UM-Maintained > Research
Unit-Maintained: This is a collection of community reports from research administrators across U-M, an effort to informally share useful reports beyond the formal reports found in UM-Maintained. RAAC Metrics welcomes suggestions to this collection as research administrators have reports they feel worth sharing with colleagues across campus.

Via Wolverine Access:
Faculty & Staff > Reporting > U-M Data Warehouse (BusinessObjects ) > Public Folders > Unit-Maintained > Research Administration

 

 

OARS Roles

In order to run the reports available in the Report Library, OARS (the Online Access Request System) Roles are required.   

Please follow the guidance from your School, College, or Unit (SCU) on how to obtain this access. Some SCUs have specific individuals that submit the access requests. That individual can provide guidance in determining the role needed and work with the appropriate approver.

Required roles for running all reports:

  • Financials Universe role - “Fin-General Ledger/Budget/Procurement/Asset - BO (DW)”
  • Human Resources role - “HR - BO (DW)”
  • Proposal Management role - “eResearch Proposal Management - BO (DW)”

As always, check with your unit to inquire about any additional procedures.


For input or more information


If, during your exploration, you have questions or would like to discuss ideas, please contact [email protected]. For more information, please visit the Data Resources Summary page on the ORSP website.


Thanks


Thanks to the Research Administration Advisory Council (RAAC), the RAAC Metrics subcommittee, the ORSP Data and Reporting team, the RAAC Training subcommittee, and other central units critical to the research administration process and reporting at U-M for curating and reviewing these materials.

As always, check with your unit to inquire about any additional procedures.

Questions?

If, during your exploration, you have questions or would like to discuss ideas, please contact [email protected]
For eResearch Proposal Management Report Requests: Please email [email protected] with the Subject: "eRPM Tier 3", and details of your request.