Overview: About Financial Reporting Tools @ Stanford

There are several Financial Reporting tools at Stanford. This overview provides a summary of the tools and links to additional information.

On this page:

OBI Human Resources Reporting

Oracle Business Intelligence (OBI) Human Resource reporting provides a common reporting environment for Stanford's PeopleSoft applications (Payroll and Student Administration), Axess Timecard time and leave reporting system, Pinnacle (IT Services Billing System), and STARS (Stanford Training and Registration System).

back to top

OBI Financial Reporting

Oracle Business Intelligence (OBI) Financial Reporting is being released in phases by business function. OBI provides integrated reporting on data from PeopleSoft and Oracle Financials via:

  • Simple and interactive reports for administrative and financial staff
  • Robust and dynamic ad hoc analyses for experienced financial analysts

For more information, see OBI Financial Reporting.

back to top

Oracle Financials Reporting Using ReportMart3

ReportMart3 (RM3) is a reporting tool and environment for financial data in the Oracle Financials system. Key modules of the Oracle Financials system (used by distributed users across campus) include Internet Procurement, iBudgets, iJournals, Expense Requests, PCard, and Labor Distribution. ReportMart3 provides access to over 160 predefined, static reports with download capability.

Note:  Business Objects DSS reporting is retiring. For more information see Bulletin: Retirement of Business Objects Access to DSS Universes.

For more information, see Oracle Financials Reporting Using ReportMart3.

back to top

Oracle Financials Inquiry Tools (SU Inquiry Tools and Forms)

In addition to ReportMart3 and OBI Financial Reporting, several web based inquiry tools are available to access Oracle Financials information.

  • Expenditure Type Query
  • Fund Title Query
  • Requisition and Purchase Order Query
  • Signature Authority Query
  • Vacation Query

For more information, see Oracle Financials Inquiry Tools (SU Inquiry Tools and Forms).

To access, Launch Oracle and open the SU Inquiry Tools and Forms folder.

back to top

Business Objects DSS Reporting

The Decision Support Services team provides access to the tools and data necessary for users to create their own reports on an ad hoc basis. Decision Support Services maintains its own DataMart (a.k.a. DSS) with data from Stanford's major administrative systems, including:

  • Oracle Financials
  • PeopleSoft
  • FAAS (Faculty Affairs Academic Secretaries database)
  • SPIDERS (Sponsored Projects Integrated Data Entry Retrieval System)

Data from these systems can be combined. For example, you can link faculty advising with research proposals. The DSS DataMart also contains data from legacy systems (i.e. NSI, CHRIS, GFS, and SUFIN).

You can access the DSS DataMart using Business Objects. DSS reporting work best when:

  • users needs are not met by canned reports (such as those in Oracle Business Intelligence (OBI) Human Resource Reporting, OBI Financial Reporting, or ReportMart3),
  • users are comfortable creating their own queries and reports, and
  • users have thorough knowledge of the data they are retrieving.

Reference Resources: Getting Access to Business Objects DSS Reporting.

Note:  Business Objects DSS reporting is scheduled to retiring. For more information see Bulletin: Retirement of Business Objects Access to DSS Universes.

back to top

Budget Management Reporting

There are many reports available to Budget Officers and Analysts to aid in the budget management process. Depending upon the budget management task, you may use one or a combination of reporting resources available in the Tidemark Budgeting tool or Oracle Business Intelligence (OBI) Financial Reporting. For more information, see Tidemark Budgeting > Reports.

back to top

Other Tools

Excel and Access are two additional tools that are often used for financial analysis and reporting at Stanford. Information Technology Services provides training classes for Excel and Access. For course information and schedules, visit the Information Technology Services Training web site.

back to top