O1039 – Oracle BI Publisher OBI
Enquire/Book this course
Trained over 60000 delegates
Course delivered by industry expert instructors
Highly competitive pricing
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 10.1.3.4
Target Student:
Business Users
Report Writers
Oracle Database Administrators
Oracle Analysts
Oracle Developers
Technical Consultants
Prerequisites:
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
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
Topics:
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
Charts
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
Options
Scheduling BI Publisher
Reports
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
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
