Oracle Business Intelligence Publisher User's Guide

Skip Headers

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

The Server Configuration Files

Upgrading from XML Publisher Enterprise 5.6.2 to BI Publisher 10.1.3.2

Overview

Index