Browser version scriptSkip Headers

Oracle Business Intelligence Publisher User's Guide
Release 10.1.3.2
Part Number B40017-01
Go to next page
Next

Oracle Business Intelligence Publisher User's Guide

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Viewing and Scheduling Reports

Getting Started

Accessing Business Intelligence Publisher Enterprise
Setting Preferences

Viewing and Scheduling Reports

Viewing a Report
Scheduling a Report
Scheduling a Report to Be Burst
Managing Your Scheduled Reports
Viewing Report History and Saved Output
Using the Online Analyzer
Using the BI Publisher Analyzer for Excel

Creating Reports and Layouts

Creating a New Report

Process Overview
Create the Report Entry and Specify General Properties
Defining the Data Model
Defining a SQL Query Data Set Type
      Using the Query Builder
Defining an HTTP Data Set Type
Defining a Web Service Data Set Type
Defining a Data Template Data Set Type
Defining an Oracle BI Answers Request Data Set Type
Defining a File as a Data Set Type
Adding Parameters and Lists of Values
Adding Layouts to the Report Definition
      Creating an RTF Template Using the Template Builder for Word
      Adding a PDF Template to Your Report
Enabling Bursting
Accessing Reports via a URL

Building a Data Template

Introduction
The Data Template Definition
Constructing the Data Template
Using the Data Engine Java API
      Calling a Data Template from the Java API
Sample Data Templates

Creating an RTF Template

Introduction
      Supported Modes
      Prerequisites
Overview
      Using the BI Publisher Template Builder
      Associating the XML Data to the Template Layout
Designing the Template Layout
Adding Markup to the Template Layout
      Creating Placeholders
      Defining Groups
Defining Headers and Footers
      Native Support
Inserting Images and Charts
      Images
      Chart Support
Drawing, Shape, and Clip Art Support
Supported Native Formatting Features
      General Features
      Alignment
      Tables
      Date Fields
      Multicolumn Page Support
      Background and Watermark Support
Template Features
      Page Breaks
      Initial Page Number
      Last Page Only Content
      End on Even or End on Odd Page
      Hyperlinks
      Table of Contents
      Generating Bookmarks in PDF Output
      Check Boxes
      Drop Down Lists
Conditional Formatting
      If Statements
      If Statements in Boilerplate Text
      If-then-Else Statements
      Choose Statements
      Column Formatting
      Row Formatting
      Cell Highlighting
Page-Level Calculations
      Displaying Page Totals
      Brought Forward/Carried Forward Totals
      Running Totals
Data Handling
      Sorting
      Checking for Nulls
      Regrouping the XML Data
Using Variables
Defining Parameters
Setting Properties
Advanced Report Layouts
      Batch Reports
      Cross-Tab Support
      Dynamic Data Columns
Number and Formatting
Calendar and Timezone Support
Using External Fonts
      Advanced Barcode Formatting
Advanced Design Options
      Namespace Support
      Using the Context Commands
      Using XSL Elements
      Using FO Elements

Extended Function Support in RTF Templates

Extended SQL and XSL Functions
XSL Equivalents
Using FO Elements

Translating Reports

Template Translations
Report File Translations

Creating a PDF Template

Overview
      Supported Modes
Designing the Layout
Adding Markup to the Template Layout
      Creating a Placeholder
      Defining Groups of Repeating Fields
Adding Page Numbers
Performing Calculations
Completed PDF Template Example
Runtime Behavior
Creating a Template from a Predefined PDF Form

Creating an eText Template

Introduction
Outbound eText Templates
      Structure of eText Templates
      Constructing the Data Tables
      Command Rows
      Structure of the Data Rows
      Setup Command Tables
      Expressions, Control Structures, and Functions
      Identifiers, Operators, and Literals

Administering BI Publisher

Defining a Security Model

Security Model Overview
Understanding BI Publisher's Users and Roles
Considerations When Deleting a User
Integrating with LDAP
Setting Up Oracle Single Sign-On
Integrating with Oracle E-Business Suite Security
Integrating with Oracle BI Server Security

Using the Admin Functions

Overview
Setting Up Data Sources
Setting Up Integration with Oracle BI Presentation Services
Setting System Maintenance Options
Setting Up Delivery Options
Setting Runtime Properties
Defining Font Mappings
Managing Reports and Folders
      Folder Tasks

Setting Up Print Servers

Setting Up CUPS
Windows XP Setup

Using the BI Publisher APIs

Introduction
BI Publisher Core APIs
PDF Form Processing Engine
RTF Processor Engine
FO Processor Engine
PDF Document Merger
PDF Book Binder Processor
Document Processor Engine
Bursting Engine
BI Publisher Properties
Advanced Barcode Font Formatting Implementation

Using the Delivery Manager APIs

Introduction
Delivering Documents by e-Mail
Delivering Your Document to a Printer
Delivering Your Documents by a Fax Server
Delivering Your Documents to a WebDAV Server
Delivering Your Document Using FTP
Delivering Your Documents over Secure FTP
Delivering Your Documents over HTTP
Delivering Documents over AS2
Delivering Documents Using an External Command
Delivering Documents to the Local File System
Direct and Buffering Modes
Asynchronous Delivery Requests
Document Filter Support
Date Expression Support
Internationalization Support
Monitoring Delivery Status
Setting Global Properties
Adding a Custom Delivery Channel
Configuration File Support

Supported XSL-FO Elements

Supported XSL-FO Elements

Configuration File Reference

BI Publisher Configuration Files
Setting Properties in the Runtime Configuration File
Structure
Properties
Font Definitions
Predefined Fonts
The Server Configuration Files

Upgrading from XML Publisher Enterprise 5.6.2 to BI Publisher 10.1.3.2

Overview

Index