Oracle BI Publisher 11g R1: Fundamentals

This Oracle BI Publisher 11g training will help you build a foundation of understanding how to best leverage this solution. Through Classroom Training or Live Virtual Class Training, you'll learn the ins and outs of how to use this solution.

-----------------------------------------------------------
Course objective

Create data models by using the Data Model Editor.
Create BI Publisher reports based on data models.
Create report layouts by using the Layout Editor (online).
Create reports based on OBI EE data sources.
Publish the reports on OBI EE Dashboards.
Schedule reports and burst these reports.

-----------------------------------------------------------
Target Audience

Analyst
Developer
End User
Implementer

-----------------------------------------------------------

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
Performing Translations
Integrating BI Publisher with Oracle BI Enterprise Edition
Creating Data Models and BI Publisher Reports Based on Other Data Sources

-----------------------------------------------------------

Oracle BI Publisher 11g R1: Fundamentals

Oracle BI Publisher 11g R1: Fundamentals

Uplatz

IT Training

IT Training

General