PEOPLESOFT-QUERY-XML PUBLISHER

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
• Publishing and Using Query Feed

Filtering Output with Criteria

• Adding Criteria to Queries
• Refining Criteria
• Using Multiple Criteria Statements
• Using the Effective Date Field as 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 Having Criteria

Performing Administrative Tasks

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

Creating Expressions

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

Drilling URLs in PeopleSoft Query

• Describing Drilling URLs in PeopleSoft Query
• Viewing and Editing Expression Properties
• Running Queries that Have Drilling URLs Defined
• Scheduling Queries that Have Drilling URLs Defined

Implementing Any Joins

• Explaining Any Joins
• Creating Any Joins

Using Sub-queries

• Explaining Sub-queries
• Creating a Single-Value Sub-query
• Creating an In-List or Not-In-List Sub-query
• Creating a Exits or Does-Not-Exist Sub-query

Working with Unions

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

Performing an Outer Join

• 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

Setting Up XML Publisher

• Defining System Properties and Fonts
• Setting Up XML Publisher Permissions
• Setting Up Report Manager
• Defining Report Categories
• Downloading Design Plug-ins

Creating and Registering Data Sources

• Describing Data Sources
• Creating Query-Based Data Sources
• Creating XML File Data Source
• Registering XML File Data Sources

Creating Templates

• Describing Template Types
• Creating RTF Templates
• Using Table Wizard

Defining XML Publisher Reports

• Creating a Report Definitions
• Associating Templates
• Defining Report Output
• Setting Report Properties
• Setting Report Viewing Security
• Creating a Report Definition Based on PDF Template
• Bursting Reports

Running and Viewing Query-Based XML Publisher Reports

• Running Reports in Query Report Viewer
• Scheduling PS Query Reports
• Locating and Viewing XML Publisher Reports
• Using Reporting Console

Implementing Sub-Templates and Template Translations

• Creating Reusable Sub-Template Definitions
• Using Content Library
• Maintaining Template Translations

Using Additional RTF Techniques

• Using Connected Query Data Source
• Using Time Zones
• Using Drilling URL Query

Running Reports Using PeopleCode

• Running Reports Using PeopleCode
• Running Reports from Application Engine
• Creating Application Engine to Create File and Run Report