|Oracle® Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher
11g Release 1 (11.1.1)
Part Number E22258-02
|PDF · Mobi · ePub|
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 report data model developers in Oracle BI Publisher 11g Release 1 (18.104.22.168) include:
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 include:
Support for radio button and check box display of values
Parameters that are defined as a menu in the data model can now be configured to display the menu options as a list of radio buttons or check boxes. Parameters configured to support one value support the option to display as radio buttons. Parameters configured to support multiple values support the option to display as check boxes.
New options for placement of parameters in the report viewer
Previously the report viewer always displayed the parameters in a horizontal region across the top of the viewer. In this release. the display of the parameter region can also be configured in one of the following ways:
In a vertical region along the right side of the viewer
As a dialog
As a separate full page
New report viewer toolbar button to show or hide parameters
This release adds a toolbar button to the report viewer to enable users to hide or show the parameter region. This enhancement complements the new parameter display options. When report parameters are configured to display as a dialog or in a separate full page, the parameter display region is dismissed when the viewer displays the report. Use the Parameters button to redisplay the parameter region to make new selections.
Search added to menus
All parameter menus having more than a specified number of options provide a Search option.
Option to remove the Apply button
Reports can now be configured to remove the parameter Apply button. In these reports the action of selecting a new parameter value automatically reruns the report.
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 in Oracle BI Publisher 11g Release 1 (22.214.171.124) include:
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."
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."
LDAP attributes defined in the LDAP Security Model definition can be used as bind variables in data queries. For more information, see Section 126.96.36.199, "Creating Bind Variables from LDAP User Attribute Values."
New features in Oracle BI Publisher 11g Release 1 (188.8.131.52) include:
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.
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.
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.
The data model is saved as a distinct catalog object. This means that a single data model can now be used for multiple reports.
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."
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."