Sponsored Projects Reporting

Reporting - Sponsored Projects

In order to access Sponsored Projects Reports in Cognos you must have Coeus access and complete the Cognos Request for Access form found on the Computing Accounts & Passwords Web page.


Access Cognos Reports

Reporting Update

**New Report Available - 10-26-15 - The Proposal Success Rates report is now available for department users to run as needed.  This report summarizes the PI & Department Success Rate for the proposals submitted during the time frame selected.  The report:


-Determines Success Rate by dividing the number of proposals funded by the sum of the total number of proposals submitted during the selected period.


-Lists the total number of proposals submitted and/or funded, the success rate percentage, the requested funding for the proposals, and the obligated and anticipated funding for the funded proposals.


-Can be refind via prompts on Period of Time, Proposal Type, Division, Department, PI, Sponsor Type, and Sponsor.


-Provides Drill Down capabilities to the proposal detail information.


-Useful for defining a Principal Investigator's or a Departments Success Rate as of a particular time.


**WD Expenses added to the Standard Award, Proposal, Expense Activity Available - 9-21-2015 - The report:


-Now includes both Workday and FRS Expenses.  This enhancement enables expenses prior to FY2013 and expenses after FY2014 to be included on the same report.


-The Account Number and/or Grant Worktag detail is included in the Expenditure portion of the report.


Reporting -

The following is a sample list of reports that are available on Sponsored Projects for Departments:


  • Standard Award, Proposal & WD Expense Report

  • Monthly Proposal Status Updates

  • Summary Report of Proposals by Department

  • Summary Report of Awards by Department

  • Award & Proposal Activity by Investigator

  • Report of Open Awards

  • Proposal Success Rates



    **Scheduling Capabilities - The ability to schedule a report to run automatically is being added to several reports. As of 3/26/12, the following reports can be scheduled:

  • Monthly Proposal Activity Report
  • Monthly Award Activity Report
  • Report of Open Awards
  • Award & Proposal Activity by Investigator
  • Summary Report of Proposals by Department
  • Summary Report of Awards by Department



*To make this Report Request Form an editable pdf: Save the pdf to your computer; right   click on the pdf file you saved; choose option OPEN WITH- ADOBE ACROBAT.

  • This will allow you to edit and save this document. 
  • Remember to send completed forms to OSP_Reporting@brown.edu.


    If you have any questions about OSP Cognos Reports or to submit an OSP Report Request Form, please contact OSP_Reporting@brown.edu.

  • Displays several time periods including selected month, 2 lastest Fiscal Year to Dates and the last 4 full Fiscal Years.
Banner Override: