Oracle BI Publisher 11g R1 Fundamentals

In this 3 day class we will provide you deep understanding on the core features of BI Publisher 11g. Students will learn how to design data model, develop BI Publisher report using new Online Template builder and popular Microsoft Word Plugin. The course also cover advanced features conditional formats, repeating groups and bursting mechanisms.



This course content is developed on Oracle BI This course is intended for following Audiences

  • Business Analysts
  • Report Developers
  • Power Users


Course Benefits

Students will leave with an comprehensive understanding of BI Publisher 11g product.

The following objectives will be accomplished in this course

• Learn to create Oracle BI Publisher data model using a variety of data sources

• Create and use a rich text format (RTF) template using Microsoft Word and the BI Publisher wizards

• Extend the simple templates by adding custom calculations and conditional formatting

• Create and use charts and pivot tables

• Enhance basic data models with parameters and selection lists

• Enhance templates with advanced layout options

• Distribute reports to multiple recipients through multiple delivery channels

• Use BI Publisher reports in BI Dashboards

• Use the built-in BI Publisher analysis tools

• Understand the basics of using XML

• Understand the basics of administering the BI Publisher environment



Course Outline


Day 1: BI Publisher Technology and Architecture

  • Functional Components
  • Layout Templates
  • Multitier Architecture
  • Enterprise Server Architecture and Performance and Scalability
  • Document Generation Process and Output Formats
  • Supported Data Sources
  • Bursting Overview
  • Internationalization and Language Support
  • Data Model / Report Layout Templates
  • Creating BI Publisher Data Models
  • Creating a Data Model from a SQL Query
  • Creating a Data Model from an OBIEE Subject Area
  • Creating a BI Publisher Reports and Layouts
  • Creating a Report and a Basic Data Layout
  • Exploring Report Properties
  • Using the Layout Wizard


Day 2: Report Development using Word Plugin

  • Disconnected Report Development
  • Exporting a Data Model to a Local XML File
  • Developing Layouts in Disconnected Mode
  • Developing Custom Layouts with Form Fields
  • Adding Dimensional Columns
  • Creating a Nested Table with Subtotals
  • Formatting the Custom Table
  • Custom Calculations
  • Row-level calculations
  • Group-level calculations
  • Report-level calculations
  • Scheduling and Bursting Reports
  • Scheduling and Describing a Report Job and Related Options
  • Managing and Viewing a Report Job
  • Viewing Report Job History
  • Scheduling a Report with Trigger
  • Describing Bursting
  • Adding a Bursting Definition to a Data Model
  • Scheduling a Bursting Job


Day 3: Performing Translations

  • Describing Translation Types
  • Translating by Using the Localized Template Option
  • Translating by Using the XLIFF Option
  • Managing XLIFF Translations on BI Publisher Server
  • Describing the Overall Translation Process
  • Describing Catalog Translation
  • Exporting and Importing the XLIFF for a Catalog Folder Integrating BI Publisher with Oracle BI
  • Enterprise Edition
  • Configuring Presentation Services Integration
  • Navigating Oracle BI EE
  • Creating a Report based on OBI EE Subject Area
  • Creating a Data Model and Report based on a BI Server SQL Query
  • Creating a Data Model and Report based on an Oracle BI Analysis
  • Adding a BI Publisher Report to an Oracle BI EE Dashboard Oracle BI Publisher Administration
  • Security Models
  • Configuring Data Sources
  • Configuring Delivery Options

To Hire a proven Oracle BI Publisher 11g Subject Matter Expert Consultant / Course Author and Instructor who teaches this class, call 800-798-3901 today!

Leave a Reply