Browser version scriptSkip Headers

Oracle Business Intelligence Publisher Report Designer's Guide
Part Number E12187-01
Go to next page

Oracle Business Intelligence Publisher Report Designer's Guide


Title and Copyright Information

Send Us Your Comments



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

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

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

      Supported Modes
      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
      Chart Support
Drawing, Shape, and Clip Art Support
Supported Native Formatting Features
      General Features
      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
      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
      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

      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

Building a Flash Template

Creating an eText Template

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

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