Skip Headers
Oracle® Business Intelligence New Features Guide
Release 10.1.3.3.3
Part No. E10416-04
Library
Product
Next
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
1.1
Configuration for the Oracle BI Answers-Based Metadata Dictionary Feature
2
Multi-Select Dashboard Prompts Feature
2.1
Configuration for the Multi-Select Dashboard Prompts Feature
3
Office Integration with BI Dashboard Feature
3.1
Configuration for the Office Integration with BI Dashboard Feature
4
Dashboard Link Types Feature
4.1
Using Bookmark Links
4.2
Using Prompted Links
4.3
Configuration for the Dashboard Prompt Types Feature
5
Import Oracle Catalog Feature
6
Embedded Database Functions Feature
6.1
EVALUATE Function
6.2
EVALUATE_AGGR Function
6.3
EVALUATE_PREDICATE Function
7
Drag and Drop XMLA Metadata Objects Feature
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
Part II New Features for Oracle BI Publisher
11
Oracle BI Publisher Template Builder Enhancements
11.1
Changes to the Oracle BI Publisher Menu
11.2
Integration with Oracle BI Discoverer
11.3
Microsoft PowerPoint Output Support
11.4
Advanced Form Field Support
11.4.1
Edit Data Fields
11.4.2
Advanced Tab
11.4.3
Insert and Edit Repeating Groups
11.4.3.1
Creating Repeating Groups
11.4.3.2
Create Grouping Fields Around a Block
11.4.4
Insert Conditional Formatting
11.4.5
Inserting and Editing Conditional Regions
11.5
Chart Builder Enhancements
11.5.1
Support for Charts Inside a Grouping
11.5.2
New Chart Types
11.5.3
New Chart Subtypes
12
Flash Templates for Oracle BI Publisher
12.1
Changes to the BI Publisher User Interface
12.2
Prerequisites
12.3
Building Templates
12.3.1
Adding the Data Source
12.3.2
Creating the Layout
12.3.2.1
Adding a Chart
12.3.3
Data Binding
12.3.3.1
Binding the DataGrid
12.3.3.2
Binding the Chart
12.4
Loading Templates
12.5
Setting Properties for PDF Output
12.6
Summary
13
Oracle BI Publisher PowerPoint Output
13.1
Supported Versions of PowerPoint
13.2
Configuring Fonts for BI Publisher Server
13.3
Configuring Fonts for BI Publisher Template Builder
13.4
Usage and Limitations
14
Oracle BI Publisher Integration with Oracle BI Discoverer
14.1
Configuring the Oracle BI Publisher and Discoverer Integration
14.1.1
Step 1: Install the Discoverer Web Service
14.1.2
Step 2: Install Oracle BI Publisher 10.1.3
14.1.3
Step 3: Configure Discoverer to Use Oracle Application Server Identity Management
14.1.4
Step 4: Set Up a Dedicated User to Access the Discoverer Web Service from Oracle BI Publisher
14.1.5
Step 5: Configure Oracle BI Publisher to Use the Discoverer Web Service
14.1.6
Discoverer Web Service Configuration Settings
14.2
Creating Reports Based on Discoverer Worksheets
14.2.1
About Creating a Report Based on a Discoverer Worksheet
14.2.2
Creating a Report Directly Through the Oracle BI Publisher Web Interface
14.2.3
Creating a Report Indirectly Through Oracle BI Publisher Template Builder
14.2.3.1
About Creating Layout Templates
14.2.3.2
Creating a Layout Template Offline
14.2.3.3
Creating a Layout Template Online
14.2.3.4
Viewing and Scheduling Reports
14.2.4
Prerequisites, Limitations, and Known Issues
14.2.4.1
Prerequisites
14.2.4.2
Limitations
14.2.4.3
Known Issues
15
Performance Improvements for Oracle BI Publisher
15.1
Multithreading for Bursting
15.2
Multithreading for Document Generation
16
Converting Reports from Oracle Reports to Oracle BI Publisher
16.1
Overview
16.2
Prerequisites
16.2.1
Reports and Oracle Reports XML Format
16.2.2
Update CLASSPATH with Needed JAR Files
16.2.3
JDK Version 1.1.8
16.3
Conversion Utility
16.3.1
Output Files
16.4
Upload PL/SQL Package to the Database
16.5
Putting Converted Reports into the Oracle BI Publisher Repository
16.6
Testing and Tweaking Your Reports
16.6.1
Data Template and PL/SQL Files
16.6.2
RTF Layout Template File
17
Support for Digital Signature in PDF Documents
17.1
Introduction
17.2
Prerequisites
17.3
Limitations
17.4
Integration With Oracle BI Publisher
17.4.1
Digital Signature ID Registration And Allowed Role Assignment
17.4.2
Specify the Signature Display Field or Location
17.4.2.1
Designating a Field in a PDF Template for the Digital Signature
17.4.2.2
Specifying a Location in the Document to Insert the Digital Signature (for RTF and PDF Templates)
17.4.3
Running and Signing Reports with the Digital Signature
17.4.4
Additional PDF Security Features
18
Support for Postscript Printers
18.1
Introduction
18.2
Setting Up Your Print Server to Use the Converter
18.3
Limitations
19
Additional New Features in Release 10.1.3.3
19.1
Support for CSV Output
19.2
Report Definition Features
19.3
Report Viewing Features
19.4
New Property for LDAP Security Model
20
New Features in Release 10.1.3.3.1
20.1
Time Out Value for Web Service Data Sources
20.2
Bidirectional Function for eText Data Fields
20.3
Default Repository
21
New Features in Release 10.1.3.3.2
21.1
Support for Document Cache
21.2
Support for New Output Types
22
New Features in Release 10.1.3.3.3
22.1
BI Publisher Scheduler Setup Updates Including the Bundling of DataDirect Connect for JDBC Drivers
22.1.1
Recommendations for Using DataDirect Connect or Native Database Drivers
22.1.2
Setting Up Connection to Your Scheduler Database Using the DataDirect Connect for JDBC Drivers
22.1.2.1
Entering Connection Information for IBM DB2
22.1.2.2
Entering Connection Information for Microsoft SQL Server
22.1.2.3
Entering Connection Information for Oracle
22.1.2.4
Entering Connection Information for MySQL
22.1.3
Setting the BLOB Column Size
22.2
"Link to This Report" Can Now Be Set as a Report Option
22.3
Enhanced Support for Pagination Control in RTF Output
22.3.1
Support for "Keep Paragraph with the Next Paragraph"
22.3.2
Keep Paragraph Intact
22.3.3
Support for Table "Heading Rows Repeat"
22.3.4
Support for "Table Row Keep Together"
22.4
Support for Multiple Cascading Parameters
22.5
Support for Vertical Alignment of External Graphics
22.6
Support for Multiple Currency Symbol Displays in Report
22.6.1
Sample Usage
23
Oracle Business Intelligence Publisher Web Services
23.1
Overview of the Oracle BI Publisher Web Services
23.1.1
Functionality Overview
23.1.2
WSDL Definition for PublicReportService
23.2
Oracle BI Publisher Web Services Data Types
23.2.1
Base Data Types
23.2.2
XML-to-Java Data Type Mappings
23.2.3
Complex Types
23.3
Oracle BI Publisher Web Services Operations
23.3.1
About Using the Code Samples
23.3.2
Operations for Validation of Privileges
23.3.3
Operations to Get Information About Reports and the Repository
23.3.4
Operations to Run and Schedule Reports
23.3.5
Messages for Errors
23.4
Debugging Web Service Applications
23.5
Oracle BI Publisher Web Services WSDL
Part III New Features for Oracle Business Intelligence for Microsoft Office
24
Installing Oracle Business Intelligence for Microsoft Office
24.1
System Requirements
24.1.1
Supported Client Operating Systems
24.1.2
Supported Versions of Microsoft Office
24.1.3
Supported Application Servers
24.2
Installing the BI Office Server
24.2.1
Deployment of the bioffice.ear
24.2.2
Initialization of the BI Office Configuration File
24.2.3
Placement of the Client OracleBIOffice.exe File
24.3
Deploying the BI Office Server on J2EE Application Servers
24.4
Installing the BI Office Client
24.4.1
Performing a Maintenance or Upgrade Install
24.4.2
Configuring the Client
24.5
Setting Properties in the bioffice.xml Configuration File
24.6
Setting Up SSL-Enabled OC4J for BI Office
24.7
Setting Up an SSO-Enabled Oracle BI Presentation Server for BI Office
25
Microsoft Office Support
26
New Features in Release 10.1.3.3.1
26.1
Configure the BI Office Connection URL
26.2
Language Support
27
New Features in Release 10.1.3.3.3