Skip Headers
Oracle® Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher (Oracle Fusion Applications Edition)
11g Release 1 (11.1.1)

Part Number E26386-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

New Features for Data Model Designers

This preface describes changes to Oracle BI Publisher data modeling features for Oracle Business Intelligence Publisher 11g Release 1 (11.1.1).

This preface contains the following topics:

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

New features for report data model developers in Oracle BI Publisher 11g Release 1 (11.1.1.6) include:

Schedule Triggers for Event-Driven Schedules

The execution of a scheduled report job can now be conditionalized based on an event. A report data model supports a new type of trigger called a Schedule Trigger. The schedule trigger that you create in the data model can then be enabled in the report job schedule. When the report job is scheduled to run, the trigger is executed. If no data is returned from the trigger, the job instance is skipped. If data is returned, the job instance runs as scheduled. See Section 5.3, "Creating Schedule Triggers" for more information.

Enhancements to Parameter Display Options

Enhancements to parameter display options include:

Support for HTML Formatting in Data

You can now convert stored XHTML to XSL-FO to display the HTML formatting from your data in your generated report. The XHTML data must be extracted wrapped in a CDATA section. Specific syntax must also be used in the RTF template to render it. See Section 2.12.2, "Handling XHTML Data Stored in a CLOB Column" for more information.

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

New features in Oracle BI Publisher 11g Release 1 (11.1.1.5) include:

Support for CLOB as XML

The data engine can now extract well-formed XML data stored in a database column as a character large object (CLOB) data type and maintain its structure. This feature enables you to use XML data generated by a separate process and stored in your database as input to a BI Publisher data model. For more information, see Section 2.12, "Using Data Stored as a Character Large Object (CLOB) in a Data Model."

Upload Local Microsoft Excel File as Data Source

You can now upload a locally stored Excel file directly to a data model definition. This file can then be refreshed on demand from the data model definition. For more information, see Section 2.7, "Creating a Data Set Using a Microsoft Excel File."

Use LDAP Attributes as Bind Variables in Data Queries

LDAP attributes defined in the LDAP Security Model definition can be used as bind variables in data queries. For more information, see Section 2.15.2.1, "Creating Bind Variables from LDAP User Attribute Values."

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

New features in Oracle BI Publisher 11g Release 1 (11.1.1.3) include:

Major User Interface Improvements

The user interface has undergone major improvements in several areas, including a new Home page and redesigned editors and panes. These improvements are intended to make working with Oracle BI Publisher easier and more consistent. For information about working in the new interface, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Publisher.

Shared BI Presentation Catalog

For installations of BI Publisher with the Oracle BI Enterprise Edition, BI Publisher now shares the same catalog with Oracle BI Presentation services. For information about the improved catalog, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Publisher.

Data Model Editor

This release introduces the data model editor to create your report data models. The data model editor enables you to combine data from multiple data sets from different data sources, such as SQL, Excel files, Web services, HTTP feeds, and other applications into a single XML data structure. Data sets can either be unrelated or a relationship can be established between them using a data link. This guide describes in detail how to use the data model editor.

Data Model as a Sharable Object

The data model is saved as a distinct catalog object. This means that a single data model can now be used for multiple reports.

Support for Microsoft Excel File as a Data Source

A Microsoft Excel file can now be used to create a data set in a BI Publisher data model. For more information, see Section 2.7, "Creating a Data Set Using a Microsoft Excel File."

Support for View Object as a Data Source

BI Publisher enables you to connect to your custom applications built with Oracle Application Development Framework and use view objects in your applications as data sources for reports. For more information, see Section 2.9, "Creating a Data Set Using a View Object."