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

Writing Your Own Queries

When writing your own query, you define the set of choices and conditions that you want to use to retrieve data stored in the Warehouse. You determine such attributes as data elements to be returned (e.g., last name, city, age), conditions for selecting records (e.g., equal to or less than), and sort criteria (the order and priority in which results are to be sorted).

Here are some generic instructions:

  1. Log in to SAP BusinessObjects InfoView and access your document list.
  2. Start a new report. Click on [New] and then select [Web Intelligence Document] in the drop down menu.
  3. Select the universe you'd like to use (i.e., PennERA Proposals). This will open Webi and the Web Intelligence Java Report Panel, where you can start to build your query.
  4. Select your [Result Objects]. Determine which data elements you want the report to display from the classes (folders) in the left [Data] tab and drag them to the [Result Objects] panel. (Double-clicking moves them too.)
  5. Specify your [Query Filters]. Determine your record selection criteria (e.g., time period, ORG code, etc.).
  6. Select the [Objects] that you want to use in query conditions and drag them either from the [Data] tab or from the [Result Objects] panel into the [Query Filters] panel. Use the operators (Equal to, Different from pattern, Matches pattern, In list, etc.) to further refine the filters.
  7. Run the report. Once you've finished determining and arranging your [Result Objects] and [Query Filters], you can click [Run Query] (at the upper right corner of the Java Report Panel) to execute the report.
  8. Adjust your query. You may want to add or remove [Result Objects] or change [Query Filters] once you see your results. To do this, return to the [Edit Query] window from the [Edit Report] window.
  9. Format the report. Webi provides numerous ways to format your results. Possibilities include:
    • Filter values in columns
    • Rearrange columns
    • Format cells
    • Insert breaks
    • Create sections
    • Add calculations and variables
    • … and many more!
  10. Save your work. Be sure to save the report if you'd like to use it again. As a best practice, purge the report of data (using the Purge button in the upper left next to the [Run Query] or [Refresh Data] buttons) before saving it, to minimize the risk of unnecessarily storing confidential data.

Additional information can be found on the FAQs and How To's pages. Of particular help would be the following:

  • Create a New Webi Document (PDF) (video snippet - SWF)
  • Create Complex Query Filters by nesting or indenting them together, and using AND and OR (HTML includes video snippet - SWF)
  • How do I create a query based on another query? (HTML)

Information Restrictions

Be aware that University data is sensitive and must be handled responsibly. Note that some data may be restricted by school or by department or cannot be released to persons outside the University. Persons who work with student data should also be aware of student rights as stated in the Buckley Amendment.

More information about restrictions on University data is available in Warehouse Security.


top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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