1/12
Contents
Title and Copyright Information
Preface
Intended Audience
Documentation Accessibility
Related Documentation and Other Resources
Conventions
New Features for Data Model Designers
New Features for Oracle BI Publisher 11
g
Release 1 (11.1.1.6)
New Features for Oracle BI Publisher 11
g
Release 1 (11.1.1.5)
New Features for Oracle BI Publisher 11
g
Release 1 (11.1.1.3)
1
Using the Data Model Editor
1.1
What Is a Data Model?
1.2
Components of a Data Model
1.3
Features of the Data Model Editor
1.4
About the Data Source Options
1.5
Process Overview for Creating a Data Model
1.6
Launching the Data Model Editor
1.7
About the Data Model Editor Interface
1.8
Setting Data Model Properties
1.8.1
XML Output Options
1.8.2
Attachments to the Data Model
1.8.2.1
Attaching Sample Data
1.8.2.2
Attaching Schema
1.8.2.3
Data Files
2
Creating Data Sets
2.1
Overview of Creating Data Sets
2.2
Editing an Existing Data Set
2.3
Creating a Data Set Using a SQL Query
2.4
Using the Query Builder
2.4.1
Understanding the Query Builder Process
2.4.2
Using the Object Selection Pane
2.4.3
Selecting a Schema
2.4.4
Searching and Filtering Objects
2.4.5
Selecting Objects
2.4.6
Supported Column Types
2.4.7
Adding Objects to the Design Pane
2.4.8
Resizing the Design and Results Pane
2.4.9
Removing or Hiding Objects in the Design Pane
2.4.10
Specifying Query Conditions
2.4.11
Creating Relationships Between Objects
2.4.11.1
About Join Conditions
2.4.11.2
Joining Objects Manually
2.4.12
Saving a Query
2.4.13
Adding a Bind Variable to a Query
2.4.14
Editing a Saved Query
2.5
Creating a Data Set Using an MDX Query Against an OLAP Data Source
2.6
Creating a Data Set Using an LDAP Query
2.7
Creating a Data Set Using a Microsoft Excel File
2.7.1
About Supported Excel Files
2.7.2
Guidelines for Accessing Multiple Tables per Sheet
2.7.3
Using a Microsoft Excel File Stored in a File Directory Data Source
2.7.4
Uploading a Microsoft Excel File Stored Locally
2.7.4.1
Refreshing and Deleting an Uploaded Excel File
2.8
Creating a Data Set Using an Oracle BI Analysis
2.8.1
Additional Notes on Oracle BI Analysis Data Sets
2.9
Creating a Data Set Using a View Object
2.9.1
Additional Notes on View Object Data Sets
2.10
Creating a Data Set Using a Web Service
2.10.1
Adding a Simple Web Service: Example
2.10.2
Adding a Complex Web Service
2.10.3
Additional Information on Web Service Data Sets
2.11
Creating a Data Set Using a Stored XML File
2.11.1
Additional Information on File Data Sets
2.12
Using Data Stored as a Character Large Object (CLOB) in a Data Model
2.12.1
How the Data Is Returned
2.12.1.1
Additional Notes on Data Sets Using CLOB Column Data
2.12.2
Handling XHTML Data Stored in a CLOB Column
2.12.2.1
Retrieving XHTML Data Wrapped in CDATA
2.12.2.2
Wrapping the XHTML Data in CDATA in the Query
2.13
Creating a Data Set from an HTTP XML Feed
2.13.1
Additional Information on Data Sets Created from HTTP XML Feed
2.14
Testing Data Models and Generating Sample Data
2.15
Including User Information Stored in System Variables in Your Report Data
2.15.1
Adding the User System Variables as Elements
2.15.2
Sample Use Case: Limit the Returned Data Set by User ID
2.15.2.1
Creating Bind Variables from LDAP User Attribute Values
3
Structuring Data
3.1
Working with Data Models
3.1.1
About Multipart Unrelated Data Sets
3.1.2
About Multipart Related Data Sets
3.1.3
Guidelines for Working with Data Sets
3.2
Features of the Data Model Editor
3.3
About the Interface
3.4
Creating Links Between Data Sets
3.4.1
About Element-Level Links
3.4.2
About Group-Level Links
3.5
Creating Element-Level Links
3.5.1
Deleting Element-Level Links
3.6
Creating Group-Level Links
3.6.1
Deleting Group-Level Links
3.7
Creating Subgroups
3.8
Moving an Element Between a Parent Group and a Child Group
3.9
Creating Group-Level Aggregate Elements
3.10
Creating Group Filters
3.11
Performing Element-Level Functions
3.12
Setting Element Properties
3.13
Sorting Data
3.14
Performing Group-Level Functions
3.14.1
The Group Action Menu
3.14.2
Editing the Data Set
3.14.3
Removing Elements from the Group
3.14.4
Editing the Group Properties
3.15
Performing Global-Level Functions
3.15.1
Adding a Global-Level Aggregate Function
3.15.2
Adding a Group-Level or Global-Level Element by Expression
3.15.3
Adding a Global-Level Element by PL/SQL
3.16
Using the Structure View to Edit Your Data Structure
3.16.1
Renaming Elements
3.16.2
Adding Value for Null Elements
3.17
Function Reference
4
Adding Parameters and Lists of Values
4.1
About Parameters
4.2
Adding a New Parameter
4.2.1
Defining a Text Parameter
4.2.2
Defining a Menu Parameter
4.2.2.1
Customizing the Display of Menu Parameters
4.2.3
Defining a Date Parameter
4.3
About Lists of Values
4.4
Adding Lists of Values
4.4.1
Creating a List from a SQL Query
4.4.2
Creating a List from a Fixed Data Set
5
Adding Event Triggers
5.1
About Triggers
5.2
Adding Before Data and After Data Triggers
5.2.1
Order of Execution
5.3
Creating Schedule Triggers
6
Adding Flexfields
6.1
About Flexfields
6.2
Adding Flexfields
6.2.1
Entering Flexfield Details
7
Adding Bursting Definitions
7.1
About Bursting
7.2
What is the Bursting Definition?
7.3
Adding a Bursting Definition to Your Data Model
7.4
Defining the Query for the Delivery XML
7.5
Passing a Parameter to the Bursting Query
7.6
Defining the Split By and Deliver By Elements for a CLOB/XML Data Set
7.7
Configuring a Report to Use a Bursting Definition
7.8
Sample Bursting Query
7.9
Creating a Table to Use as a Delivery Data Source
Index
Scripting on this page enhances content navigation, but does not change the content in any way.