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