PeopleSoft Query Reporting Tools Ed 1

Course Details
Code:
PPL-QUERY-TOOLS1
Tuition (USD):
$2,700.00 • Classroom (3 days)
$2,565.00 • Virtual (3 days)

This PeopleSoft Query Reporting Tools Ed 1 training covers the following PeopleSoft query reporting tools:>

  • PeopleSoft Query.
  • Composite Query.
  • Connected Query.

Note: This course is taught using PeopleTools 8.55.

Learn To:

  • Filter output with criteria and runtime prompts.
  • Work with multiple tables and summary calculations.
  • Perform PeopleSoft Query administrative tasks.
  • Create expressions, drilling URLs, standard joins and left outer joins.
  • Use aggregate functions, subqueries, and unions.
  • Run and download query data to popular output formats, including HTML, Microsoft Excel, XML, and CSV formats.
  • Schedule queries to run at specified times.

Benefits to You

Enrolling in this course will help you to understand and use PeopleSoft query reporting tools to extract the precise information you need from your PeopleSoft database to create reports and visual representations of your data, without having to write SQL statements.

Skills Gained

  • Perform PeopleSoft Query administrative tasks.
  • Create expressions.
  • Use drilling URLs.
  • Implement standard joins.
  • Work with unions.
  • Use subqueries.
  • Perform left outer joins.
  • Use Composite Query.
  • Use Connected Query.
  • Describe query reporting.
  • Create simple queries.
  • Filter output with criteria and runtime prompts.
  • Work with multiple tables.
  • Use summary calculations.

Who Can Benefit

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

Prerequisites

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

Course Details

Working with PeopleSoft Query

  • Describing PeopleSoft Query
  • Describing the Uses of the Query Manager Search Page
  • Searching for Existing Queries
  • Organizing and Managing Queries
  • Ordering and Sorting Column Data
  • Running Queries
  • Viewing Objects that use a PeopleSoft Query as a Data Source

Creating a Simple Query

  • Creating Simple Queries
  • Editing Field Properties
  • Removing Duplicate Data

Filtering Output with Criteria

  • Adding Criteria to Queries
  • Adding Criteria Using Commonly Used Condition Types
  • 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 PeopleSoft Query 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 Standard Joins

  • Explaining Standard Joins
  • Describing PeopleSoft Auto-Join

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 Left Outer Joins

  • Describing Joins
  • Creating Left Outer Joins

Using Composite Query

  • Describing Composite Query
  • Creating Composite Queries
  • Editing, Copying and Deleting Composite Queries
  • Adding Additional Base Queries to Composite Queries
  • Adding Filtering Criteria to Composite Queries
  • Adding Runtime Prompts to Composite Queries
  • Adding Drilling URLs to Composite Queries

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:
PPL-QUERY-TOOLS1
Tuition (USD):
$2,700.00 • Classroom (3 days)
$2,565.00 • Virtual (3 days)