|
Introductory Information |
|
| Links for Documentation | Description |
| Introduction to College of Engineering's IBIS Data Warehouse and User Group (Internet Explorer is recommended for viewing this presentation) | Click on this link to run a PowerPoint Presentation introducing you to the College of Engineering's IBIS Data Warehouse and the IBIS User Group. |
| ODBC Setup for use with COE Data Warehouse | Click on this link for documentation on setting up an ODBC data source on your computer for use with the IBIS Data Warehouse. |
| List of COE IBIS Data Warehouse Tables and Field Names (HTML Version) | Click on this link to go to a table illustrating table names and field names for the College of Engineering's IBIS Data Warehouse. This link will take you to an html version of this documentation. |
| List of COE IBIS Data Warehouse Tables and Field Names (PDF Version) | Click on this link to go to a table illustrating table names and field names for the College of Engineering's IBIS Data Warehouse. This link will take you to an PDF version of this documentation. |
| Download the Latest Users Group Database File |
Click on this link for instructions on how to copy the latest version of the College of Engineering's Users Group database (MS Access) file and to make a shortcut on your desktop. |
| IBIS Data Warehouse Tables and Key Fields | Click on this link for documentation regarding the IBIS Data Warehouse tables and some key fields contained in the dbo_ibis_details#2 table. |
| Link to the IBIS Data Warehouse Database Tables | Click on this link to access and print step-by-step instructions on how to link to the IBIS Data Warehouse tables. |
| PDF file - NEW User-Friendly IBISFIN Tables/Fields (May 2006) |
Click on link to download and print this PDF file that shows the NEW user-friendly
tables and fields that are most commonly used in the College. This
listing is not complete, but shows the comparison of OLD and NEW
user-friendly tables/fields to become familiar with the new IBIS table
structures. Please refer to the University's Official Data Warehouse Documentation site for complete IBISFIN table and field listings https://www.warehouse.ais.psu.edu/datadict/datadict2.ASP?database_name=ibisfin |
|
Information
Regarding University Systems (ISIS, IBIS, FIT, Host Explorer & Hummingbird) |
|
| Links for Documentation | Description |
| Automatically Launch IBIS when Using' Host Explorer' on Your Desktop | Configure your desktop Host Explorer icon to automatically launch ISIS. |
| Automatically Connect to the AIS Mainframe Login Screen when Using 'Hummingbird' on Your Desktop | Configure a Hummingbird "oas.psu.edu" icon on your desktop to automatically launch the AIS Mainframe Login Screen. |
| Turn on NumLock Setting Using Hummingbird | Click on this link for instructions on setting your NUMLOCK to work within Hummingbird to enter numbers from the numeric keypad. |
| Turn on NumLock Setting Using Host Explorer | Click on this link for instructions on setting your NUMLOCK to work within Host Explorer to enter numbers from the numeric keypad. |
| Change Color of Hummingbird Screens (OAS-IBIS) | Click on this link for steps on changing colors in Hummingbird. |
| Change Color of Host Explorer Screens (OAS-IBIS) | Click on this link for steps on changing colors in Host Explorer. |
| Steps to Using FIT 3.0 Macro file with Exported FIT Details in Excel | Click on this link for steps to using College's FIT 3.0 MACROS with exported FIT details. |
| Example Using the TRIM Function from University's User Group Meeting (held 10/24/02) | Click on this link for an illustration of a query using the TRIM Function. |
| Example Using the WHERE Clause from University's User Group Meeting (held 10/24/02) | Click on this link for documentation illustrating a query using the WHERE clause. |
| Example of a Crosstab Query | Click on this link for documentation illustrating a crosstab query. |
|
List of Query Examples - Using
Microsoft Access |
|
| Links for Documentation | Description |
| Show Accounts By Project Director |
Click on this link for instructions on creating a query to display accounts by PI names (Project Director). |
| Show Accounts by PI Name, by End Date, by Fund Number and by Fund Name |
Using the dbo_ib_header table and creating a query and report to show accounts by PI Name. Then modifying the query and report to show accounts by End Date, by Fund Number and by Fund Name. |
| Find Actual Expenditures per Account Number, Cost Center, Fiscal Year and for a particular Report Month |
Use this link for instructions on how to create a query to find Actual Expenditures per Account Number, Cost Center, Fiscal Year and for a particular Report Month. |
| Creating a Query to Show All Accounts with Certain PI Names and Contract Numbers | Use this link for instructions on how to create a query to find all accounts with a cerain PI Name and/or contract number. |
| Creating a 'Crosstab' Query to show all Expenses for a particular fiscal year | Use this link for instructions on how to create a crosstab query and a report that pulls expenses for a particular fiscal year. |
| Using If and Only/If Statements in Queries | This link provides sample queries which use IF and Only/If Statements. |
| Creating a Cross Tab Query to Show Cost Centers by Fiscal Year | Use this link for instructions on how to create a Cross Tab query to show Cost Centers by Fiscal Year and for One Budget. |
| Creating a Query to See All Wages for a Fiscal Year | Use this link for step-by-step instructions on how to create a query to show all wage expenses for a specified fiscal year. |
| Creating a Cross Tab Query to Compare Expenses Over Fiscal Years | Use this link for instructions on how to create a Cross Tab query to show Expenses over Several Fiscal Years. |
|
Other Relevant Information |
|
| Links for Documentation | Description |
| Access 2002 Instructions for Merging Queries into a Word Document | Click on this link for documentation on merging Access 2002 queries with a Microsoft Word Document. |
| Exporting a Query from one MS Access Database to another MS Access Database | Click on this link for step by step instructions on how to export a query. |
| Notes on Creating Crosstab Queries | Use this link for additional notes regarding Crosstab queries. These notes are brought to you by Nancy Sabol (Architectural Engineering). |
05/08/06 spysher@engr.psu.edu