Oracle BI Publisher 11g R1: Fundamentals

Course DateLocationDaysPriceRegister
Nov 14, 2017Ottawa3 $3,630Register
Mar 26, 2018Ottawa3 $3,630Register
Nov 1, 2017Quebec3 $3,630Register
Jan 15, 2018Toronto3 $3,630Register
Mar 26, 2018Toronto3 $3,630Register
May 23, 2018Toronto3 $3,630Register


Course DateLocationDaysPriceRegister
Dec 5, 2017Live Virtual - 10:00 am Eastern3 $3,480Register
Feb 27, 2018Live Virtual - 10:00 am Eastern3 $3,480Register
Apr 24, 2018Live Virtual - 10:00 am Eastern3 $3,480Register
May 15, 2018Live Virtual - 10:00 am Eastern3 $3,480Register
Mar 7, 2018Live Virtual - 2:00 am Eastern3 $3,480Register
Mar 20, 2018Live Virtual - 2:00 pm Eastern3 $3,480Register
Dec 13, 2017Live Virtual - 3:00 am Eastern3 $3,480Register
Jan 23, 2018Live Virtual - 8:30 pm Eastern3 $3,480Register
Nov 20, 2017Live Virtual - 9:00 am Eastern3 $3,480Register
May 1, 2018Live Virtual - 9:30 pm Eastern3 $3,480Register


Course DateLocationDaysPriceRegister
Self-Paced Learning3 $3,210Register


Oracle BI Publisher 11g R1: Fundamentals

Description: BI Publisher is Oracle's strategic enterprise reporting and publishing solution that enables you to extract data from multiple data sources, create layouts for report data, and publish the highly formatted reports to a wide range of destinations (printers, faxes, email, and document repositories via FTP or WebDav). BI Publisher's report formats can be designed by using familiar tools, such as Microsoft Word or Adobe Acrobat. By using BI Publisher, you can also schedule reports and deliver the reports to multiple delivery destinations required by your business.

Duration: 3 Days

Audience:

  • Functional Implementer
  • Business Intelligence Developer
  • Business Analysts
  • Technical Consultant
  • Reports Developer
  • End Users
  • Application Developers
  • Delivery

Course Objectives:

  • Schedule and Burst Reports
  • Perform Translations
  • Create Reports Integrated With Oracle BI EE
  • Administer BI Publisher Server
  • Describe BI Publisher Technology and Architecture
  • Use Excel Analyzer
  • Create and Modify Data Models
  • Create Layouts by Using the Layout Editor
  • Create RTF Templates by Using Template Builder
  • Explore and Use the Form Field Method for Creating RTF Templates
  • Creating and Working with Style and Sub Templates

Topics:

Introduction to Oracle BI Publisher 11g

  • Course Agenda
  • Overview of Oracle BI Foundation Suite
  • Overview of Oracle Fusion Middleware
  • Overview of Oracle BI EE
  • Evolving role of BI
  • Addressing BI Requirements
  • Functions of Reporting Systems including Challenges
  • BI Publisher as a Strategic Reporting Solution for All Applications

BI Publisher Technology and Architecture

  • Functional Components
  • Layout Templates
  • Enterprise Server Architecture and Performance and Scalability
  • Document Generation Process and Output Formats
  • Supported Data Sources
  • Underlying Technology
  • Bursting Overview
  • Internationalization and Language Support

Getting Started with BI Publisher

  • Logging In, the Home Page, and Global Header, and Setting Account Preferences
  • Viewing Reports
  • Managing Repository Objects
  • Creating Reports: Workflow
  • Opening Report Editor and Selecting a Data Model
  • Previewing and Configuring Layouts
  • Setting Report Properties
  • Using Excel Analyzer

Using Data Model Editor to Create Data Models Based on a SQL Query Data Set

  • Exploring the Schemas Used in the Course
  • Exploring the Data Model Editor UI
  • Examining the Supported Data Sources and Creating a JDBC Connection
  • Defining a JDBC Connection
  • Creating a Simple Data Model Based on a SQL Query Data Set
  • Viewing Sample XML Data Sets
  • Adding Parameters and LOVs to the Query
  • Viewing Reports with Parameters

Working with Layout Editor

  • Opening the Layout Editor
  • Navigating and Reviewing the Layout Editor UI
  • Creating a Layout by Using a Basic Template
  • Inserting a Layout Grid
  • Adding a Table, Formatting Columns, Defining Sorts and Groups, and Applying Conditional Formats
  • Inserting and Editing Charts, and Converting Charts to a Pivot Table
  • Adding Repeating Sections, Text Items, and Images
  • Working with Gauges

Creating RTF Templates by Using Template Builder

  • Exploring and using Template Builder (in MS Word)
  • Using the BI Publisher Menu Bar
  • Craeting an RTF Template froma Sample, Changing Field Properties, and Previewing Table Data
  • Adding a Chart to an RTF Template
  • Designing an RTF Template for a BI Publisher Report
  • Creating a BI Publisher Report by Using Template Builder
  • Exploring the Basic and Form Field Methods
  • Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting

Working with Style Templates and Sub Templates

  • Explaining Style Templates
  • Creating and Managing Style Templates, and Creating an RTF File and Defining Formatting Styles to Create the Style Template
  • Uploading Localized Version of the RTF Template
  • Associating Style Templates with Reports, Assigning it to RTF Report Layouts, and Creating RTF Templates for Use with a Style Template
  • Describing Sub Templates, Creating an RTF Sub Template, Main RTF Template, Locally Testing, and Uploading
  • Describing and Defining XSL Sub Templates
  • Creating and Implementing XSL Sub Templates
  • Calling XSL Sub Templates

BI Publisher Server: Administration and Security

  • Describing the Administration Page
  • Setting, Viewing, and Updating Data Sources
  • Describing the Security Model for BI Publisher and Oracle Fusion Middleware
  • Describing Groups, Users, Roles, and Permissions
  • Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS
  • Describing and Configuring BI Publisher Scheduler
  • Describing Runtime Configuration and Properties
  • Integrating with Oracle BI Presentation Services

Scheduling and Bursting Reports

  • Scheduling and Describing a Report Job and Related Options
  • Managing and Viewing a Report Job
  • Viewing Report Job History
  • Describing Bursting
  • Adding a Bursting Definition to a Report

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 Catalog and Presentation Services Integration
  • Navigating Oracle BI EE
  • Creating a Data Model and Report Based on an Oracle BI Analysis
  • Adding a BI Publisher Report to an Oracle BI EE Dashboard
  • Creating a Data Model and Report Based on a BI Server SQL Query Process

Creating Data Models and BI Publisher Reports Based on Other Data Sources

  • Describing the Web Services Data Source
  • Describing the HTTP (XML/RSS Feed) Data Source
  • Explaining Proxy Setting for Web Services and HTTP Data Sources
  • Creating a BI Publisher Report based on an External Web Service
  • Creating a BI Publisher Report based on an HTTP Data Set
  • Creating a BI Publisher Report based on an Excel Spreadsheet

Course DateLocationDaysPriceRegister
Nov 14, 2017Ottawa3 $3,630Register
Mar 26, 2018Ottawa3 $3,630Register
Nov 1, 2017Quebec3 $3,630Register
Jan 15, 2018Toronto3 $3,630Register
Mar 26, 2018Toronto3 $3,630Register
May 23, 2018Toronto3 $3,630Register


Course DateLocationDaysPriceRegister
Dec 5, 2017Live Virtual - 10:00 am Eastern3 $3,480Register
Feb 27, 2018Live Virtual - 10:00 am Eastern3 $3,480Register
Apr 24, 2018Live Virtual - 10:00 am Eastern3 $3,480Register
May 15, 2018Live Virtual - 10:00 am Eastern3 $3,480Register
Mar 7, 2018Live Virtual - 2:00 am Eastern3 $3,480Register
Mar 20, 2018Live Virtual - 2:00 pm Eastern3 $3,480Register
Dec 13, 2017Live Virtual - 3:00 am Eastern3 $3,480Register
Jan 23, 2018Live Virtual - 8:30 pm Eastern3 $3,480Register
Nov 20, 2017Live Virtual - 9:00 am Eastern3 $3,480Register
May 1, 2018Live Virtual - 9:30 pm Eastern3 $3,480Register


Course DateLocationDaysPriceRegister
Self-Paced Learning3 $3,210Register