BI Publisher for PeopleSoft PeopleTools Rel 8.53

Course DateLocationDaysPriceRegister
Oct 26, 2017Ottawa2 $2,420Register
Dec 18, 2017Toronto2 $2,420Register
Feb 21, 2018Toronto2 $2,420Register
Apr 23, 2018Toronto2 $2,420Register


Course DateLocationDaysPriceRegister
Oct 26, 2017Live Virtual - 9:00 am Eastern2 $2,320Register
Nov 20, 2017Live Virtual - 9:00 am Eastern2 $2,320Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $2,140Register


BI Publisher for PeopleSoft PeopleTools Rel 8.53

Description: This BI Publisher for PeopleSoft Rel 8.53 training is a template-based reporting solution that separates the data extraction process from the report layout and allows you to reuse extracted application data into multiple report layouts. It's designed for developers and power users who will be creating and maintaining custom reports.

Duration: 2 Days

Learn to:

  • Identify data sources.
  • Create templates.
  • Use common templates.
  • Use rich text.
  • Use XSL Mapper.
  • Define BI Publisher reports.
  • Run BI Publisher reports.

Course Objectives:

  • Create and register data source
  • Create templates
  • Define BI Publisher reports
  • Run and view BI Publisher reports
  • Describe BI Publisher
  • Set up BI Publisher for PeopleSoft applications
  • Use XSL Mapper
  • Use rich text in BI Publisher reports

Audience:

  • Reports Developer
  • Technical Consultant

Required Prerequisites:

  • Experience with relational databases
  • Experience with report writing techniques
  • PeopleSoft Query Reporting Rel 8.53

Topics:

Technology Overview

  • Describing BI Publisher
  • Describing BI Publisher Phases
  • Describing Optional Features

Setting Up BI Publisher

  • 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 Sources
  • Registering XML File Data Sources

Creating Templates

  • Describing Template Types
  • Creating RFT Templates
  • Using Table Wizard
  • Using Pivot Table
  • Working with PDF Files

Defining BI Publisher Reports

  • Creating a Report Definition
  • 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 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 Rich Text in BI Publisher

  • Describing Rich Text Support
  • Using RTE in BI Publisher Reports
  • Creating a Template that Includes Rich Text Editor Data
  • Using Query or Connected Query as a Data Source
  • Using XML File as a Data Source

Using Common Templates in BI Publisher

  • Describing Common Templates
  • Creating a Report Definition Using Common Template
  • Using Oracle XSL Mapper

Using Additional RTF Techniques

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

Additional Setup in BI Publisher

  • Defining Properties and Fonts
  • Setting Up BI Publisher Permissions

Running Reports Using PeopleCode

  • Running Reports Using PeopleCode
  • Running Reports from Application Engine
  • Creating Application Engine to Create File and Run Report
Course DateLocationDaysPriceRegister
Oct 26, 2017Ottawa2 $2,420Register
Dec 18, 2017Toronto2 $2,420Register
Feb 21, 2018Toronto2 $2,420Register
Apr 23, 2018Toronto2 $2,420Register


Course DateLocationDaysPriceRegister
Oct 26, 2017Live Virtual - 9:00 am Eastern2 $2,320Register
Nov 20, 2017Live Virtual - 9:00 am Eastern2 $2,320Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $2,140Register