UW Business Intelligence (UWBI), also known as OBIEE, is a comprehensive business intelligence and analytics platform replacing the legacy, system-wide reporting tool, Hyperion Interactive Reporting. This primarily impacts HR users of the Query Library tool. UW–Madison will be utilizing the HRS Shared Queries replacing most of the HR/Payroll/Benefits reports in the Query Library, while other reports will be created in Tableau.
Tableau is the primary reporting tool used by UW–Madison for data that comes from the Student Information System (SIS), Shared Financial System (SFS), and InfoAccess. HR Professionals will need to access reports in Tableau that include HR data along with data that comes from other campus systems. These reports are located in the UW–Madison Repository for Administrative Dashboards and Reports (RADAR). For example:
- Reports with NetID (coming from InfoAccess)
Example: Employee Job Detail - Reports with funding data (coming from Shared Financial System)
Example: Salary Funding - Reports with student data (coming from Student Information System)
Example: Current Funding for Graduate and Professional Students IDE - Reports with supervisor data
Example: Employee Supervisor Detail
Additionally RADAR has reports in the Employee Data area that provide both overview and details of a variety of HR metrics. For example:
- Employee Headcount Turnover
Example: Workforce Dynamics - Employee Compensation Information
Examples: Employee Base Compensation Rate Adjustments and Employee Lump Sums
More information about business intelligence and reporting at UW is available from UW System and UW–Madison.
Accessing OBIEE and Tableau
-
Log in to OBIEE
For information on requesting security roles to access OBIEE, refer to HRS Security.
-
Search RADAR for Tableau reports
For information on requesting access to a specific report in Tableau, refer to the access role identified on the report. If you cannot access the report, you need to request access for the specific data group listed on the report.
OBIEE Role | Automatically provisions access to Tableau group |
---|---|
BI HRS Qry-Non-Sensitive | Employee Record Data-Internal |
BI HRS Queries-Sensitive | Employee Record Data-Sensitive |
Training and Resources
- Video Webinar – HRS Shared Queries in OBIEE
- Presentation Slides – HRS Shared Queries in OBIEE
- Quick Guides – OBIEE
- How to use a Tableau Visualization
-
Query Library Crosswalk
This crosswalk includes student reports in addition to HR/Payroll/Benefits.
-
List of HR Reports in HRS
This job aid contains a list of HR reports and queries, a brief description, and a hyperlink to the reports KnowledgeBase document.
Contact
-
HR Information Systems (HRIS)
Office of Human Resources