University of Wisconsin–Milwaukee


Getting Started - Advanced Report Writing


I want to write advances queries and create dashboards


Data authorization - you will need to request authorization for the data that you wish to access with queries that you write.
For the Student Data Warehouse, you will be requesting membership in groups for the Data Warehouse - PAWS Student Admin System. For information about the authorization groups for query writing check the Student Data Warehouse Access Groups list.
For other data (e.g. HRS, WISDM, etc.), you will need to follow their authorization process.


You will need to select a reporting tool.

  • The campus-wide supported query tool is the Hyperion Client (Interactive Reporting Studio Client). Request and register for use of this software by requesting the group for the appropriate client for your computer (Windows 7 or XP) under the Hyperion Client Software system in the Auth App.
  • In addition, any SQL-based Oracle compatible query tool can be used (e.g. Miscrosoft Access). Talk to your supervisor or IT staff to obtain this alternate software and anything else needed for connectivity.

In addition to installing the client, you will also need to have the Oracle client (contact UWM Help Desk), the current UWM tnsnames.ora file, and Hyperion Open Catalog Extensions files (oces) installed on your computer. Check the Related Software page for more information.

Check the Training and Support page for software and data training.

Consider joining Werit - information can be found on the Training and Support page.