Oracle BI Publisher 12c R1: Fundamentals (D102075) – Outline

Detailed Course Outline

Introduction to Oracle BI Publisher 12c
  • Course Agenda
  • Functions of Reporting Systems including Challenges
  • Salient Features of BI Publisher
  • BI Publisher as a Strategic Reporting Solution for All Applicationss
  • Overview of Oracle BI Foundation Suite
  • Introducing BI Publisher Paradigm
  • Overview of Oracle BI EE
  • Overview of Oracle Fusion Middleware
BI Publisher Technology and Architecture
  • Multitier Architecture
  • Internationalization and Language Support
  • Supported Data Sources
  • Layout Templates
  • Document Generation Process and Output Formats
  • Bursting Overview
  • Functional Components
  • Enterprise Server Architecture and Performance and Scalability
Getting Started with BI Publisher
  • Managing Repository Objects
  • Viewing Reports
  • Configuring Report Properties
  • Using Create Report wizard to Create Reports
  • Selecting Data: Data Model, Spreadsheet, and BI Subject Area
  • Logging In, the Home Page, and Global Header, and Setting Account Preferences
  • Managing Favorites
Using the Data Model Editor
  • Viewing Data and Saving Sample Data Sets
  • Configuring Parameter Settings and Viewing Reports with Parameters
  • Adding Parameters and LOVs to the Query
  • Creating a Simple Data Model based on a SQL Query Data Set
  • Exploring the Data Model Editor UI and the Supported Data Sources
  • Exploring the Schemas Used in the Course
  • Creating a Private Data Source
  • Using Query Builder to Build a Query
Working with Layout Editor
  • Creating Boilerplates
  • Working with Lists, Gauges and Pivot Tables
  • 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
  • Adding Repeating Sections, Text Items, and Images
  • Opening the Layout Editor and Navigating the Layout Editor UI
  • Inserting and Editing Charts, and Converting Charts to a Pivot Tables
Using Template Builder to Create RTF Templates
  • Exploring the Basic and Form Field Methods
  • Creating an RTF Template from a Sample, Changing Field Properties, and Previewing Table Data
  • Designing an RTF Template for a BI Publisher Report
  • Adding a Chart to an RTF Template
  • Creating a BI Publisher Report by Using Template Builder in Online Mode
  • Using the BI Publisher Menu Bar
  • Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting
BI Publisher Server: Administration and Security
  • Describing Groups, Users, Roles, and Permissions
  • Integrating with Oracle BI Presentation Services and Oracle Endeca Server
  • Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS
  • Describing the Security Model for BI Publisher and Oracle Fusion Middleware
  • Creating the JDBC Connections
  • Setting, Viewing, and Updating Data Sources
  • Describing and Configuring BI Publisher Scheduler
  • Describing the Administration Page
Scheduling and Bursting Reports
  • Adding a Bursting Definition to a Data Model
  • Managing and Viewing a Report Job
  • Scheduling a Bursting Job
  • Viewing Report Job History
  • Scheduling a Report with Trigger
  • Describing Bursting
  • Scheduling and Describing a Report Job and Related Options
Integrating BI Publisher with Oracle BI Enterprise Edition
  • Configuring Presentation Services Integration
  • Creating a Data Model and Report based on a BI Server SQL Query
  • Navigating Oracle BI EE
  • Adding a BI Publisher Report to an Oracle BI EE Dashboard
  • Creating a Data Model and Report based on an Oracle BI Analysis
  • Creating a Report based on OBI EE Subject Area
Creating Data Models and BI Publisher Reports Based on Other Data Sources
  • 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 CSV Data source
  • Describing the Web Services Data Source
  • Configuring Presentation Services Integration
  • Creating a BI Publisher Report based on an HTTP Data Set
  • Describing the HTTP (XML/RSS Feed) Data Source
  • Creating a BI Publisher Report Based on XML File
Performing Translations
  • Exporting and Importing the XLIFF for a Catalog Folder
  • Managing XLIFF Translations on BI Publisher Server
  • Describing the Overall Translation Process
  • Translating by Using the XLIFF Option
  • Translating by Using the Localized Template Option
  • Describing Catalog Translation
  • Describing Translation Types