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

** Enhancement to the Standard Award, Poposal & Expense Report

  • The latest emhancement to this report allows you to refine the Expenditure portion of the report by account number.
  • Using the prompt, the report can be refined to include only 5 ledger accounts, only 6 ledger accounts, both 5 & 6 ledger accounts or a specific account number.

 

**Monthly Proposal Status Updates Report - now includes the Proposal Title to further identify the proposals with changes.

 

**2 New Reports Available - 3-26-12 - The Summary Report of Proposals by Department and the Summary Report of Awards by Department.

 

Summary Report of Proposals by Department - The report:

  • Returns total proposed dollars (Initial Period) and number of proposals by division, discipline & department.
  • Cognos is a reporting tool that enables users to report on data that is stored in the Sponsored Projects data warehouse.
  • Includes drill-thru capabilities to proposal detail
  • Can be refined via prompts on Time Period, Discipline and Department
  • Useful for defining the total proposed dollars (Initial Period) and number of proposals submitted for a division, discipline and/or department.
  • Is available for scheduling.
  •  

    Summary Report of Awards by Department - The report:

  • Returns total award dollars (Obligated to Date) and number of awards by division, discipline & department.
  • Displays several time periods including selected month, 2 lastest Fiscal Year to Dates and the last 4 full Fiscal Years.
  • Includes drill-thru capabilities to award detail
  • Can be refined via prompts on Time Period, Discipline and Department
  • Useful for defining the total award dollars (Obligated to Date) and number of awards submitted for a division, discipline and/or department.
  • Is available for scheduling.
  •  

    **New Report Available - 2/9/12 - The Award & Proposal Activity by Investigator report is now available for department users to run as needed. This is the report that most Chairs and Department Manager/Administrators received quarterly. The report:

  • Is based on an Investigator's current Home Department for the defined time frame.
  • Lists all of an Investigator's activity including Co-PI activity, for the timeframe run.
  • Includes Summary & Detail reports for Award & Proposal activity.
  • Can be refined via prompts on Department and PI.
  • Useful for defining all of an Investigator's activity for a particular time.
  •  

    **New Report Available - 1/23/12 - The Report of Open Awards is now available. The report:

  • Lists Awards that are currently Active or in some form of Closeout.
  • Can be refined via prompts on Department, Award Status, PI and/or Sponsor.
  • Great for determining what awards are currently Active or in Closeout, or determining what Sponsors are actively funding a department.
  •  

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

  • Reporting User Group Meeting

    July 26, 2012 at 1:00pm

    Smith-Buonnano Hall

    Room G12


    Reporting Tools:

    Getting Started with Sponsored Projects Reports

    06/30/2011

    Report Descriptions

    03/27/2012

    Field Definitions

    06/28/2011

    A request for a new report to be created from the Sponsored Projects data warehouse should be submitted using the OSP Report Request Form.

 

*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: