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
BBR
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

Guidelines for Sharing Queries/Reports

If you would like to contribute queries (also called 'corporate reports') to the shared repository, or have questions about sharing queries, please contact da-staff@isc.upenn.edu and a member of ISC's Enterprise Information & Analytics team will be glad to assist you.

You may also share queries/reports with other users. In preparing a query for the repository, please follow these guidelines:

  • Use prompts with your conditions/query filters to keep the query as generic as possible, and to take advantage of the Data Warehouse built-in security. (For example, COA Org = [prompt], rather than a hard-coded value.)
  • Purge the data from your query before sending, so that others will not be able to see your confidential data.
  • Prepare some brief accompanying documentation for your query so that Enterprise Information & Analytics can make it generally available. Some helpful information might be
    • suggested use,
    • any special timing issues or cautions,
    • a list of all result objects and conditions, and
    • the logic for any report variables.

Please suggest a source for verification of results, if possible.


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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