Home » Financial Reports » Departmental Reporting

Reporting Tools

U-M Data Warehouse

The U-M Data Warehouse includes data sets that contain reformatted data from both historical and current systems. The data is from M-Pathways systems, from legacy systems that preceded M-Pathways, and from the Development/Alumni Constituency System. The U-M Data Warehouse, which is accessible on the Web through Wolverine Access, provides read-only data that supports two types of reporting:

  • Ad hoc querying and analysis conducted by users who want to construct their own reports.
  • Predefined reports, which are written to meet specific needs and saved for repeated use, as is or with modifications.

BusinessObjects is the supported query and reporting tool used to access the U-M Data Warehouse. It can be used to access central predefined queries as well as to create ad hoc reports.  For more information on using BusinessObjects to access and retrieve department level reports, visit the MAIS website's BusinessObjects Overview webpage.

ODS

ODS, a read-only copy of the OLTP that is updated every night except Saturday, is used to run standard reports without competing with real-time OLTP transactions.The ODS databases are accessible on the Web through Wolverine Access and include:

  • FinODS: M-Pathways Financial and Physical Resources systems.
  • HEODS: M-Pathways Human Resource Management and Student Administration systems.

Online Transaction Processing System (OLTP)

OLTP databases, where all data entry is performed, are also known as the "production" or "operational" databases. They include:

  • FINPROD: M-Pathways Financial and Physical Resources systems. All financial and physical resources data entry and processing occurs in FINPROD, accessible on the Web through Wolverine Access.
  • HEPROD: M-Pathways Human Resource Management and Student Administration systems. "HE" stands for Higher Education. All human resource, payroll, and student data entry and processing occurs in HEPROD, accessible on the Web through Wolverine Access.
  • DB2: Development/Alumni Constituency (DAC) system that runs on the MAIS mainframe.

M-Reports

M-Reports is a web-based reporting system which delivers interactive management reports and allows for guided analysis of data. The M-Reports system has a custimazable user interface with easy-to-use links to drill down to associated detail. Current content includes payroll and sponsored programs financial reporting. M-Reports is accessible via Wolverine Access (http://wolverineaccess.umich.edu/reporting_secondary.jsp). The navigation path is: University Business > Reporting > M-Reports.

For more information on using M-Reports, visit the M-Reports section of the BI website http://www.bi.umich.edu/products/web_reporting.html.

‹ previousupnext ›

Additional Resources