What you need if you are planning to use the
Access to the University of Pennsylvania's Data Warehouse requires 3 things.
You need all three:
- A query tool
Permission (formal authorization to use the data)
To obtain permission to use any of the data housed in the Data Warehouse, you
must complete a "Data Warehouse Access
Request Form" and submit it to Data Administration.
- Please make sure you
have all of the required signatures before you send it along. In some cases,
you will also need prerequisite training before you will be able to get access.
For example: users of General Ledger data must first get a BEN Financials account
(and have BEN Financials
training); users of Student data must first get a
SRS account (and have SRS training).
- Note that obtaining permission is a
different step from getting training!
A query tool (software)
Penn has shifted to browser-based query and reporting, using Business Objects XI3 and Web Intelligence (Webi).
- Webi provides access to Universes that have been created to meet the needs of persons who access specific data collections in the Warehouse, and provides extensive query construction and report formatting capabilities, all in a web environment and without the need for desktop client software.
There are two types of training: query tool training and data training.
training in the use of Business Objects, or whatever query tool
you plan to use, is strongly recommended but not
- For some data collections,
is required before you will be given access.
For others, the training is optional. Consult the "training" section
in each of the data collections for more detailed information. Please
attending training it not enough; you still need permission.