Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I General New Features

1 Oracle BI Answers-Based Metadata Dictionary Feature in Release 10.1.3.3

• 1.1 Overview of Accessing the Metadata Dictionary from Oracle BI Answers
• 1.2 Configuration for the Oracle BI Answers-Based Metadata Dictionary Feature

2 Multi-Select Dashboard Prompts Feature in Release 10.1.3.3

• 2.1 Overview of Multi-Select Dashboard Prompts
• 2.2 Configuration for the Multi-Select Dashboard Prompts Feature

3 Office Integration with BI Dashboard Feature in Release 10.1.3.3

• 3.1 Overview of Intergration with Dashboards
• 3.2 Configuration for the Office Integration with BI Dashboard Feature

4 Dashboard Link Types Feature in Release 10.1.3.3

• 4.1 Using Bookmark Links
• 4.2 Using Prompted Links
• 4.3 Configuration for the Dashboard Prompt Types Feature

5 Import Oracle Catalog Feature in Release 10.1.3.3

6 Embedded Database Functions Feature in Release 10.1.3.3

• 6.1 EVALUATE Function
• 6.2 EVALUATE_AGGR Function
• 6.3 EVALUATE_PREDICATE Function

7 Drag and Drop XMLA Metadata Objects Feature in Release 10.1.3.3

8 General New Features in Release 10.1.3.3.1

• 8.1 Oracle Business Intelligence Installer Now Deploys BI Components into One OC4J Container
  • 8.1.1 Upgrading to Version 10.1.3.3.1 from a BIEE 10.1.3.x Release Prior to 10.1.3.3.1
• 8.2 DataDirect Connect ODBC Drivers for Linux and UNIX Operating Systems Bundled with Oracle BI EE 10.1.3.3.1
  • 8.2.1 Using the DataDirect Connect ODBC Drivers
    • 8.2.1.1 For connectivity to Microsoft SQL Server database
    • 8.2.1.2 For connectivity to Sybase ASE Database
    • 8.2.1.3 For connectivity to Informix Database
• 8.3 Support for Charts in Oracle BI EE for Arabic, Thai, and Hebrew
  • 8.3.1 Prerequisites
  • 8.3.2 Integrate the Data Sources
    • 8.3.2.1 Adding the Oracle BI Server as a Data Source
    • 8.3.2.2 Integrating with Oracle Presentation Services
  • 8.3.3 Create a Report and Layout in BI Publisher
  • 8.3.4 Embed the BI Publisher Report in a Dashboard
  • 8.3.5 Supported Graph Types
  • 8.3.6 Known Limitations

9 General New Features in Release 10.1.3.3.2

• 9.1 Support for Hyperion Essbase as a Data Source
  • 9.1.1 Supported Versions of Hyperion Essbase with Oracle BI EE 10.1.3.3.2
  • 9.1.2 Enabling the Use of Hyperion Essbase as a Data Source
    • 9.1.2.1 Essbase Client Libraries
    • 9.1.2.2 BI Server Configuration for UNIX and Linux Platforms
    • 9.1.2.3 Import Process
  • 9.1.3 Guidelines and Limitations
    • 9.1.3.1 Measures
    • 9.1.3.2 Unique Member Names
    • 9.1.3.3 Time Series Functions
    • 9.1.3.4 Evaluate Function for MDX Sources
    • 9.1.3.5 User-Defined Attributes
    • 9.1.3.6 Substitution Variables
    • 9.1.3.7 Attribute Dimensions
    • 9.1.3.8 Unbalanced Hierarchies
• 9.2 Using BI EE OC4J Components with IIS via the IIS Plug-in
  • 9.2.1 Prerequisites
  • 9.2.2 Configuration Steps

10 General New Features in Release 10.1.3.3.3

11 General New Features in Release 10.1.3.4

• 11.1 Overview of New Features
• 11.2 Migration of Oracle BI Discoverer Metadata
• 11.3 New Line Chart for Time Series Data
• 11.4 New Sample Oracle BI Application and Data Set
  • 11.4.1 OBI EE Web Dashboard Samples
  • 11.4.2 OBI EE RPD Constructs Samples
• 11.5 Integration with Oracle Enterprise Performance Management Workspace, Fusion Edition
  • 11.5.1 Overview of the Integration
  • 11.5.2 Documentation for the Integration
    • 11.5.2.1 Installation Documentation for the Integration
    • 11.5.2.2 Integration of Oracle BI Answers, Interactive Dashboards, and Delivers, with EPM Workspace
    • 11.5.2.3 Integration of Oracle BI Publisher with EPM Workspace
  • 11.5.3 Installing and Configuring Oracle BI Presentation Services with EPM Workspace
    • 11.5.3.1 Registering the Oracle BI Presentation Services Components with the Hyperion Registry
    • 11.5.3.2 Specifying the External Login for Single Sign-On with EPM Workspace
    • 11.5.3.3 Configuring Javahost to Enable the Hyperion Common Security System Authenticator
    • 11.5.3.4 Specifying the Hyperion_Home Environment Variable
    • 11.5.3.5 Configuring the Repository to Use a Custom Authenticator
    • 11.5.3.6 Configuring the Web Server for EPM Workspace
    • 11.5.3.7 Verifying the Web Server Configuration
    • 11.5.3.8 Provisioning Hyperion Shared Services Users in Oracle BI Presentation Services
  • 11.5.4 Using Oracle BI Presentation Services Components in EPM Workspace, Fusion Edition
    • 11.5.4.1 Specifying Oracle BI Preferences Within EPM Workspace
    • 11.5.4.2 Performing Oracle BI Presentation Services Administration Tasks Within EPM Workspace
    • 11.5.4.3 Launching Oracle BI Presentation Services Components in EPM Workspace
    • 11.5.4.4 Using BI Answers
    • 11.5.4.5 Using BI Interactive Dashboards
    • 11.5.4.6 Using BI Delivers
• 11.6 Integration with Oracle Smart Space, Fusion Edition
  • 11.6.1 Overview of the Integration
  • 11.6.2 Documentation for the Integration
    • 11.6.2.1 Installation Documentation for the Integration
    • 11.6.2.2 Integration of Oracle BI Answers, Interactive Dashboards, and Delivers with Oracle Smart Space
    • 11.6.2.3 Integration of Oracle BI Publisher with Oracle Smart Space
  • 11.6.3 Performing Oracle BI Tasks in Smart Space
    • 11.6.3.1 Tasks from Right-Click Menus
    • 11.6.3.2 Folder Management
    • 11.6.3.3 Oracle BI Delivers iBots
    • 11.6.3.4 Authentication
  • 11.6.4 Downloading Oracle Smart Space and Smart View from Oracle BI Presentation Services
    • 11.6.4.1 Setting Up to Download Oracle Smart Space and Smart View from Oracle BI Presentation Services
    • 11.6.4.2 Initiating the Download
• 11.7 Certification of Oracle WebLogic Server 10.x
  • 11.7.1 Configuring Oracle BI EE for WebLogic Server
  • 11.7.2 Configuring Oracle BI Publisher for WebLogic Server

12 General New Features in Release 10.1.3.4.1

Part II New Features for Oracle BI Publisher

13 Oracle BI Publisher Template Builder Enhancements in Release 10.1.3.3

• 13.1 Changes to the Oracle BI Publisher Menu
• 13.2 Integration with Oracle BI Discoverer
• 13.3 Microsoft PowerPoint Output Support
• 13.4 Advanced Form Field Support
  • 13.4.1 Edit Data Fields
  • 13.4.2 Advanced Tab
  • 13.4.3 Insert and Edit Repeating Groups
    • 13.4.3.1 Creating Repeating Groups
    • 13.4.3.2 Create Grouping Fields Around a Block
  • 13.4.4 Insert Conditional Formatting
  • 13.4.5 Inserting and Editing Conditional Regions
• 13.5 Chart Builder Enhancements
  • 13.5.1 Support for Charts Inside a Grouping
  • 13.5.2 New Chart Types
  • 13.5.3 New Chart Subtypes

14 Flash Templates for Oracle BI Publisher in Release 10.1.3.3

• 14.1 Changes to the BI Publisher User Interface
• 14.2 Prerequisites
• 14.3 Building Templates
  • 14.3.1 Adding the Data Source
  • 14.3.2 Creating the Layout
    • 14.3.2.1 Adding a Chart
  • 14.3.3 Data Binding
    • 14.3.3.1 Binding the DataGrid
    • 14.3.3.2 Binding the Chart
• 14.4 Loading Templates
• 14.5 Setting Properties for PDF Output
• 14.6 Summary

15 Oracle BI Publisher PowerPoint Output in Release 10.1.3.3

• 15.1 Supported Versions of PowerPoint
• 15.2 Configuring Fonts for BI Publisher Server
• 15.3 Configuring Fonts for BI Publisher Template Builder
• 15.4 Usage and Limitations

16 Oracle BI Publisher Integration with Oracle BI Discoverer in Release 10.1.3.3

• 16.1 Configuring the Oracle BI Publisher and Discoverer Integration
  • 16.1.1 Step 1: Install the Discoverer Web Service
  • 16.1.2 Step 2: Install Oracle BI Publisher 10.1.3
  • 16.1.3 Step 3: Configure Discoverer to Use Oracle Application Server Identity Management
  • 16.1.4 Step 4: Set Up a Dedicated User to Access the Discoverer Web Service from Oracle BI Publisher
  • 16.1.5 Step 5: Configure Oracle BI Publisher to Use the Discoverer Web Service
  • 16.1.6 Discoverer Web Service Configuration Settings
• 16.2 Creating Reports Based on Discoverer Worksheets
  • 16.2.1 About Creating a Report Based on a Discoverer Worksheet
  • 16.2.2 Creating a Report Directly Through the Oracle BI Publisher Web Interface
  • 16.2.3 Creating a Report Indirectly Through Oracle BI Publisher Template Builder
    • 16.2.3.1 About Creating Layout Templates
    • 16.2.3.2 Creating a Layout Template Offline
    • 16.2.3.3 Creating a Layout Template Online
    • 16.2.3.4 Viewing and Scheduling Reports
  • 16.2.4 Prerequisites, Limitations, and Known Issues
    • 16.2.4.1 Prerequisites
    • 16.2.4.2 Limitations
    • 16.2.4.3 Known Issues

17 Performance Improvements for Oracle BI Publisher in Release 10.1.3.3

• 17.1 Multithreading for Bursting
• 17.2 Multithreading for Document Generation

18 Converting Reports from Oracle Reports to Oracle BI Publisher in Release 10.1.3.3

• 18.1 Overview
• 18.2 Prerequisites
  • 18.2.1 Reports and Oracle Reports XML Format
  • 18.2.2 Update CLASSPATH with Needed JAR Files
  • 18.2.3 JDK Version 1.1.8
• 18.3 Conversion Utility
  • 18.3.1 Output Files
• 18.4 Upload PL/SQL Package to the Database
• 18.5 Putting Converted Reports into the Oracle BI Publisher Repository
• 18.6 Testing and Tweaking Your Reports
  • 18.6.1 Data Template and PL/SQL Files
  • 18.6.2 RTF Layout Template File

19 Support for Digital Signature in PDF Documents in Release 10.1.3.3

• 19.1 Introduction
• 19.2 Prerequisites
• 19.3 Limitations
• 19.4 Integration With Oracle BI Publisher
  • 19.4.1 Digital Signature ID Registration And Allowed Role Assignment
  • 19.4.2 Specify the Signature Display Field or Location
    • 19.4.2.1 Designating a Field in a PDF Template for the Digital Signature
    • 19.4.2.2 Specifying a Location in the Document to Insert the Digital Signature (for RTF and PDF Templates)
  • 19.4.3 Running and Signing Reports with the Digital Signature
  • 19.4.4 Additional PDF Security Features

20 Support for PostScript Printers in Release 10.1.3.3

• 20.1 Introduction
• 20.2 Setting Up the Print Server to Use the Converter
• 20.3 Limitations

21 Additional New Features in BI Publisher Release 10.1.3.3

• 21.1 Support for CSV Output
• 21.2 Report Definition Features
• 21.3 Report Viewing Features
• 21.4 New Property for LDAP Security Model

22 New Features in BI Publisher Release 10.1.3.3.1

• 22.1 Time Out Value for Web Service Data Sources
• 22.2 Bidirectional Function for eText Data Fields
• 22.3 Default Repository

23 New Features in BI Publisher Release 10.1.3.3.2

• 23.1 Support for Document Cache
• 23.2 Support for New Output Types

24 New Features in BI Publisher Release 10.1.3.3.3

• 24.1 BI Publisher Scheduler Setup Updates Including the Bundling of DataDirect Connect for JDBC Drivers
  • 24.1.1 Recommendations for Using DataDirect Connect or Native Database Drivers
  • 24.1.2 Setting Up Connection to Your Scheduler Database Using the DataDirect Connect for JDBC Drivers
    • 24.1.2.1 Entering Connection Information for IBM DB2
    • 24.1.2.2 Entering Connection Information for Microsoft SQL Server
    • 24.1.2.3 Entering Connection Information for Oracle
    • 24.1.2.4 Entering Connection Information for MySQL
  • 24.1.3 Setting the BLOB Column Size
• 24.2 "Link to This Report" Can Now Be Set as a Report Option
• 24.3 Enhanced Support for Pagination Control in RTF Output
  • 24.3.1 Support for "Keep Paragraph with the Next Paragraph"
  • 24.3.2 Keep Paragraph Intact
  • 24.3.3 Support for Table "Heading Rows Repeat"
  • 24.3.4 Support for "Table Row Keep Together"
• 24.4 Support for Multiple Cascading Parameters
• 24.5 Support for Vertical Alignment of External Graphics
• 24.6 Support for Multiple Currency Symbol Displays in Report
  • 24.6.1 Sample Usage

25 New Features in BI Publisher Release 10.1.3.4

• 25.1 Integration with Oracle Enterprise Performance Management Workspace
• 25.2 Integration with Oracle Smart Space
• 25.3 Support for Multidimensional Data Sources
• 25.4 Enhancements to the BI Publisher Web Service
• 25.5 Support for "After Report" Triggers
• 25.6 Support for Complex Web Services as a Data Source
• 25.7 New Report Property "Disable Client Access from Analyzer for Excel"
• 25.8 Enhancements to the Template Builder for Microsoft Word Add-in

26 New Features in BI Publisher Release 10.1.3.4.1

27 Oracle Business Intelligence Publisher Web Services

• 27.1 Overview of the Oracle BI Publisher Web Services
  • 27.1.1 Functionality Overview
  • 27.1.2 WSDL Definition for PublicReportService
• 27.2 Oracle BI Publisher Web Services Data Types
  • 27.2.1 Base Data Types
  • 27.2.2 XML-to-Java Data Type Mappings
  • 27.2.3 Complex Types
• 27.3 Oracle BI Publisher Web Services Operations
  • 27.3.1 About Using the Code Samples
  • 27.3.2 Operations for Validation of Privileges
  • 27.3.3 Operations to Get Information About Reports and the Repository
  • 27.3.4 Operations to Run and Schedule Reports
  • 27.3.5 Messages for Errors
• 27.4 Debugging Web Service Applications
• 27.5 Oracle BI Publisher Web Services WSDL

Part III New Features for Oracle Business Intelligence for Microsoft Office

28 Installing Oracle Business Intelligence for Microsoft Office in Release 10.1.3.3

• 28.1 System Requirements
  • 28.1.1 Supported Client Operating Systems
  • 28.1.2 Supported Versions of Microsoft Office
  • 28.1.3 Supported Application Servers
• 28.2 Installing the BI Office Server
  • 28.2.1 Deployment of the bioffice.ear
  • 28.2.2 Initialization of the BI Office Configuration File
  • 28.2.3 Location of the Installed Client OracleBIOffice.exe File
• 28.3 Deploying the BI Office Server on J2EE Application Servers
• 28.4 Installing the BI Office Client
  • 28.4.1 Performing a Maintenance or Upgrade Install
  • 28.4.2 Configuring the Client
• 28.5 Setting Properties in the bioffice.xml Configuration File
• 28.6 Setting Up SSL-Enabled OC4J for BI Office
• 28.7 Setting Up an SSO-Enabled Oracle BI Presentation Server for BI Office for Releases Prior to 10.1.3.4
• 28.8 Setting Up an SSO-Enabled Oracle BI Presentation Server for BI Office for Releases 10.1.3.4 and Later
  • 28.8.1 Prerequisites
  • 28.8.2 Integrating BI Office with SSO-Enabled Oracle BI
  • 28.8.3 Alternative Configuration Method
• 28.9 Setting Up an NTLM-Enabled Oracle BI Presentation Server for BI Office for Releases 10.1.3.4 and Later
  • 28.9.1 Example of Deploying and Configuring BI Office with NTLM Authentication
  • 28.9.2 Prerequisite Tasks
    • 28.9.2.1 Configure Oracle Business Intelligence to enable single sign-on
    • 28.9.2.2 Optionally Install and Configure Active Directory or Another Third-Party LDAP Server
    • 28.9.2.3 Create a Second BI Presentation Services Servlet to Bypass Authentication
  • 28.9.3 Installing the NTLM Module
  • 28.9.4 Configuring BI Office to Enable NTML
  • 28.9.5 Testing Your NTLM Deployment

29 Microsoft Office Support in Release 10.1.3.3

30 New Features in BI Office Release 10.1.3.3.1

• 30.1 Configure the BI Office Connection URL
• 30.2 Language Support

31 New Features in BI Office Release 10.1.3.3.3

32 New Features in BI Office Release 10.1.3.4

• 32.1 Server Independence
• 32.2 BI Office Client Changes
  • 32.2.1 Ability to Enable Logging
  • 32.2.2 Enhanced BI Catalog Task Pane
  • 32.2.3 Ability to Preserve Excel Conditional Formatting During Refreshes
  • 32.2.4 Support for Gauge View
  • 32.2.5 Support for Funnel View
  • 32.2.6 Edit Prompts and Levels After Insert
  • 32.2.7 Enhanced Prompts Selection UI
  • 32.2.8 Support for Grand Totals in Table Views
• 32.3 Support for Combined Request Views
• 32.4 Transparent Compression of Results
• 32.5 NTLM Support

33 New Features in BI Office Release 10.1.3.4.1