Oracle Business Intelligence Publisher Report Designer's Guide

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

Introduction

Overview of the Oracle Business Intelligence Publisher Report Designer's Guide

Getting Started

Accessing Business Intelligence Publisher Enterprise

Setting Preferences

Viewing and Scheduling Reports

Navigating the Reports Repository

Viewing a Report Through the Report Viewer

Using the Online Analyzer

Using the BI Publisher Analyzer for Excel

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

Viewing Report History and Saved Output

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

Setting Runtime Configuration Properties

Setting Runtime Properties

Defining Font Mappings

Supported XSL-FO Elements

Supported XSL-FO Elements

Converting Reports from Oracle Reports to Oracle BI Publisher

Overview

Prerequisites

Running the Conversion Utility

Uploading the PL/SQL Package to the Database

Moving Converted Reports to the Oracle BI Publisher Reports Repository

Testing and Editing Converted Reports

Index