Отримати консультацію
Training Center MUKКурсыOracleBusiness IntelligenceOracle BI Publisher 12c R1: Fundamentals

Oracle BI Publisher 12c R1: Fundamentals

Код курсу
3 Днів, 24 Ак. Годин
Опис курсу
Програма курсу
Опис курсу

Course overview

This Oracle BI Publisher 12c 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 Objectives

  • Schedule and Burst Reports
  • Perform Translations
  • Create Reports Integrated With Oracle BI EE
  • Administer BI Publisher Server
  • Describe BI Publisher Technology and Architecture
  • Create reports from OBI EE data sources
  • Create and Modify Data Models
  • Create RTF Templates by Using Template Builder
  • Explore and Use the Form Field Method for Creating RTF Templates
  • Create Layouts by Using the Layout Editor


  • End Users
  • Application Developers
  • Business Analysts
  • Technical Consultant
  • Functional Implementer
  • Reports Developer
  • Business Intelligence Developer
  • Delivery
Програма курсу

Course Topics

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

11. 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
Реєстрація на найближчий курс
Oracle BI Publisher 12c R1: Fundamentals
Код курсу:
3 Днів, 24 Ак. Годин
Отримати консультацію
Свяжитесь со мной
Отримати консультацію
Отправить заявку
Реєстрація на вебінар
Отправить заявку
Ваша заявка отримана!
Ми зв`яжимося з вами найближчим часом.