Discoverer Reports

---

Overview

Some system-wide reports are available from the UH Discoverer Viewer website. Access to these reports must be requested and is restricted to UH faculty and staff. See below for the request form.

Each report is written with a certain group of users in mind and access is granted through group reporting roles. For example, Report #UHRPT.A1001: Transfer Course Lookup, was written for registrars and individuals who work on course articulation; it is shared with the Registrar and Articulation roles.

When requesting access it is important to specify areas of interest, so that an appropriate group role(s) can be assigned.

Available Reports

The following Discoverer Reports are currently available:

• UHRPT.A1001: Transfer Course Lookup
  Transfer course equivalency rules by transfer institution SBGI code.
  Available to Registrars and individuals who work on course articulation.



• UHRPT.I2001: Control Report Log
  Displays status of ODS daily refresh process and scheduled freeze events.
  Available to Report Developers.



• UHRPT.I3001: Enrollment by Semester (Slice in Time Data)
  Enrollment data with selected demographics and ability to drill down.
  Available to all users with any reporting role.



• UHRPT.I3001A: Enrollment by Semester (Refreshed Daily)
  Enrollment data with selected demographics and ability to drill down.
  Available to all users with any reporting role.



• UHRPT.UHRPT0002: EUL, Query, and Workbook Management
  Discoverer report development and management reports.
  Available to Discoverer Report Developers.

How To Set-up a Connection to Discoverer Reports

1. Enable Cookies
   • Oracle Discoverer Viewer requires the use of cookies. If an error message is received when trying to create a connection, or if previously created connections disappear, confirm that cookies are enabled/allowed.
   • Cookies settings can be accessed in Internet Explorer, by selecting Internet Options from Tools, then clicking on the Privacy tab.


2. Create a Connection
   • Go to the Oracle Discoverer Viewer website at http://rpt03.its.hawaii.edu/discoverer/viewer
   • Click on the Create Connection button.
   • In the Connection Name field, enter a name that will help identify the connection in the future. Example: UHRPT Reports
   • In the Connection Description field, enter a description that is meaningful to the user.
   • In the User Name field, enter UH username.
   • In the Password field, enter password.
   • In the Database field, enter ODS
   .
   • Click the Apply button to continue the connection setup.
   • At the next screen, select UHRPT from the End User Layer field.
   • Click the Apply button to complete the connection setup.

Tips For Viewing Discoverer Reports

• Each workbook can have many worksheets.
• In order to view certain data in a worksheet it may necessary to fill in  parameters which tell the report which data are requested for viewing.
• Data can be exported to spreadsheet applications, e.g., Excel, Lotus 1-2-3.
• Some reports include  drill down capabilities to get to more detailed data.
• Some reports may take a while to run, in some cases up to 8 minutes or more.

Request Access (PDF form)