Resources for Ad-Hoc Reporting Users

	Password Maintenance
	Desktop Setup
	Using Infomaker
	Finding Data (HDW Data Model)
	Transitioning from the Information Utility
	Oracle Query Building
	Managing User Objects in the HDW

Password Maintenance    (Back to top)
		Change HDW Ad-Hoc password (HTML)

Desktop Setup    (Back to top)
		Setting up users for Ad-Hoc Reporting against the HDW (PDF/65.1 KB)
		Security Policy (PDF 54.2 KB)
		Install Security Software on Windows (PDF/284 KB)
		Install Oracle Network Drivers (PDF/310 KB)
		Install InfoMaker (PDF/329 KB)
		Install Oracle Database Interface for InfoMaker (PDF/370 KB)
		Create an HDW Database Profile in InfoMaker (PDF/157 KB)
		Create an Excel Database Profile in InfoMaker (PDF/170 KB)
		Set Table Refresh Time with InfoMaker (PDF/89.4 KB)

Using Infomaker    (Back to top)
		Create a Tabular Report with InfoMaker (PDF/323 KB)
		View Sample Data for a Table (PDF/163 KB)
		Set Table Refresh Time with InfoMaker (PDF/89.4 KB)
		Import an SQL Text Query into InfoMaker (PDF/238 KB)
		Create a Table (PDF 216 KB)
		Upload an Excel Spreadsheet into a New User Table (PDF/334 KB)
		Manage Permissions on User Objects (PDF/224 KB)

Finding Data (HDW Data Model)    (Back to top)
		View the Harvard University Ad-Hoc Query Data Model (PDF/532 KB)
		View Sample Data for a Table (PDF/163 KB)
		Data Models by Subject Area (PDF/77.4 KB)
		Description Columns in the Detail Listing (PDF/85.8 KB)
		Summary of Chart of Accounts Naming Conventions (PDF/90.0 KB)
		Steps to Create a Parent Summary Report (PDF/90.9 KB)
		Naming Conventions in the HDW (PDF/97.6 KB)

Transitioning from the Information Utility    (Back to top)
		How IU Tables Map to HDW Tables (PDF/72.9 KB)
		How IU Data Elements Map to HDW Data Elements (PDF/109 KB)
		HDW Equivalents of Key IU SQL Phrases (PDF/79.1 KB)
		How tran_type Maps to je_cat_name (PDF/78.7 KB)

Oracle Query Building    (Back to top)
		Oracle SQL Operators for WHERE Clauses (PDF/95.3 KB)
		Key Functions in Oracle SQL (PDF/106 KB)
		Selecting Chart of Accounts Hierarchy Levels for Reports (PDF/71.0 KB)
		Allowable Joins (PDF/102 KB)

Managing User Objects in the HDW    (Back to top)
		Create a Table (PDF/216 KB)
		Upload an Excel Spreadsheet into a New User Table (PDF/334 KB)
		Manage Permissions on User Objects (PDF/224 KB)