Go to main content
1/13
Contents
Title and Copyright Information
Preface
Intended Audience
Documentation Accessibility
Related Documentation and Other Resources
Conventions
New Features for Data Model Designers
New Features and Changes for Oracle BI Publisher 11
g
Release 1 (11.1.1.9)
New Features for Oracle BI Publisher 11
g
Release 1 (11.1.1.7)
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.6.1
About the Data Model Editor Interface
1.7
Setting Data Model Properties
1.7.1
XML Output Options
1.7.2
Attachments to the Data Model
1.7.2.1
Attaching Sample Data
1.7.2.2
Attaching Schema
1.7.2.3
Data Files
1.8
Managing Private Data Sources
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.3.1
Entering SQL Queries
2.3.2
Creating Non-Standard SQL Data Sets
2.3.3
Using the SQL Query Builder
2.3.3.1
Overview of the Query Builder
2.3.3.2
Understanding the Query Builder Process
2.3.3.3
Using the Object Selection Pane
2.3.3.4
Selecting a Schema
2.3.3.5
Searching and Filtering Objects
2.3.3.6
Selecting Objects
2.3.3.7
Supported Column Types
2.3.3.8
Adding Objects to the Design Pane
2.3.3.9
Resizing the Design and Results Pane
2.3.3.10
Removing or Hiding Objects in the Design Pane
2.3.3.11
Specifying Query Conditions
2.3.3.12
Creating Relationships Between Objects
2.3.3.13
Saving a Query
2.3.3.14
Editing a Saved Query
2.3.4
Adding a Bind Variable to a Query
2.3.5
Adding Lexical References to SQL Queries
2.3.6
Defining SQL Queries Against the Oracle BI Server
2.4
Creating a Data Set Using a MDX Query Against an OLAP Data Source
2.4.1
Creating a Data Set Using a MDX Query
2.5
Using MDX Query Builder
2.5.1
Understanding the MDX Query Builder Process
2.5.2
Using the Select Cube Dialog
2.5.3
Selecting Dimensions and Measures
2.5.3.1
Adding Dimension Members to the Slicer/POV Axis
2.5.4
Performing MDX Query Actions
2.5.5
Applying MDX Query Filters
2.5.6
Selecting MDX Query Options and Saving MDX Queries
2.6
Creating a Data Set Using an Oracle BI Analysis
2.6.1
Additional Notes on Oracle BI Analysis Data Sets
2.7
Creating a Data Set Using a View Object
2.7.1
Additional Notes on View Object Data Sets
2.8
Creating a Data Set Using a Web Service
2.8.1
Creating a Data Set Using a Web Service
2.8.1.1
Creating a Data Set Using a Simple Web Service
2.8.1.2
Creating a Data Set Using a Complex Web Service
2.8.2
Additional Information on Web Service Data Sets
2.9
Creating a Data Set Using an LDAP Query
2.10
Creating a Data Set Using a XML File
2.10.1
About Supported XML Files
2.10.2
Using a XML File Stored in a File Directory Data Source
2.10.3
Uploading a XML File Stored Locally
2.10.3.1
Refreshing and Deleting an Uploaded XML File
2.11
Creating a Data Set Using a Microsoft Excel File
2.11.1
About Supported Excel Files
2.11.2
Guidelines for Accessing Multiple Tables per Sheet
2.11.3
Using a Microsoft Excel File Stored in a File Directory Data Source
2.11.4
Uploading a Microsoft Excel File Stored Locally
2.11.4.1
Refreshing and Deleting an Uploaded Excel File
2.12
Creating a Data Set Using a CSV File
2.12.1
About Supported CSV Files
2.12.2
Using a CSV File Stored in a File Directory Data Source
2.12.3
Uploading a CSV File Stored Locally
2.12.3.1
Editing the Data Type
2.12.3.2
Refreshing and Deleting an Uploaded CSV File
2.13
Creating a Data Set from an HTTP XML Feed
2.13.1
Creating a Data Set from an HTTP XML Data Set
2.14
Using Data Stored as a Character Large Object (CLOB) in a Data Model
2.14.1
How the Data Is Returned
2.14.1.1
Additional Notes on Data Sets Using CLOB Column Data
2.14.2
Handling XHTML Data Stored in a CLOB Column
2.14.2.1
Retrieving XHTML Data Wrapped in CDATA
2.14.2.2
Wrapping the XHTML Data in CDATA in the Query
2.15
Testing Data Models and Generating Sample Data
2.16
Including User Information Stored in System Variables in Your Report Data
2.16.1
Adding the User System Variables as Elements
2.16.2
Sample Use Case: Limit the Returned Data Set by User ID
2.16.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
4.5
Adding Flexfield Parameters
4.5.1
Prerequisites for Using Flexfields
4.5.2
Adding a Flexfield Parameter and List of Values
4.5.2.1
Adding the Flexfield List of Values
4.5.2.2
Adding the Menu Parameter for the Flexfield List of Values
4.5.2.3
Using the Flexfield Parameter to Pass Values to a Flexfield Defined in the Data Model
4.5.2.4
Referencing the Flexfield in the SQL Query
4.5.2.5
Passing a Range of Values
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.1.1
Using Flexfields in Your Data Model
6.2
Adding Key Flexfields
6.2.1
Entering Flexfield Details
6.3
Adding Descriptive Flexfields
6.3.1
Including Descriptive Flexfield Reference in SQL Queries
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
8
Adding Custom Metadata for Oracle WebCenter Content Server
8.1
About Custom Metadata Mapping
8.1.1
Prerequisites
8.2
Mapping Data Fields to Custom Metadata Fields
8.3
Deleting Unused Metadata Fields
Index
Scripting on this page enhances content navigation, but does not change the content in any way.