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