Query Reporting Rel 8.48

What you will learn

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.

Learn To:
  • 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

Course Objectives
 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 Topics
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