PeopleSoft: Query Reporting Rel 8.48

Course Overview

The Query Basics portion of this course teaches you to create online reports using PeopleSoft Query. Many users who need to retrieve the stored information are not comfortable with programming. With PeopleSoft Query, you can extract the precise information that you're looking for using visual representations of the PeopleSoft database without writing Structured Query Language (SQL) statements.

By learning to use PeopleSoft Query, you can view the precise data that you need. Learn to design reports that use criteria to filter data or that use predefined online calculations. Learn to create reports with runtime prompts which builds flexibility and reusability into your reports and decreases your report design time. Also, learn to schedule your queries to run while you are away so that your reports always run on time.

The Query Advanced portion of this course teaches you to create complex online reports using PeopleSoft Query. Many users who need to retrieve the stored information are not comfortable with programming. With PeopleSoft Query, you can extract the precise information that you're looking for using visual representations of the PeopleSoft database without writing Structured Query Language (SQL) statements. Extend your knowledge of reporting by using the principles that you learn in Query Advanced. Learn advanced techniques for viewing the exact data that you need. Learn to use expressions that perform configurable online calculations. Learn to combine data from unrelated tables. Learn to use multiple queries to return one set of data.

• View data online
• Build private queries
• Run queries as HTML reports
• Share public queries
• Create expressions and calculations
• Build sub-queries

Audience

• End Users
• Functional Implementer
• Reports Developer

Prerequisites

• Basic understanding of relational databases
• Working knowledge of PeopleSoft Architecture
• Understanding of your company's Reporting requirements

Skills Gained

• Use Query Manager
• Create a simple query
• Specify the retrieved output
• Use prompts to filter data
• Work with multiple tables
• Use summary calculations
• Perform administrative tasks
• Create expressions
• Use the Any Join feature
• Use sub-queries
• Work with unions
• Perform outer joins

Course Outline

Using Query Manager

• Searching for Queries
• Editing Queries

Creating a Simple Query

• Selecting Query Output
• Editing Query Properties
• Creating and Saving Queries
• Removing Duplicate Data

Filtering Output with Criteria

• Adding Criteria to Queries
• Refining Criteria
• Using Multiple Criteria Statements
• Using the Effective Date Field in Criteria

Filtering Output with Runtime Prompts

• Describing Runtime Prompts
• Creating Runtime Prompts

Working with Multiple Tables

• Describing the Purpose of Joins
• Using Record-Hierarchy and Related-Record Joins

Using Summary Calculations

• Describing and Using Aggregate Functions
• Describing and Using Having Criteria

Performing Administrative Tasks

• Using Query Viewer
• Scheduling Queries
• Monitoring Query Performance

Creating Expressions

• Defining and Using Simple Expressions
• Using Expressions in Criteria
• Using Links in Expressions
• Using Prompts in Expressions
• Using Aggregates in Expressions
• Using Literals in Expressions

Implementing Any Joins

• Explaining Any Joins
• Creating Any Joins

Using Sub-queries

• Explaining Sub-queries
• Creating Single Value Sub-queries
• Creating Advanced Sub-queries

Working with Unions

• Explaining Unions
• Using Literals in Unions
• Creating and Viewing Unions

Performing an Outer Join

• Describing Outer Joins
• Creating Standard Outer Joins

PeopleSoft: Query Reporting Rel 8.48 / D19237GC30