Oracle 11g Business Intelligence Publisher

Oracle Business Intelligence Publisher Training Course ContentsObjectives

• Create BI Publisher templates
• Create and maintain reports using BI Publisher Enterprise
• Create and run reports interactively
• Schedule and deliver reports to recipients
• Explore advanced topics in BI Publisher

• Class objectives
• BI Publisher Architecture

• Describe the sample schemas used in course practices
• Creating a BI Publisher Report from a BI Answers Request
• Creating a BI Publisher Report from the Oracle Database
• Creating a Data Template Report
• Creating a BI Publisher Report from the OBIEE Subject Area
• Creating a Multi-Source BI Publisher Report
• Editing Report Properties

• Exploring the MS Word BI Publisher Interface
• Creating Table Wizard Templates
• Uploading (Pushing) Templates to a BI Publisher Report
• Creating Multiple Layouts for One Report
• Uploading (Pulling) Templates to a BI Publisher Report
• Creating Custom Tables
• Implementing Totals on Layouts
• Creating Summary Group Tables

• Creating PDF templates using Adobe Acrobat

• Exporting a Data Model
• Developing Layouts in Disconnected Mode

• Group-level calculations
• Report-level calculations

• Formatting using native Word features
• Conditional Formatting
• Creating Templates
• Applying Advanced Conditional Formatting
• Applying Page Breaks and Page Numbers

• Creating Crosstabs

• Creating Vertical Bar Charts

• Creating Pie Charts
• Exploring Chart Options

• Creating Two-Column Tables
• Creating Three-Column Tables
• Creating Nested Three-Column Tables

• Duplicating Existing Reports
• Creating Selection Lists
• Creating Parameters
• Filtering with Parameters
• Creating Cascading Parameters

• Using Hyperlinks to Drill and Navigate

• Backgrounds and Watermarks
• Annotating Layouts with Drawings and Shapes
• Table of Contents
• Dynamic Data Columns
• Batch Reporting

• Bursting and Scheduling using a Single Layout
• Bursting and Scheduling using Multiple Layouts
• Bursting to E-mail
• Bursting and Scheduling Options
• Scheduling BI Publisher Reports
• Viewing saved output and history
• Managing scheduled reports

• Including a BI Publisher Report in a Dashboard Page

• Page level Calculations and Context Specific Content

• Review of BI Publisher Analysis Tools

• Introduction to XML Reporting and Data Sets

• Security Models
• Configure data sources, users, roles and permissions, delivery options
• Administrative tasks
• Defining a Report Repository
• Configuring BI Publisher Scheduler
• Establishing a Database Connection
• Installing BI Publisher Desktop
• Creating Layouts for Check Printing
• Advanced Layout Exercises

• Configuring Presentation Services Integration Navigating Oracle BI EE
• Reports based on OBIEE Subject Area
• Data Models and Reports based on a BI Server SQL Query
• Data Models and Reports based on an Oracle BI Analysis
• Adding a BI Publisher Report to an Oracle BI EE Dashboard

• Configuring Presentation Services Integration
• Web Services Data Source
• HTTP (XML/RSS Feed) Data Source
• Proxy Setting for Web Services and HTTP Data Sources
• BI Publisher Reports based on an External Web Service
• BI Publisher Reports based on an HTTP Data Set
• BI Publisher Reports Based on XML File
• BI Publisher Reports Based on CSV Data source