Data Warehouse Portal

Note: The Data Warehouse (DWH) will continue to be updated through September to support the 2017 year-end close. Portal schedules will run through July 31 after which point the BUG Library and DWH Portal reports will be available only for ad-hoc reporting of historical data. Reports in the Data Warehouse Portal/Oracle EBS and the BUG Report Library (including all BRIOs) will remain available to access historical transactional details. Account balances for fiscal years 2014 through 2017 will be available in Workday.

Overview

The University Data Warehouse is an organized and integrated collection of financial and administrative data. It is specifically designed for reporting and analysis, and can provide both large volumes of data and tightly-defined analytics quickly and efficiently. The Data Warehouse collects, organizes and consolidates data from applications to provide a comprehensive reporting environment.

Login to the Data Warehouse Portal

Accessing the Data Warehouse

Individuals who do not currently have access to the DWH, but need access after Workday Financials launches, will need to submit the Legacy Oracle EBS/Data Warehouse Access Request form (link will become active on July 5). These requests must be submitted by a Business Partner (Operations Manager) or Strategic Business Partner (Lead Administrator). 

For guidance on running Portal reports from the DWH, review Data Warehouse Portal training materials. For log-in error messages with the Data Warehouse Portal, or for password resets, contact the ITS Help Desk

Data Warehouse Portal

The Data Warehouse Portal is the primary report delivery application for the Data Warehouse. Standard reports have been created to meet the typical reporting needs of the University community. Each report has a number of parameters that allow a user to customize its contents to meet specific needs. While the reports are “standard”, each department can meet their unique needs through their selection of reports and by providing specific parameter values.

Training and Documentation

Note: The Data Warehouse (DWH) will continue to be updated through September to support the 2017 year-end close. Portal schedules will run through July 31 after which point the BUG Library and DWH Portal reports will be available only for ad-hoc reporting of historical data. Reports in the Data Warehouse Portal/Oracle EBS and the BUG Report Library (including all BRIOs) will remain available to access historical transactional details. Account balances for fiscal years 2014 through 2017 will be available in Workday.

Here you will find 14 videos, each dedicated to a particular topic related to the Data Warehouse Portal and running reports. There are also related links and resource documentation found below the videos.

New Users: please watch all of the videos in order below, starting with “Welcome and Introduction”.  Each video concludes with a button that will take you to the next video.

Anyone who wants a refresher or specific information on a particular topic about Data Warehouse Reporting features is welcome to visit this page to review the videos, or to use the other resources at the bottom of this page as needed.

eLearning Videos (can be viewed on PCs, Macs, or hand-held devices)

Data Warehouse Portal 11 Training Presentation