nav2.gif (7063 bytes)

FIS Data Warehouse User Guide

Welcome | Access | red-cube.gif (982 bytes) Install | Password | Dictionary | User Guide | Mailing List | Announcements | Training

See also
    - OUS produced user manual 
(large PDF document)
    - Old User Guide and Tutorials
(not kept current, but may still has some useful stuff)

Getting Started

The Homepage Screen
Ledger Windows
Attribute Windows
Example

Menus

File,   Edit,    Query,   Results,    Layout,   Host,    Report

Building Queries

OPAL Ledger
General Ledger

Formatting Reports

GQL Standard Report
Changing the Report Title
Resizing Columns
Creating Grand Totals and Subtotals
Formatting Columns with $$$
Adding Ornaments/Speical Titles
Suppressing Duplicates and Detail
Adding Calculated Columns
Saving Report Specifications
Creating Push Button Reports

Appendix

Error Messages
Netting Revenues and Expenses - Appendix A
Adding Attributes for Previous Years - Appendix B
Combining Queries - Appendix C
Inserting Prompts - Appendix D
Netting Debits and Credits - Appendix E

BANNER, SIS, FIS, HRIS, Access, Training, Help, Map, Search, Data WH

Note: This electronic document supersedes all previous versions and is subject to change.
Authors: Mark McCulloch (HRIS) (FIS), and Jim Bouse (SIS)
Contact: Mark McCulloch, Business Affairs Info Services, mmccullo@oregon.uoregon.edu
URL: http://bg.uoregon.edu//default.htm