Oracle BI Publisher 10gR3: Fundamentals (Self-Study Course)
Who should attend
- Business analysts
- End users
- Technical consultants
Course Objectives
- Create BI Publisher reports based on Oracle Database, and other Data Sources
- Create and use a rich text format (RTF) templates
- Create reports using Extensible Markup Language (XML)
- Explain integration points with Oracle BI Enterprise Edition and Oracle BI Discoverer
- Explain the use of a portable document format (PDF) template
- Explain the uses of Oracle BI Publisher
- Explore advanced features such as bursting, scheduling, and email
- Set up, configure, and use the Oracle BI Publisher Enterprise server
Product Description
- Introduction to BI Publisher
- 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 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