eReports, BuckIQ, and database December 2021 retirements
During January 2021, the Data and Analytics Team deployed version 1 of the new OCIO Reporting and Analytics Environment (RAE), also known as the OCIO Data Lake. This new analytics system is designed to replace the existing OCIO Financial Data Warehouse and associated data marts, as well as the Human Resources and Finance subject areas of the OCIO Enterprise Data Warehouse. As we continue to transition to Workday as the primary transactional system for Ohio State data, many users have migrated to using Workday reports for their daily work. Historical PeopleSoft data (from 12/31/20 and prior) will only be available through historical reports in Tableau, archived reports in EDM, and by working with key central unit reporting teams.
Prior to the RAE rollout, in 2018 Tableau Server was released as a new tool for data analysts to use in building new reports, dashboards, and other analytics needs. As a part of rolling out our new analytics environment, we have also been tracking towards the retirement of our existing reporting tools, eReports (Hyperion) and BuckIQ (Oracle BIEE). These tools are utilized by many analysts across the university, and as expected, there usage has declined while we have been transitioning to Workday.
On December 31, 2021, we will be retiring the legacy analytics data stores, as well as the legacy reporting tools. The information below outlines the detail of what systems are affected. Future user community reminders about the December 2021 service retirements will point to this blog post.
eReports and BuckIQ retirement key dates:
- September 1, 2021 - Disable accounts for users who haven't logged in for six months.
- November 1, 2021 - Lockout remaining user accounts (exception process for users requiring access until December 31).
- December 1 through December 31, 2021 - Access exception review continues for calendar year-end and audit processing.
- December 31, 2021 - eReports and BuckIQ to be taken completely offline.
eReports Replacement Options
- For "current and live" data, users should already be using Workday reports
- Some B&F eReports are being recreated in Tableau as historical versions using data sources copied from their original data store and loaded into the RAE (see data stores section below)
- Some financials eReports have been pre-run and will be stored as PDF and CSV files in EDM
- Some OSAS-focused eReports are being recreated as either SSRS or Tableau reports (for more information about these, please contact us)
BuckIQ Replacement Options
- For "current and live" data, users should already be using Workday reports
- Some B&F BuckIQ reports are being recreated in Tableau as historical versions using data sources copied from their original data store and loaded into the RAE (see data storage section below)
- Some OSAS-focused BuckIQ reports are being recreated as either SSRS or Tableau reports (for more information about these, please contact us)
Analytics Data Stores
The following analytics data stores will be retired on Friday, December 31, 2021. The historical data within these data stores are being captured and preserved as a part of the RAE. Analysts that need to continue to have direct access to this legacy data can request access to the RAE. We will preserve copies of this historical data for the foreseeable future:
- OCIO Finance Data Warehouse (DWRPT)
- OCIO Financial GL Analytics Data Mart (GL_ANALYTICS_DMRPT)
- OCIO Enterprise Data Warehouse (EDWRPT)*
- OCIO Employee Analytics Mart (EMPLOYEE_DMRPT)
- OCIO HRA Data Mart (HRA)
* In partnership with the Office of Student Academic Success (OSAS), the Student portion of the Enterprise Data Warehouse (EDWRPT) will continue to be operational and will be populated using data from Peoplesoft Campus Solutions (SIS) on a nightly basis; we have separated the STU components of the EDW from the HR and FIN components; the HR and FIN components will be archived
Additional assistance
To learn more about how to access historical reports and data use the information listed below.
| Focus are | Where to find additional information |
|---|---|
| Historical Reports | To see a list of historical FIN and HR reports that have been recreated in Tableau, please browse the Certified Enterprise Dashboards Tableau report |
| Rewritten OSAS eReports and BuckIQ Reports | To find out more about the rewritten OSAS reports, please contact the Data and Analytics Team or OSAS Analysis and Reporting. |
| Historical Data Requests | If the data you need is not available in an existing historical report (see above), we encourage you to first contact the relevant Central Unit Reporting team. These groups will triage requests and work with the relevant OCIO partners to retrieve the data requested. Information about Designated Central Unit Teams and their focus areas is available in the ARC. |
| RAE Data Access | To learn more about how to access the datasets in the RAE for direct query, please start at Data and Tool access page found at the Data@OSU site. |
| Archive Data Access | To access data stored in the database archive, please contact the Data and Analytics Team. |
| General Data and Analytics Systems and Team Information | For general info about the RAE, Collibra, and Tableau, visit the Data@OSU site. |
| Sign-up for the Data@OSU Mailman List | https://lists.osu.edu/mailman/listinfo/data-at-osu |
| General Inquiries | If you are unsure of what you are looking for, you can always reach out to the Data and Analytics Team. |