Oracle® BI Publisher OBI

Code: O1039
Duration: Days 3
Delivery methods:  
Price per delegate: $1,200
Trained over 60000 delegates
Delivered by world class instructors
Highly competitive pricing
Capped class sizes
Post course support


Course Description
Oracle BI Publisher is a template-based publishing solution available within the Oracle Business Suite, within PeopleSoft, and also in a standalone version. Students familiar with desktop tools such as Adobe Acrobat, Microsoft Excel, and Microsoft Word will learn to create and maintain their own reports via the BI Publisher architecture. This class 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.
** This course covers features of BI Publisher Enterprise through release

Target Student:
Business Users
Report Writers
Oracle Database Administrators
Oracle Analysts
Oracle Developers
Technical Consultants

XML Programming
Familiar with Oracle SQL and SQL Plus

Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Course Content
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
Introduction to BI Publisher
Class objectives
BI Publisher Architecture
Creating 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
Creating RTF Layout Templates Using Microsoft 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 using Adobe Acrobat
Disconnected Report Development
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 Layouts with Form Fields
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
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)
Bursting and Scheduling using a Single Layout
Bursting and Scheduling using Multiple Layouts
Bursting to E-mail
Bursting and Scheduling
Scheduling BI Publisher
Viewing saved output and history
Managing scheduled reports
Using BI Publisher Reports in OBIEE Dashboards
Including a BI Publisher Report in a Dashboard Page
Page level Calculations and Context Specific Content
BI Publisher Analysis Tools
Introduction to XML Reporting and Data Sets
Oracle BI Publisher Administration
Security Models
Configure data sources, users, roles and permissions, delivery
Administrative tasks
Defining a Report Repository Configuring BI Publisher Scheduler
Establishing a Database Connection
Installing BI Publisher Desktop
Creating Layouts for Check
Advanced Layout Exercises

Request More Infomation

Inquiry for
This field is for validation purposes and should be left unchanged.
Learn how Elite helped Aimbridge Hospitality stay ahead of the competition.
View Study