Oracle BI Publisher 11g R1: Fundamentals (D68420) – Outline

Detailed Course Outline

Introduction to Oracle BI Publisher 11g
  • Course Agenda
  • Overview of Oracle BI Foundation Suite
  • Overview of Oracle Fusion Middleware
  • Overview of Oracle BI EE
  • Functions of Reporting Systems including Challenges
  • Introducing BI Publisher Paradigm
  • BI Publisher as a Strategic Reporting Solution for All Applicationss
  • Salient Features of BI Publisher
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
Getting Started with BI Publisher
  • Logging In, the Home Page, and Global Header, and Setting Account Preferences
  • Viewing Reports
  • Managing Repository Objects
  • Managing Favorites
  • Using Create Report wizard to Create Reports
  • Selecting Data: Data Model, Spreadsheet, and BI Subject Area
  • Configuring Report Properties
Using the Data Model Editor
  • Exploring the Schemas Used in the Course
  • Exploring the Data Model Editor UI and the Supported Data Sources
  • Creating a Private Data Source
  • Creating a Simple Data Model based on a SQL Query Data Set
  • Using Query Builder to Build a Query
  • Viewing Data and Saving Sample Data Sets
  • Adding Parameters and LOVs to the Query
  • Configuring Parameter Settings and Viewing Reports with Parameters
Working with Layout Editor
  • Opening the Layout Editor and Navigating 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 Tables
  • Adding Repeating Sections, Text Items, and Images
  • Working with Lists, Gauges and Pivot Tables
  • Creating Boilerplates
Using Template Builder to Create Templates
  • Using the BI Publisher Menu Bar
  • Creating an RTF Template from a 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 in Online Mode
  • Exploring the Basic and Form Field Methods
  • Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting
BI Publisher Server: Administration and Security
  • Describing the Administration Page
  • Creating the JDBC Connections
  • 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
  • Integrating with Oracle BI Presentation Services and Oracle Endeca Server
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
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
Creating Data Models and BI Publisher Reports Based on Other Data Sources
  • Configuring Presentation Services Integration
  • 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 XML File
  • Creating a BI Publisher Report Based on CSV Data source