25,000+ Courses Nationwide
0203 908 2376

Oracle Business Intelligence (BI) Publisher

Oracle BI Publisher - learn to develop, manage and distribute highly sophisticated reports & documents for IT staff, end users and developers.

Hands on Oracle BI Publisher training course structure to provide delegates with skills to author and create Oracle Business Publisher (BI) reporting applications (reports).

Oracle Business Publisher (BI) training course will cover the different options available within the BI Publisher Enterprise reporting portal and how to create a BI Publisher Enterprise online reporting application from scratch.

Attendees will learn to use BI Publisher to harness desktop tools such as Adobe Acrobat, Microsoft Excel, and Microsoft Word  and gain the skills and experience to create and maintain their own reports via the BI Publisher architecture. Covering Data Model Editor, Layout Editor and using OBIEE as a datasource and publisher (via Dashboards) attendees will learn how to harness and distribute data in a meaningful way to transform the 'raw material' of data into an organsiational asset - information.

Who Should Attend?

  • Business Users
  • Report Writers
  • Oracle Database Administrators
  • Oracle Analysts
  • Oracle Developers
  • Technical Consultants

Select specific date to see price, venue and full details.

Learning Objectives

  • Create BI Publisher templates
  • Create and maintain reports using BI Publisher Enterprise
  • Create and run reports interactively
  • Schedule and deliver reports to recipients
  • Explore advanced topics in BI Publisher


XML Programming
Oracle PL/SQL

Course Content

Introduction to BI Publisher

  • Class objectives
  • BI Publisher Architecture

BI Publisher Data Models

  • Describe the sample schemas used in course practices
  • Creating a BI Publisher Report from a BI Answers Request
  • Creating a BI Publisher Report from the Oracle Database
  • Creating a Data Template Report
  • Creating a BI Publisher Report from the OBIEE Subject Area
  • Creating a Multi-Source BI Publisher Report
  • Editing Report Properties

RTF Templates Using Word

  • Exploring the MS Word BI Publisher Interface
  • Creating Table Wizard Templates
  • Uploading (Pushing) Templates to a BI Publisher Report
  • Creating Multiple Layouts for One Report
  • Uploading (Pulling) Templates to a BI Publisher Report
  • Creating Custom Tables
  • Implementing Totals on Layouts
  • Creating Summary Group Tables

Creating PDF templates

  • Creating PDF templates using Adobe Acrobat

Disconnected Report Dev

  • Exporting a Data Model
  • Developing Layouts in Disconnected Mode

Custom Calculations

  • Group-level calculations
  • Report-level calculations

Report Formatting

  • Formatting using native Word features
  • Conditional Formatting
  • Creating Templates
  • Applying Advanced Conditional Formatting
  • Applying Page Breaks and Page Numbers

Crosstabs (Pivot Tables)

  • Creating Crosstabs


  • Creating Vertical Bar Charts

Creating Pie Charts

  • Creating Pie Charts
  • Exploring Chart Options

Developing Form Field Layouts

  • Creating Two-Column Tables
  • Creating Three-Column Tables
  • Creating Nested Three-Column Tables

Parameters and Lists of Values

  • Duplicating Existing Reports
  • Creating Selection Lists
  • Creating Parameters
  • Filtering with Parameters
  • Creating Cascading Parameters


  • Using Hyperlinks to Drill and Navigate

Advanced Layout Options

  • Backgrounds and Watermarks
  • Annotating Layouts with Drawings and Shapes
  • Table of Contents
  • Dynamic Data Columns
  • Batch Reporting

Report Distribution

  • Bursting and Scheduling using a Single Layout
  • Bursting and Scheduling using Multiple Layouts
  • Bursting to E-mail
  • Bursting and Scheduling Options
  • Scheduling BI Publisher Reports
  • Viewing saved output and history
  • Managing scheduled reports

BI Publisher Reports in OBIEE

  • Including a BI Publisher Report in a Dashboard Page

Page level Calculations

  • Page level Calculations and Context Specific Content

BI Publisher Analysis Tools

  • Review of BI Publisher Analysis Tools

XML Reporting and Data Sets

  • Introduction to XML Reporting and Data Sets

Oracle BI Publisher Admin

  • Security Models
  • Configure data sources, users, roles and permissions, delivery options
  • Administrative tasks
  • Defining a Report Repository
  • Configuring BI Publisher Scheduler
  • Establishing a Database Connection
  • Installing BI Publisher Desktop
  • Creating Layouts for Check Printing
  • Advanced Layout Exercises

Integrating BI Publisher with OBIEE

    • Configuring Presentation Services Integration Navigating Oracle BI EE
    • Reports based on OBIEE Subject Area
    • Data Models and Reports based on a BI Server SQL Query
    • Data Models and Reports based on an Oracle BI Analysis
    • Adding a BI Publisher Report to an Oracle BI EE Dashboard

    Data Models and BI Publisher Reports Using Alternative Data Sources

      • Configuring Presentation Services Integration
      • Web Services Data Source
      • HTTP (XML/RSS Feed) Data Source
      • Proxy Setting for Web Services and HTTP Data Sources
      • BI Publisher Reports based on an External Web Service
      • BI Publisher Reports based on an HTTP Data Set
      • BI Publisher Reports Based on XML File
      • BI Publisher Reports Based on CSV Data source

      Related Courses

      Privacy Notice

      In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

      Marketing Permissions

      Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


      We work with the best