Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

General Ledger Data Collection Training

General Access Pre-Requisites

  1. Knowledge of the source data. At a minimum, before you use the General Ledger data in the Warehouse, you need to have completed Chart of Accounts training. For information on how to obtain this training, see the Financial Training Department's course descriptions. For more detailed information, see General Ledger Collection Data Security.
  2. BEN Financials ID. It is preferred that you have a BEN Financials ID. You can request an ID after completing BEN Financials training. The request form is available from this page.
  3. Data Warehouse access request form. Before you can access the General Ledger data collection, you must submit a Data Warehouse access request form.
  4. Database concepts. You should understand database terms and concepts such as primary keys, joins, and null values. If you need help with these terms, see the document Relational Database System Concepts.
  5. Ability to use a query tool. ISC provides support to users accessing the Data Warehouse using Business Objects as the query tool. On campus classes in Business Objects are scheduled in Knowledge Link.

Self-Serve, Online Training Options

Knowledge Link: Introduction to the General Ledger Data Collection and Using the FINQUERY Universe at Penn (optional)

This course will orient you to GL data, its organization, and refresh cycle as well as help you to use SAP BusinessObjects (InfoView & Webi) to

  • Modify the available corporate (or "canned") reports by correctly using filters and prompts
  • Create your own queries using variables, filters, etc. to control the data
  • Select the correct balances or journal detail tables (classes) and objects (data elements) to include in your own specific queries

After taking this course, you will also know where to turn for answers and additional help with the General Ledger Data Collection.

Website: General Ledger Tutorial (optional)

The lessons in this tutorial are arranged sequentially. However, if you have experience in writing and executing queries, select the lessons you need to know more about. If you do not have experience in writing and executing queries, read the lessons in the order in which they are listed. To help retain what you've learned, complete the activities for each lesson.

Classroom Activities/Office Hours

Occasionally classroom activities and 'office hours' concerning the GL data collection will be announced and offered. It is recommended to take advantage of the online training opportunities since they are always available at your convenience.

 

  Collection Information:
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania