OASIS - Guide to Running Reports

There are two types of report generators available:

  1. Catalogued Reports - one criteria, all active assets
  2. Ad Hoc Reports - multiple criteria

NOTE:  Reports will only pull data for your department/security level.

CATALOGUED REPORTS
Catalogued Reports will look at all your assets: status A, T and P.
 
This report function allows you to select one specific type of report, such as user, budget or location.
 
You can request a specific data set or all items sorted by that type of data.
 
Process:
Ÿ Click on the button to select which style of report you want.
Ÿ Enter your criteria (if any).
Ÿ You can use wildcards (*) if you wish, e.g., for a specific name use   *JOHNSON*.
Ÿ Click on “Submit Report Request”.
Ÿ OASIS will tell you the report has been submitted.
 
AD HOC REPORTS
Ad Hoc reports allow you to use a multitude of criteria for your selection.
 
NOTE: We recommend that you do not use your Enter or Tab key inside Ad Hoc reports (use your mouse) as it can create problems in the data.
 
Process:
Ÿ Enter a STATUS (A, T, P, N, D are the options – A, T, P is normal).
Ÿ Enter the TITLE (U, A, F are the options – using all three as a generic default is fine unless you wish one title only).
Ÿ Select your remaining criteria, such as budget, custodian / user, building & room, etc.
Ÿ You can use the sorting order boxes for up to three layers. For example:
o   Custodian/user: 1 (A – Z)
o   Building: 2   (each user’s building in alpha order)
o   Room: 3 (each user’s building’s room in order)
o   Note - If you are using Org Code as one of  your criteria, please make sure to enter a 10-digit org code, or your report won't run properly
Ÿ Click on “Submit Report Request”.
Ÿ OASIS will tell you the report has been submitted.
 
IMPORT AND VIEW YOUR REPORT
Reports are generated on the quarter hour.  You will receive an email notifying you that your report has been generated.  This email will also contain a text file of your data. 
 
Warning to Pine Mail Users: Pine mail is unable to open attachments generated by our OASIS system. There is no plan to initiate a fix for this issue at this time.
 
Process:
Receive your email from OASIS that the report is ready and look for the text file.
ŸSave the text file to your desktop or some other location where it an easily be located.
Follow the instructions for Importing into Excel.
 
REPORT PROBLEM SOLVING
Below are a few of the most common report problems campus customers encounter.
 
Problem: Your report comes up blank.
Reason: You forgot to enter the appropriate Status and Title. You will need to rerun the report.
 
Problem: Your report comes up blank.
Reason: Your other criteria were entered in a way that confused OASIS, or you entered a 9-digit org code instead of a 10-digit org code. You will need to rerun the report.
 
Problem: Your report comes back huge when it shouldn’t be.
Reason: You forgot to enter the appropriate Status and Title. You will need to rerun the report.
 

 

   
 
 
© 2016 University of Washington     PRIVACYTERMS