Upgrade Impacts to the U-M Data Warehouse
Plan ahead! The SA/HRMS upgrade to v.9 requires changes to some table and field structures in the U-M Data Warehouse.
Report Update Process and Effort Summary
| Report Type |
Effort Required |
Timing |
BusinessObjects
UM-Maintained Reports
Created/maintained by MAIS/central offices |
MAIS & appropriate central offices will update all UM-Maintained reports. |
Updated reports will be available in the UM-Maintained folder when the data set (s) are upgraded in June.
See the data set upgrade schedule |
BusinessObjects
User Reports
Created/maintained by individual users |
1. The WebI user who creates and/or maintains reports must review their reports to determine which reports require modifications. |
Before the upgrade, review the change documents to determine which reports need to be updated. |
| 2. Update affected reports. |
Anytime after the data set(s) upgrade in June. See the data set upgrade schedule. |
Other User Reports
Created/maintained in a query tool other than BusinessObjects |
1.The user who creates and/or maintains reports must review their queries to determine which reports require modifications.
|
Before the upgrade, review the change documents to determine which reports need to be updated. |
| 2. Update affected reports. |
Anytime after the data set(s) upgrade in June.
See the data set upgrade schedule |
Data Set Refresh and Upgrade Schedule
Data sets will be available during SA and HRMS upgrade weekend (Thu. June 5, 5:00 p.m. - Mon. June 9, 7:00 a.m.), except when the data sets are being refreshed or upgraded. See table below.
Note: No SA or HRMS data set refreshes will occur from Friday, June 6 - Sunday, June 8.
| Data Set |
Last Refresh Before Upgrade |
Data Set Upgrade Date |
First Refresh After Upgrade |
| Adm Roster |
Thu, 6/5, 5–7 p.m. |
Mon, 6/9, 5 p.m. – Tue, 6/10, 7 a.m. |
During data set upgrade |
| Adm Snapshot |
Normal refresh time |
Fri, 6/13, 9 a.m. – 2 p.m |
Normal refresh time |
| Benefits |
Thu, 6/5, 12:15 - 7 a.m. |
Fri., 6/13, 5 p.m. – Sat, 6/14, 7 a.m. |
During data set upgrade (main tables); other tables per normal schedule |
| CRAS |
Normal refresh time |
Tue, 6/17, 5 p.m. – Wed, 6/18, 7 a.m. |
Normal refresh time |
| Financial Aid/Student Financials |
Wed, 6/4, 11 p.m. – Thu, 6/5, 7 a.m. |
Thu, 6/12, 5 p.m. – Fri, 6/13, 7 a.m. |
During data set upgrade
(FA Award Estimate table refresh on 6/17) |
| Human Resource |
Thu, 6/5, 6 p.m. - midnight |
Thu, 6/12, 5 p.m. – Fri, 6/13, 7 a.m. |
During data set upgrade |
| HR Snapshot |
Normal refresh time |
Thu, 6/12, 5 p.m. – Fri, 6/13, 7 a.m. |
Normal refresh time |
| Payroll |
Normal refresh time |
Sun, 6/8, 8 a.m. – Mon, 6/9, 7 a.m. |
Normal refresh time |
| Recruiting and Admissions |
Thu., 6/5,, 5–8 p.m. (not all tables) |
Sat, 6/14, 11 p.m. - Mon, 6/16, 7 a.m. |
During data set upgrade |
| Student Records |
Thu., 6/5, midnight–7 a.m. |
Sat, 6/14 11 p.m. - Mon, 6/16, 7 a.m. |
During data set upgrade |
| Student Retention and Completion |
Normal refresh time |
Fri, 6/13 9 a.m. – 2 p.m. |
Normal refresh time |
| Third Week Count |
Normal refresh time |
Sat, 6/14, 11 p.m. - Mon, 6/16, 7 a.m. |
Normal refresh time |
| Time and Labor |
Normal refresh time |
Tue, 6/17, 5 p.m. – Wed, 6/18, 7 a.m. |
During data set upgrade |
Questions or Comments?
Please let us know how we can help you through this upgrade transition by submitting questions or comments on the Upgrade Questions form.
|
CONTACT US
