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:
- SU Inquiry Tools
- Decision Support Services (DSS)
- Hyperion Reporting
- Other Tools
One of the standard reporting tools for administrative systems at Stanford is ReportMart1 (RM1), a web-based system used to access distributed administrative reports. RM1 provides a common reporting environment and tools 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).
For more information see the ReportMart1 User Guide.
ReportMart3 (RM3) is the primary reporting tool and environment for the 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, iOU, PCard, and Labor Distribution. For more information, see Overview: About Oracle Financials Reporting.
SU Inquiry Tools
In addition to ReportMart3, 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
See Overview: About Oracle Financials Reporting for additional information on how to access and use SU Inquiry tools.
Decision Support Services (DSS)
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
- 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).
Two tools are available to access the DSS DataMart. Business Objects is the most frequently used and most user-friendly. The other tool, which requires basic knowledge of relational database concepts and techniques, is Hyperion Interactive Reporting. DSS tools work best when; 1) users needs are not met by canned reports (such as those in ReportMart1 and ReportMart3), 2) users are comfortable creating their own queries and reports, and 3) users have thorough knowledge of the data they are retrieving. Reference Resources: Getting Access to Decision Support Services (DSS).
Hyperion budgeting software is used by Budget Planners and Viewers at Stanford University to prepare and review budgets consisting of salary and non-salary expenses as well as beginning balances, revenues, and fund transfers for the coming year. Hyperion Planning and Reports is the master database for the University Consolidated Budget. Hyperion is pre-populated with data from core Oracle Financials and PeopleSoft HRMS applications.
For additional information about Hyperion Reporting and the budget process, see:
- University Budget Office Hyperion Planning & Reports
- Overview: About the Budgeting Process @ Stanford University
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.