BusinessObjects is the ITS-supported query tool used to retrieve and analyze the data in the U-M Data Warehouse. You can use it to create, run, and edit reports in the data areas to which you have access.
For a basic intro to the tool, see BIE001 BusinessObjects - Running Reports (eLearning course).
The U-M Data Warehouse is a collection of data that supports reporting activity for University business. The information is organized in data sets based on subject area (e.g., Admissions Roster or Payroll). The data sets are extracted from the M-Pathways OLTP databases (where data entry is performed) and other University administrative systems. For an overview of the datasets, see MPE200: Introduction to the Student Administration and HRMS Data Sets (eLearning course) and Administrative Data Environments at U-M (web page).
Each data set is refreshed based on a specific schedule (many are refreshed weekly). The U-M Data Warehouse is read-only; you cannot enter or update data.
There are a number of benefits to using the Data Warehouse. For example, you can:
- Access centrally-maintained predefined reports
- Use UM-maintained reports as a starting point for your own customized reports
- Analyze trends (because the Data Warehouse stores data over multiple years)
- Combine data from multiple data sets, such as HR and Payroll, in a single report.
Run, Modify, and Create Reports
BIE001 BusinessObjects - Running Reports (eLearning course) is strongly recommended for new users.
Organize and Share Reports
Note: The default WebI View and Modify preferences are HTML. The other option is the Applet (Java). As of May 2019, using the Applet requires a paid subscription. Most users will not need the Applet-only features, detailed in this document. If you had previously selected the Applet, see this procedure to change your preferences back to HTML.