Announcement - Decommissioning of OBIEE
For additional information on the decommissioning of OBIEE, visit the Project Readiness page. This will provide an overview of the planned approach as well as what current phase the project is in.
This page contains information about the University of Wisconsin Systems Business Intelligence functionality, access, and helpful tools.
Quick Guides
This section includes one-pager guides that help to quickly complete tasks in OBIEE.
Training & Videos
UWBI training is hosted through the University of Wisconsin's Digital Learning Environment (DLE) Tool Canvas. To get access to UWBI courses in Canvas, please contact your BI Trainer and then log in to Canvas.
KALTURA MEDIASPACE UW BI Recorded Videos (Login, Basic Navigation, Exporting, Customizations & Favorites).
HRS Shared Query Workshop Recordings:
HRS Getting Started
To get started with HR access in OBIEE you will need to review this Knowledge Base Document: Request HRS Security Roles in HRS (wisconsin.edu).
Process Considerations:
- Security role request process: Request is initiated on behalf of an employee -> employee must sign the compliance agreement -> approver must approve role request (2nd approver also if needed) -> HRS process runs to assign role to employee.
- The process to assign approved role to an employee runs approximately once every hour.
- Only employees with the Requestor security role (GT Security Form Requester) will be able to request roles on behalf of themselves or another employee
To view information about training, please contact your institutional Trainer.
Getting Started with HRS Data
HRS Shared Query Library
NOTE: For accessing shared queries, please contact your Institutional Support Contact as each Institution may have alternative security requirements for access.
- UWBI Production
- Requesting UWBI HRS Shared Queries Access
- Acquire (if a new user) one or more of the following four roles:
- BI HRS Qry-Non-Sensitive
- BI HRS Qry-Benefits Only
- BI HRS Queries-Sensitive
- HRS OBIEE Non-HRS Queries-NS (Allows users to run OBIEE HRS related analyses and reports with non-sensitive information created by campuses. It does not provide access to the HRS Shared Queries. It should not be requested if someone has any of the other three BI roles.)
- Access to the UWBI HRS Shared Queries requires Multi Factor Authentication (MFA). Visit UW Digital IDs to manage.
- The one-time password required to access cab be generated via a FOB or via a free app (available for both iOS and Android devices). For assistance in this matter see the UW Digital ID (One-Time Password) – Requesting an OTP Token knowledgebase article.
- Acquire (if a new user) one or more of the following four roles:
- UWBI HRS Shared Queries online basic training materials
HRS Subject Areas/Author Access
CDR Getting Started
To get access to CDR data in OBIEE, you will need to review the below authorization forms, resources, and data access forms. if you need assistance, please contact your institution's designated CDR Liaison.
Getting Started with CDR Student Data
NOTE: For accessing Student CDR through OBIEE users must already have been granted authorization to subject areas. Please use the authorization form and also contact your Institutional Support Contact as each Institution may have alternative security requirements for access.
- Requesting CDR Access
- Acquire (if don’t have already) the following dataview roles:
- CDR Student
- CDR Curricular
- CDR Financial Aid
- CDR Applications and Admissions (MAAD)
- Instructional Analysis and Information (IAIS)
- These roles are acquired via a Data Access Authorization Request Form that can be found HERE. Entering Supervisor is required for the approval process.
- UWBI Production (with access you can get into OBIEE with this quick link)
- This guide shows you how to navigate to the CDR Data in OBIEE
- Acquire (if don’t have already) the following dataview roles:
| CDR Data | Description |
| UWCDR Curricular Area Codes Data | This is a copy of the UWSA.C_CAC table with fields renamed. Added fields 'Year Term Combined' and 'Year Term Sort'. Term sort order is Summer, Fall, Winter, Spring. |
| UWCDR Curricular Data | This is a copy of the UWSA.V_C_CDB view with fields named. Added fields 'Year Term Combined' and 'Year Term Short'. Term sort order is Summer, Fall, Winter, Spring. |
| UWCDR High School Data | This is a copy of the UWSA.THS_HIGH_SCHOOL table with fields renamed. |
| UWCDR IPEDS Degree Data | This is a copy of the UWSA.IPEDS_DEGREE table with fields renamed. Added fields 'Year Term Combined' and 'Year Term Sort'. Term sort order is Summer, Fall, Winter, Spring. |
| UWCDR Retention and Graduation Undergraduate Data | This is a copy of the UWSA.V_RETGRAD_UG_YEAR view with fields renamed. Added fields 'Year Term Combined' and 'Year Term Sort'. Term sort order in Summer, Fall, Winter, Spring. |
| UWCDR Student Analytical Data | This is a copy of the UWSA.STUDENT_ANALYTICAL view with fields renamed. Added fields 'Year Term Combined' and 'Year Term Sort'. Term sort order is Summer, Fall, Winter, Spring. |
Tools
The tools listed below include items that will assist in further clarifying the OBIEE tool, HR-specific reports, and crosswalks/mapping.
Usage Reports
The below usage report resources are for those who have granted access to run usage reports in OBIEE.
Data Cookbook
These Data Cookbook resources are for those who have granted permissions to access UWBI's Data Cookbook. The guides vary from End User to Editor to Admin. To view more information on what the cookbook is or to get access, please check out our UWBI Data Cookbook Page.