Oracle BI Publisher 10g R3: Fundamentals

 Oracle University provides a downloadable eKit containing the training materials for this course.

What you will learn:

Oracle BI Publisher (formerly known as XML Publisher) is a revolutionary reporting and document output management solution from Oracle. In this course participants gain expertise with Oracle BI Publisher 10g R3 (10.1.3.3) by gaining a foundation in the fundamentals, and underlying standards. By the end of the course, attendees will be able to create reports based on various data sources such as Oracle Database, Web Services, RSS feeds, and Files. Oracle BI Publisher can be used as a stand-alone reporting product or integrated with the Oracle Business Intelligence Suite Enterprise Edition, and also with Oracle BI Discoverer. So, participants will also learn about these integrations, and be able to create BI Publisher reports based on Oracle BI Server subject area, and Oracle BI Answers.

This course also teaches how to install BI Publisher Desktop (an MS-Word add-in to create report templates), how to create and publish multiple templates for the BI Publisher reports. Students will also perform various administrative tasks such as configuring the scheduler, configuring report delivery media, and setting up Excel analyzer. This course also covers advanced features of BI Publisher such as creating reports with hyperlinks, scheduling and managing scheduled reports, bursting the reports, using online and Excel analyzers to analyze the data in BI Publisher reports, and creating reports from data templates. Hands-on exercises reinforce concepts taught in class.

Learn To:

• Understand the basic concepts and uses of Oracle BI Publisher
• Understand the underlying X standards
• Create and use an RTF template
• Create and use a PDF template
• Set up, configure, and use Oracle BI Publisher Enterprise server

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Instruction Language
View Schedule	Instructor-Led Training	US$ 2,250	3 Days	English	English
View Schedule	Live Virtual Class	US$ 2,250	3 Days	English
Purchase Online	Self Study CD-ROM	US$ 900	not applicable	English

 

Note: To have a more personalized experience, we invite you to: Log In!

Audience:

• Functional Implementer
• Business Intelligence Developer
• Business Analysts
• Technical Consultant
• Reports Developer
• End Users

Prerequisites:

Suggested Prerequisites:

• Oracle 10g: XML Fundamentals

Course Objectives:

• Explain the uses of Oracle BI Publisher
• Create BI Publisher reports based on Oracle Database, and other Data Sources
• Create reports using Extensible Markup Language (XML)
• Create and use a rich text format (RTF) templates
• Explain the use of a portable document format (PDF) template
• Set up, configure, and use the Oracle BI Publisher Enterprise server
• Explore advanced features such as bursting, scheduling, and email
• Explain integration points with Oracle BI Enterprise Edition and Oracle BI Discoverer

Course Topics:

Introduction to BI Publisher

• Oracle BI Publisher: Business Document Requirements
• Functions of Reporting Systems
• Oracle BI Publisher Paradigm
• End-to-End View and Salient Features of BI Publisher

Oracle BI Publisher: Technology and Architecture

• Describe the components of Oracle BI Publisher
• Describe the architecture of Oracle BI Publisher
• Describe the Oracle BI Publisher Underlying Technology

Introduction to XML Standards

• Describe Extensible Markup Language (XML), Extensible Stylesheet Language (XSL), and other X Standards objects
• List the components of an XML document
• Create a well-formed XML document
• Describe XML namespaces, document type definition (DTD), XML Schema, and XML Path Language (Xpath)
• Describe XSL and XSL Transformations (XSLT)

Getting Started with BI Publisher: Creating a Simple Report

• Describe the sample schemas used in course practices (HR,OE, and SH)
• Set up a database connection in BI Publisher
• Opening and viewing a Predefined Report
• Create a BI Publisher Report Based on Oracle Database
• Edit the Properties of a Report
• Upload an existing template for the report and view data
• Export or download a BI Publisher report

Creating Simple RTF Templates

• Describe the functions and features of BI Publisher Desktop
• Describe how to install BI Publisher Desktop
• Create RTF templates for a sample report
• Create and publish RTF templates for BI Publisher reports
• Create RTF templates by using the basic, form field methods
• Insert tables, forms, and charts in RTF templates
• Preview results

Advanced RTF Template Techniques

• Use native MS Word features to format RTF templates
• Use other advanced features

Creating Parameters, List of Values (LOVs), and Hyperlinks

• Create a report with parameters and a list of values
• Create a report with a hyperlink to another report

Working with PDF and eText Templates

• The Basics of PDF Templates
• The advanced capabilities of PDF templates
• The basics of eText templates

Using Oracle BI Publisher Enterprise Administration

• Describe BI Publisher–supported security models
• Configure the data sources, users, roles and permissions, and delivery options
• Perform other administrative tasks
• Defining Report Repository

Scheduling Reports and Analyzing Data

• Configure BI Publisher Scheduler
• Schedule BI Publisher Reports
• View the saved output and history
• Manage scheduled reports
• Schedule reports to be burst to: a file location, and email
• Analyze data in reports

Translating Reports

• Describe the type of translations and options for translating reports by using BI Publisher
• Create translation files by using BI Publisher Desktop
• Create translation files by using the BI Publisher Enterprise Server

Creating Reports by Defining XML Data Templates

• Describe the BI Publisher XML data template
• Create an XML data template
• Associate that data template with a rich text format (RTF) template
• View the report

Integration with Oracle BI Enterprise Edition

• Create a BI Publisher report from a BI Answers request
• Create a BI Publisher report from the BI Server
• Create a BI Publisher report from the BI Discoverer worksheet content
• Add BI Publisher reports to BI Interactive Dashboards

Creating Reports Based on Other Data Sources

• Creating a BI Publisher Report Based on Web Services
• Creating a BI Publisher Report Based on RSS Feeds
• Creating a Report Based on a File

Related Courses:

• Oracle BI Publisher 10gR3: Fundamentals - Self-Study CD Course