PeopleSoft Query Reporting Rel 8.53 (Training On Demand)

Course Details
Code:
D91556GC11
Tuition (USD):
$2,445.00 $2,322.75 • Self Paced
GSA (USD):
$2,093.95 • Self Paced (3 days)

This PeopleSoft Query Reporting Rel 8.53 training covers basic and advanced functions of PeopleSoft Query. You'll learn how to design reports that use criteria to filter data or that use predefined online calculations.

Learn To:

  • Filter output with criteria and runtime prompts.
  • Work with multiple tables and summary calculations.
  • Perform PSQuery administrative tasks.
  • Create expressions, drilling URLs, any-joins and outer-joins.
  • Use aggregate functions, subqueries, and unions.
  • Use Query Manager, Query Viewer, Query Scheduler, Query Administrator, and Connected Query.

Benefits to You

Enrolling in this course will help you understand PeopleSoft Query. You will use runtime prompts, expressions, criteria rows, aggregate functions, joins, subqueries, unions and so on. Learn how to extract the precise information you need to create visual representations of the PeopleSoft database, without having to write SQL statements.

Create Reports with Runtime Prompts

You also learn to create reports with runtime prompts that build flexibility and reusability into your reports and decrease your report design time. Schedule queries to run while you are away so your reports always run on time, learn advanced techniques to view the exact data that you need, use expressions to perform configurable online calculations and combine data from unrelated tables or multiple queries to return one set of data.

Perform Query Administration Tasks

In addition, you will learn how to perform Query administrative tasks. You will also develop the skills to apply complex Query features. This will further enhance your knowledge of PeopleSoft Reporting Tools.

Skills Gained

  • Use Query Manager
  • Create simple queries
  • Work with Multiple Tables
  • Filter outputs with criteria and runtime prompts
  • Create expressions
  • Use summary calculations
  • Use drilling URLs in PeopleSoft Query
  • Describe query reporting
  • Implement Any Joins
  • Use subqueries
  • Work with unions
  • Perform outer-joins
  • Perform PSQuery administrative tasks
  • Use Connected Query

Who Can Benefit

  • End Users
  • Financial Reporting Manager
  • Project Manager
  • Reports Developer

Prerequisites

  • Basic knowledge of PeopleSoft navigation, PeopleSoft concepts, and PeopleSoft Architecture
  • Basic knowledge of relational databases, effective-date, translated values, trees, key fields, and prompt tables.

Course Details

Using Query Manager

  • Searching for Existing Queries
  • Editing Existing Queries

Creating a Simple Query

  • Selecting Query Output and Editing Query Properties
  • Editing Field Properties
  • 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
  • Creating Multiple Runtime Prompts

Working with Multiple Tables

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

Using Summary Calculations

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

Performing PSQuery Administrative Tasks

  • Running a Query from Query Viewer
  • Scheduling a Query
  • Monitoring Query Performance and Use

Creating Expressions

  • Defining Expressions
  • Creating Simple Expressions
  • Using Literals in Expressions
  • Using Functions in Expressions
  • Using Expressions in Criteria
  • Using Links in Expressions
  • Using Prompts in Expressions
  • Using Aggregates in Expressions

Drilling URLs in PeopleSoft Query

  • Describing Drilling URLs in PeopleSoft Query
  • Defining Query URL Widgets
  • Defining Component URL Widgets
  • Defining External URL Widgets
  • Defining Freeform URL Widgets
  • Running Queries that Have Drilling URLs Defined
  • Scheduling Queries that Have Drilling URLs Defined

Implementing Any Joins

  • Explaining Any-Joins
  • Creating Any Joins

Using Subqueries

  • Explaining Subqueries
  • Creating a Single-Value Subquery
  • Creating an In-List or Not-In-List Subquery
  • Creating an Exists or Does-Not-Exist Subquery

Working with Unions

  • Explaining Unions
  • Using Literals as Placeholder Fields
  • Creating Unions
  • Viewing Union SQL

Performing Outer Joins

  • Describing Outer Joins
  • Creating Standard Outer Joins

Using Connected Query

  • Describing Connected Query
  • Using Connected Query Quick Start
  • Using Connected Query Manager
  • Using Connected Query Viewer
  • Using Connected Query Scheduler
Course Details
Code:
D91556GC11
Tuition (USD):
$2,445.00 $2,322.75 • Self Paced
GSA (USD):
$2,093.95 • Self Paced (3 days)