Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documentation and Other Resources

New Features for Administrators

• New Features for Oracle BI Publisher 11g Release 1 (11.1.1.6)
• New Features for Oracle BI Publisher 11g Release 1 (11.1.1.5)
• New Features for Oracle BI Publisher 11g Release 1 (11.1.1.3)

1 Introduction to Oracle BI Publisher Administration

• 1.1 Introduction
• 1.2 Configurations Performed by the BI Platform Installer
• 1.3 Flow of Tasks for First Time Setup of BI Publisher
• 1.4 Starting and Stopping BI Publisher
  • 1.4.1 Using Oracle WebLogic Server Administration Console
• 1.5 About the Administration Page
• 1.6 About Integration with Oracle Business Intelligence Enterprise Edition
• 1.7 About the Security Model Options
• 1.8 About the Data Source Connections
• 1.9 About Report Delivery Destinations
• 1.10 About Setting Runtime Configuration Properties
• 1.11 About the Server Configuration Settings

2 Configuring Oracle Fusion Middleware Security Model

• 2.1 Understanding the Security Model
• 2.2 Key Security Elements
• 2.3 Permission Grants and Inheritance
• 2.4 Default Security Configuration
  • 2.4.1 Default Users and Groups
  • 2.4.2 Default Application Roles and Permissions
    • 2.4.2.1 Granting the BIAdministrator Role Catalog Permissions
• 2.5 Managing Authentication
  • 2.5.1 Accessing Oracle WebLogic Server Administration Console
  • 2.5.2 Managing Users and Groups Using the Default Authentication Provider
• 2.6 Managing Authorization
  • 2.6.1 Accessing Oracle Enterprise Manager Fusion Middleware Control
  • 2.6.2 Managing the Policy Store Using Fusion Middleware Control
  • 2.6.3 Modifying Application Roles Using Fusion Middleware Control
  • 2.6.4 Modifying Membership in an Application Role
• 2.7 Managing Credentials
  • 2.7.1 Managing the Credential Store
  • 2.7.2 Managing BISystemUser Credentials
• 2.8 Customizing the Default Security Configuration
  • 2.8.1 Configuring a New Authentication Provider
  • 2.8.2 Configuring a New Policy Store and Credential Store Provider
    • 2.8.2.1 Reassociating the Policy Store and Credential Store
  • 2.8.3 Customizing the Policy Store
    • 2.8.3.1 Creating Application Roles Using Fusion Middleware Control
    • 2.8.3.2 Creating Application Policies Using Fusion Middleware Control
    • 2.8.3.3 Changing Permission Grants for an Application Policy

3 Alternative Security Options

• 3.1 About Alternative Security Options
• 3.2 Authentication and Authorization Options
• 3.3 Understanding BI Publisher's Users, Roles, and Permissions
  • 3.3.1 Options for Configuring Users and Roles
• 3.4 About Privileges to Use Functionality
• 3.5 About Catalog Permissions
• 3.6 How Functional Privileges and Permissions Work Together
  • 3.6.1 A Role Must Be Assigned Catalog Permissions
  • 3.6.2 A Role Can Be Granted Catalog Permissions Only
  • 3.6.3 Inherited Permissions
• 3.7 About Access to Data Sources
• 3.8 Configuring Users, Roles, and Data Access
  • 3.8.1 Creating Roles
  • 3.8.2 Creating Users and Assigning Roles to a User
  • 3.8.3 Granting Catalog Permissions
  • 3.8.4 Granting Data Access
• 3.9 Security and Catalog Organization
• 3.10 Configuring BI Publisher to Use an LDAP Provider for Authentication Only
• 3.11 Configuring BI Publisher to Use an LDAP Provider
  • 3.11.1 Configuring the Client Application
    • 3.11.1.1 Set Up Users and Roles
    • 3.11.1.2 Configure the BI Publisher Server to Recognize the LDAP Server
    • 3.11.1.3 Assign Data Access and Catalog Permissions to Roles
• 3.12 Integrating with Microsoft Active Directory
  • 3.12.1 Configuring the Active Directory
  • 3.12.2 Configuring BI Publisher
  • 3.12.3 Logging In to BI Publisher Using the Active Directory Credentials
  • 3.12.4 Assign Data Access and Catalog Permissions to Roles
• 3.13 Configuring Single Sign-On
• 3.14 Configuring BI Publisher to Use Oracle Access Manager (OAM) Single Sign-On
• 3.15 Setting Up Oracle Single Sign-On
  • 3.15.1 Setup Procedure

4 Other Security Topics

• 4.1 Enabling a Local Superuser
• 4.2 Enabling a Guest User
• 4.3 Configuring BI Publisher for Secure Socket Layer (SSL) Communication
  • 4.3.1 Pointing BI Publisher to the System-Wide Keystore
  • 4.3.2 Importing Certificates for Web Services Protected by SSL
  • 4.3.3 Configuring the Delivery Manager
• 4.4 Configuring Proxy Settings

5 Integrating with Other Oracle Security Models

• 5.1 About Integrating with Other Oracle Security Models
• 5.2 Before You Begin: Create a Local Superuser
• 5.3 Integrating with Oracle BI Server Security
  • 5.3.1 Configuring BI Publisher for Oracle BI Server Security
  • 5.3.2 Adding Data Sources to BI Server Roles
• 5.4 Integrating with Oracle E-Business Suite
  • 5.4.1 Features of the Integration with E-Business Suite Security
  • 5.4.2 Configuring BI Publisher to Use E-Business Suite Security
  • 5.4.3 Adding Data Sources to the E-Business Suite Roles
  • 5.4.4 Granting Catalog Permissions to the E-Business Suite Roles
• 5.5 Integrating with Oracle Database Security
  • 5.5.1 Defining the BI Publisher Functional Roles in the Oracle Database
  • 5.5.2 Adding Data Sources to Roles
  • 5.5.3 Granting Catalog Permissions to Roles
• 5.6 Integrating with Oracle Siebel CRM Security
  • 5.6.1 Setting Up BI Publisher Roles as Siebel CRM Responsibilities
  • 5.6.2 Configuring BI Publisher to Use Siebel Security
  • 5.6.3 Adding Data Sources to Roles
  • 5.6.4 Granting Catalog Permissions to Roles

6 Implementing a Digital Signature

• 6.1 Introduction
• 6.2 Prerequisites and Limitations
• 6.3 Obtaining Digital Certificates
• 6.4 Creating PFX Files
• 6.5 Implementing a Digital Signature
  • 6.5.1 Registering Your Digital Signature ID and Assigning Authorized Roles
  • 6.5.2 Specifying the Signature Display Field or Location
  • 6.5.3 Specifying a Template Field in a PDF Template for the Digital Signature
  • 6.5.4 Specifying the Location for the Digital Signature in the Report Properties
• 6.6 Running and Signing Reports with a Digital Signature

7 Configuring the Scheduler

• 7.1 Understanding the BI Publisher Scheduler
  • 7.1.1 Architecture
  • 7.1.2 About Clustering
  • 7.1.3 How Failover Works
• 7.2 Set Up Considerations
  • 7.2.1 Choosing JNDI or JDBC Connection
  • 7.2.2 Supported JMS Providers
• 7.3 About the Scheduler Configuration
  • 7.3.1 Configuring the Shared Directory
• 7.4 Configuring Processors and Processor Threads
• 7.5 Adding Managed Servers
  • 7.5.1 Adding a Managed Server
  • 7.5.2 Configure the Processors in BI Publisher
• 7.6 Scheduler Diagnostics
  • 7.6.1 Resolving Quartz Configuration Errors

8 Configuring Server Properties

• 8.1 Setting the Path to the Configuration Folder
• 8.2 Configuring the Catalog
  • 8.2.1 Configuring the Oracle BI Publisher File System Catalog
  • 8.2.2 Configuring BI Publisher to Use the Oracle BI EE Catalog
    • 8.2.2.1 Configuring the BI Search Fields
• 8.3 Setting General Properties
  • 8.3.1 The System Temporary Directory
    • 8.3.1.1 About Temporary Files
    • 8.3.1.2 Setting the System Temporary Directory
    • 8.3.1.3 Sizing the System Temporary Directory
  • 8.3.2 Setting the Report Scalable Threshold
  • 8.3.3 Setting the Database Fetch Size
• 8.4 Setting Server Caching Specifications
• 8.5 Setting Retry Properties for Database Failover
• 8.6 Enabling Monitor and Audit
• 8.7 Setting Report Viewer Properties

9 Setting Up Data Sources

• 9.1 Overview of Setting Up Data Sources
  • 9.1.1 About Other Types of Data Sources
  • 9.1.2 About Data Sources and Security
  • 9.1.3 About Proxy Authentication
  • 9.1.4 Choosing JDBC or JNDI Connection Type
  • 9.1.5 About Backup Databases
  • 9.1.6 About Pre Process Functions and Post Process Functions
• 9.2 Setting Up a JDBC Connection to the Data Source
• 9.3 Setting Up a Database Connection Using a JNDI Connection Pool
• 9.4 Setting Up a Connection to an LDAP Server Data Source
• 9.5 Setting Up a Connection to an OLAP Data Source
• 9.6 Setting Up a Connection to a File Data Source
• 9.7 Viewing or Updating a Data Source

10 Setting Up Integrations

• 10.1 Configuring Integration with Oracle BI Presentation Services

11 Setting Up Delivery Destinations

• 11.1 Configuring Delivery Options
• 11.2 Adding a Printer or Fax Server
• 11.3 Adding an E-Mail Server
• 11.4 Adding a WebDAV Server
• 11.5 Adding an HTTP Server
• 11.6 Adding an FTP Server
• 11.7 Adding a Common UNIX Printing System (CUPS) Server

12 Defining Run-Time Configurations

• 12.1 Setting Run-Time Properties
• 12.2 PDF Output Properties
• 12.3 PDF Security Properties
• 12.4 PDF Digital Signature Properties
• 12.5 PDF/A Output Properties
• 12.6 PDF/X Output Properties
• 12.7 RTF Output Properties
• 12.8 HTML Output Properties
• 12.9 FO Processing Properties
• 12.10 RTF Template Properties
• 12.11 PDF Template Properties
• 12.12 Flash Template Properties
• 12.13 CSV Output Properties
• 12.14 Excel 2007 Output Properties
• 12.15 All Outputs Property
• 12.16 Defining Font Mappings
  • 12.16.1 Making Fonts Available to BI Publisher
  • 12.16.2 Setting Font Mapping at the Site Level or Report Level
  • 12.16.3 Creating a Font Mapping
  • 12.16.4 BI Publisher's Predefined Fonts
• 12.17 Defining Currency Formats
  • 12.17.1 Understanding Currency Formats

13 Diagnostics and Performance Monitoring

• 13.1 Diagnosing and Resolving Issues in Oracle BI Publisher
• 13.2 About Diagnostic Log Files
  • 13.2.1 About Log File Message Categories and Levels
  • 13.2.2 About Log File Formats
  • 13.2.3 About Log File Rotation
• 13.3 Configuring Log Files
• 13.4 Viewing Log Messages
  • 13.4.1 Viewing Messages by Reading the Log File
• 13.5 About Performance Monitoring and User Auditing
• 13.6 Enabling Monitoring and Auditing
  • 13.6.1 Enable Monitor and Audit on the Server Configuration Page
  • 13.6.2 Configure the Audit Policy Settings
  • 13.6.3 Restart the WebLogic Server
• 13.7 Viewing the Audit Log
• 13.8 Configuring an Audit Repository
  • 13.8.1 Creating the Audit Schema Using RCU
  • 13.8.2 Creating the Data Source in WebLogic Server
  • 13.8.3 Registering the Audit Storage Database to Your Domain
• 13.9 Using BI Publisher to Create Audit Reports
  • 13.9.1 Registering the Data Source in BI Publisher
  • 13.9.2 Creating a Data Model
  • 13.9.3 Creating the Report
• 13.10 Viewing Performance Statistics in the MBean Browser

14 Adding Translations for the BI Publisher Catalog and Reports

• 14.1 Introduction
  • 14.1.1 Limitations of Catalog Translation
• 14.2 Exporting and Importing a Catalog Translation File
• 14.3 Template Translation
  • 14.3.1 Generating the XLIFF File from the Layout Properties Page
  • 14.3.2 Translating the XLIFF File
  • 14.3.3 Uploading the Translated XLIFF File to BI Publisher
• 14.4 Using the Localized Template Option
  • 14.4.1 Designing the Localized Template File
  • 14.4.2 Uploading the Localized Template to BI Publisher

15 Moving Catalog Objects Between Environments

• 15.1 Overview
  • 15.1.1 When to Use the Catalog Utility
  • 15.1.2 Other Options for Moving Catalog Objects
  • 15.1.3 What Files Are Moved
• 15.2 Preparing to Use the BI Publisher Catalog Utility
  • 15.2.1 Configuring the Environment
• 15.3 Exporting BI Publisher Reporting Objects
  • 15.3.1 Example Export Command Lines
    • 15.3.1.1 Exporting a Single Report in Archive Format
    • 15.3.1.2 Exporting a Single Report with Files Extracted
    • 15.3.1.3 Exporting a Set of Reports to a Specified Folder
• 15.4 Importing BI Publisher Reporting Objects
  • 15.4.1 Example Import Command Lines
    • 15.4.1.1 Importing a Report to an Original Location
    • 15.4.1.2 Importing a Report to a New Location
    • 15.4.1.3 Importing a Zipped Report
    • 15.4.1.4 Importing a set of BI Publisher Reporting Objects Under a Specified Folder
• 15.5 Generating Translation Files and Checking for Translatability
  • 15.5.1 Generating a Translation File for a Report Definition File (.xdo)
  • 15.5.2 Generating a Translation File for an RTF Template

A Setting Up Print Servers

• A.1 Setting Up CUPS on Linux
  • A.1.1 Prerequisites
  • A.1.2 Setting Up a Printer on CUPS
  • A.1.3 Installing and Setting Up Fax for CUPS
  • A.1.4 Making CUPS Accessible from Other Machines
• A.2 Setting Up Internet Printing Protocol (IPP) on Windows
  • A.2.1 Setting Up IPP Printers on Windows XP Professional

B Scheduler Configuration Reference

• B.1 Introduction
• B.2 Configuring BI Publisher for ActiveMQ
  • B.2.1 Install ActiveMQ
  • B.2.2 Register ActiveMQ as a JNDI Service
  • B.2.3 Update the BI Publisher Scheduler Configuration Page
• B.3 Manually Configuring the Quartz Scheduler
  • B.3.1 Recommendations for Using DataDirect Connect or Native Database Drivers
  • B.3.2 Set Up a User on Your Scheduler Database
  • B.3.3 Connecting to Your Scheduler Database and Installing the Schema
  • B.3.4 Connecting to Oracle Database
  • B.3.5 Connecting to IBM DB2
  • B.3.6 Connecting to Microsoft SQL Server
  • B.3.7 Connecting to Sybase Adaptive Server Enterprise Database

C Integration Reference for Oracle BI Enterprise Edition

• C.1 About Integration
  • C.1.1 Prerequisites
• C.2 Configuring BI Publisher to Use the Oracle BI Presentation Catalog
• C.3 Configuring Integration with Oracle BI Presentation Services
• C.4 Setting Up a JDBC Connection to the Oracle BI Server

D Configuration File Reference

• D.1 BI Publisher Configuration Files
• D.2 Setting Properties in the Runtime Configuration File
  • D.2.1 File Name and Location
  • D.2.2 Namespace
  • D.2.3 Configuration File Example
  • D.2.4 Understanding the Element Specifications
• D.3 Structure of the Root Element
  • D.3.1 Attributes of Root Element
  • D.3.2 Description of Root Element
• D.4 Properties and Property Elements
  • D.4.1 <properties> Element
    • D.4.1.1 Description of <properties> Element
  • D.4.2 <property> Element
    • D.4.2.1 Attribute of <property> Element
    • D.4.2.2 Description of <property> Element
• D.5 Font Definitions
  • D.5.1 <fonts> Element
    • D.5.1.1 Attribute of <fonts> Element
    • D.5.1.2 Description of <fonts> Element
  • D.5.2 <font> Element
    • D.5.2.1 Attributes of <font> Element
    • D.5.2.2 Description of <font> Element
  • D.5.3 <font-substitute> Element
    • D.5.3.1 Attributes of <font-substitute> Element
    • D.5.3.2 Description of <font-substitute> Element
  • D.5.4 <type1> element
    • D.5.4.1 Attribute of <type1> Element
    • D.5.4.2 Description of <type1> Element
• D.6 Predefined Fonts
  • D.6.1 Included Barcode Fonts

Index