Workshops are offered throughout the academic year by the Office of Information Technologies and are available to PSU faculty, staff, and students at no cost. To register for classes, send email to mluebke@pdx.edu with the class and date you would like to register for. Please contact the workshop instructor if you have any questions.
Need directions? Please refer to the building locations for more information about where the workshops are held.
This article describes BI Query
BI Query is a Graphical User Interface (GUI) reporting tool. It is a windows-based, "point and click" application that provides an easy-to-use graphical gateway to the PSU Banner warehouse database. BI Query lets user’s run queries provided by the administrator (Canned Queries) or allows user’s to create ad hoc queries of their own.
This article will describe how to obtain, set up, and use PSU's Cisco VPN client for Windows. What the VPN client does is to create a secure 'tunnel' through the internet from your computer to PSU servers, through which your network traffic passes. Your computer is assigned a PSU network address, and appears to the outside world as a computer on the PSU network. This allows you to use resources that are only accessible from the PSU network, such as Banner, or Remote Desktop connections to your work computer.
Instructions on how to create a Button in the User Queries Window that will run your Query
The following guideline demonstrates how to compose a query using BI Query.
The following guideline demonstrates how to automate a query with prompts.
Data Warehouse BI Query articles
Here are the Handouts used in BI Query training
Data Warehouse BI/Query Class One Handout
Data Warehouse BI/Query Class Two Handout
People often use the F9 and F10 keys to perform various functions in INB. If your Mac has OS X 10.3 or 10.4 then you may find that these keys do not work as expected. In Mac OS X 10.3, Apple introduced a new feature called Exposé which allows people to view all open windows as thumbnails. By default, Mac OS X 10.3 and 10.4 reserve the F9 and F10 as keyboard shortcuts for Exposé. In order to use these function keys in INB, you must change the shortcut keys associated with Exposé.
