Skip to main content

Cornell University

Facilities and
Campus Services

Research Substantiation: Download OAS Reports

Back to Facilities Inventory Documentation

Last updated: April 2, 2025
Content created: July 18, 2024

For questions about the contents of these reports, please contact the Office of Cost and Capital Assets at <costaccounting@cornell.edu>.

Completing the research substantiation summary documentation for spaces occupied by people who are paid by organized research funds requires downloading two Oracle Analytics Server reports, one for "Salary Distribution" and one for "Research Accounts". The instructions below explain how to obtain a copy of each report as an Excel file.

  1. Login to the Oracle Analytics Server (OAS) web page at https://oasprod.db.cornell.edu/analytics [NetID login required.]  All users of the facilities inventory are granted access to these reports.
  2. In the upper-right corner of the screen, from the blue menu bar, select "Dashboards".
  3. From the choices in the drop-down menu, expand the "IWMS" category.

  4. Select "Facilities Inventory Research" as shown in Figure 1 below.

    Facilities Inventory OAS Dashboards "Facilities Inventory Research"

Figure 1.  The "IWMS" category under "Dashboards" contains research reports under "Facilities Inventory Research".

  1. Select the "Salary Distribution" report from the choices on the top left of the screen.
Options for Salary Distribution and Research Account reports are across the top menu bar

Figure 2.  Select the name of the report such as "Salary Distribution" or "Research Accounts".

  1. In the left sidebar, under "College", uncheck the box to the left of the word "Select" as shown in Figure 3 below.
  2. Also under "College", check the boxes next to the name of the appropriate college or division.  For example, "Agriculture and Life Sciences" is CALS.  If your unit spans two colleges, then select more than one.  For example, "Neurobiology and Behavior" exists both as KFS org 0191 "CALS Neurobiology & Behavior" in "Agriculture and Life Sciences" and as 2181 "Neurobiology and Behavior" in "Arts and Sciences".
From the College choice, uncheck "Select" and choose one or more colleges or divisions

Figure 3.  Select the name of the appropriate college or division from the "College" filter after unchecking the word "Select".

We do not recommend filtering these reports by the KFS org number used in the facilities inventory because it is likely that some or all of the research awards and salaries in these reports are associated with KFS orgs other than the org/s you use in the facilities inventory.  As a result, any report based on a KFS org could contain only a partial list of the information needed to create research substantiation documentation.  We also notice that these reports may contain people who are not associated with your unit.  A full report of the whole college or division is more likely to contain all the entries needed.
  1. Scroll down to the bottom of the left sidebar containing these choices and click "Apply" as shown in Figure 4 below.
Research Substantiation Reports Apply Button is at the bottom of the left sidebar

Figure 4.  To generate report results, click the "Apply" button at the bottom of the sidebar after unchecking "Select" under College and choosing one or more colleges or divisions.

  1. Export the report results using the Export > Data > Excel formatting options as shown in Figure 5 below.
From Export, select Data, then Excel to create an Excel spreadsheet

 Figure 5.  Export the report results to Excel using the Excel > Data > Excel choices at the bottom of the list of report results.

  1. Repeat this process for the "Research Accounts" report.