Oracle Business Intelligence Publisher Online Help

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

Viewing and Scheduling Reports

Logging In

Accessing Business Intelligence Publisher Enterprise

Setting Preferences

Setting Preferences

Navigating the Reports Repository and Viewing a Report

Navigating the Reports Repository

Viewing a Report Through the Report Viewer

Viewing a Report Through the Report Viewer

Using the Online Analyzer

Using the BI Publisher Analyzer for Excel

Scheduling a Report

Scheduling a Report

Scheduling a Report to Be Burst

Using Oracle BI Publisher in Oracle Enterprise Performance Management Workspace

Using Oracle BI Publisher in Oracle Smart Space, Fusion Edition

Managing Your Scheduled Reports

Managing Your Scheduled Reports

Viewing Report History and Saved Output

Viewing Report History and Saved Output

Creating Reports and Layouts

Creating a New Report

Process Overview

Create the Report Entry and Specify General Properties

Using the Report Editor

Defining the Data Model

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

Defining the Data Model for Your Report

Introduction

About the Data Model Options

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 an Oracle BI Discoverer Data Set Type

Defining a File as a Data Set Type

Defining an MDX Query Data Set Type

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 Date 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

Guidelines for Designing RTF Templates for Microsoft PowerPoint Output

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

Adding or Designating a Field for a Digital Signature

Creating Flash Templates

Introduction

Building a Flash Template

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

Integrating with Oracle Database Security

Implementing a Digital Signature

Using the Admin Functions

Overview

Managing Reports and Folders

Folder Tasks

Setting Up Data Sources

Setting Up Data Sources

Setting Up Integrations

Introduction

Setting Up Integration with Oracle BI Presentation Services

Setting Up Integration with Oracle BI Discoverer

Setting Up Integration with Oracle Enterprise Performance Management Workspace

Integration with Oracle Enterprise Performance Management Workspace

Configuring Oracle BI Publisher with EPM Workspace

Setting Up Integration with Oracle Smart Space Client

Setting System Maintenance Options

Setting System Maintenance Options

Defining Your Report Repository

Setting Server Configuration Options

Installing the Scheduler Schema

Setting Up Delivery Options

Introduction

Setting Up Delivery Options

Setting Runtime Properties

Setting Runtime Properties

Defining Font Mappings

Setting Up Print Servers

Setting Up CUPS

Windows XP Setup

Developer's Guide

Using the BI Publisher APIs

Introduction

BI Publisher Core APIs

Prerequisites

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

Setting Up an After Report Trigger

Overview

Setting Up the After Report Trigger

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 or 10.1.3.3

Overview

Index