PeopleSoft Query Reporting Tools Training Ed 1

PeopleSoft Query Reporting Tools Training Ed 1

Introduction:

PeopleSoft Query Reporting Tools Training Ed 1 Course Description

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

  • PeopleSoft Query
  • Composite Query
  • Connected Query

PeopleSoft Query Reporting Tools Training Ed 1Related Courses:

Duration: 3 days

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.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience / Target Group:

End Users
Financial Reporting Manager
Project Manager
Reports Developer

What You Will Learn:

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.

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.

Course Content:

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

Request More Information

Time Frame: 0-3 Months4-12 Months

No Comments Yet.

Leave a comment