Contents

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Related Documents
• Conventions

New Features for Data Model Designers

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

1 Introduction to the Oracle Business Intelligence Publisher Data Modeling Guide

• 1.1 Introduction to Oracle Business Intelligence Publisher

2 Using the Data Model Editor

• 2.1 What Is a Data Model?
• 2.2 Components of a Data Model
• 2.3 Features of the Data Model Editor
• 2.4 About the Data Source Options
• 2.5 Process Overview for Creating a Data Model
• 2.6 Launching the Data Model Editor
• 2.7 About the Data Model Editor Interface
• 2.8 Setting Data Model Properties
  • 2.8.1 XML Output Options
  • 2.8.2 Attachments to the Data Model
    • 2.8.2.1 Attaching Sample Data
    • 2.8.2.2 Attaching Schema
    • 2.8.2.3 Data Files

3 Creating Data Sets

• 3.1 Overview of Creating Data Sets
• 3.2 Editing an Existing Data Set
• 3.3 Creating a Data Set Using a SQL Query
• 3.4 Using the Query Builder
  • 3.4.1 Understanding the Query Builder Process
  • 3.4.2 Using the Object Selection Pane
  • 3.4.3 Selecting a Schema
  • 3.4.4 Searching and Filtering Objects
  • 3.4.5 Selecting Objects
  • 3.4.6 Supported Column Types
  • 3.4.7 Adding Objects to the Design Pane
  • 3.4.8 Resizing the Design and Results Pane
  • 3.4.9 Removing or Hiding Objects in the Design Pane
  • 3.4.10 Specifying Query Conditions
  • 3.4.11 Creating Relationships Between Objects
    • 3.4.11.1 About Join Conditions
    • 3.4.11.2 Joining Objects Manually
  • 3.4.12 Saving a Query
  • 3.4.13 Adding a Bind Variable to a Query
  • 3.4.14 Editing a Saved Query
• 3.5 Creating a Data Set Using an MDX Query Against an OLAP Data Source
• 3.6 Creating a Data Set Using an LDAP Query
• 3.7 Creating a Data Set Using a Microsoft Excel File
  • 3.7.1 About Supported Excel Files
  • 3.7.2 Guidelines for Accessing Multiple Tables per Sheet
  • 3.7.3 Using a Microsoft Excel File Stored in a File Directory Data Source
  • 3.7.4 Uploading a Microsoft Excel File Stored Locally
    • 3.7.4.1 Refreshing and Deleting an Uploaded Excel File
• 3.8 Creating a Data Set Using an Oracle BI Analysis
  • 3.8.1 Additional Notes on Oracle BI Analysis Data Sets
• 3.9 Creating a Data Set Using a View Object
  • 3.9.1 Additional Notes on View Object Data Sets
• 3.10 Creating a Data Set Using a Web Service
  • 3.10.1 Adding a Simple Web Service: Example
  • 3.10.2 Adding a Complex Web Service
  • 3.10.3 Additional Information on Web Service Data Sets
• 3.11 Creating a Data Set Using a Stored XML File
  • 3.11.1 Additional Information on File Data Sets
• 3.12 Using Data Stored as a Character Large Object (CLOB) in a Data Model
  • 3.12.1 How the Data Is Returned
    • 3.12.1.1 Additional Notes on Data Sets Using CLOB Column Data
  • 3.12.2 Handling XHTML Data Stored in a CLOB Column
    • 3.12.2.1 Retrieving XHTML Data Wrapped in CDATA
    • 3.12.2.2 Wrapping the XHTML Data in CDATA in the Query
• 3.13 Creating a Data Set from an HTTP XML Feed
  • 3.13.1 Additional Information on Data Sets Created from HTTP XML Feed
• 3.14 Testing Data Models and Generating Sample Data
• 3.15 Including User Information Stored in System Variables in Your Report Data
  • 3.15.1 Adding the User System Variables as Elements
  • 3.15.2 Sample Use Case: Limit the Returned Data Set by User ID
    • 3.15.2.1 Creating Bind Variables from LDAP User Attribute Values

4 Structuring Data

• 4.1 Working with Data Models
  • 4.1.1 About Multipart Unrelated Data Sets
  • 4.1.2 About Multipart Related Data Sets
  • 4.1.3 Guidelines for Working with Data Sets
• 4.2 Features of the Data Model Editor
• 4.3 About the Interface
• 4.4 Creating Links Between Data Sets
  • 4.4.1 About Element-Level Links
  • 4.4.2 About Group-Level Links
• 4.5 Creating Element-Level Links
  • 4.5.1 Deleting Element-Level Links
• 4.6 Creating Group-Level Links
  • 4.6.1 Deleting Group-Level Links
• 4.7 Creating Subgroups
• 4.8 Moving an Element Between a Parent Group and a Child Group
• 4.9 Creating Group-Level Aggregate Elements
• 4.10 Creating Group Filters
• 4.11 Performing Element-Level Functions
• 4.12 Setting Element Properties
• 4.13 Sorting Data
• 4.14 Performing Group-Level Functions
  • 4.14.1 The Group Action Menu
  • 4.14.2 Editing the Data Set
  • 4.14.3 Removing Elements from the Group
  • 4.14.4 Editing the Group Properties
• 4.15 Performing Global-Level Functions
  • 4.15.1 Adding a Global-Level Aggregate Function
  • 4.15.2 Adding a Group-Level or Global-Level Element by Expression
  • 4.15.3 Adding a Global-Level Element by PL/SQL
• 4.16 Using the Structure View to Edit Your Data Structure
  • 4.16.1 Renaming Elements
  • 4.16.2 Adding Value for Null Elements
• 4.17 Function Reference

5 Adding Parameters and Lists of Values

• 5.1 About Parameters
• 5.2 Adding a New Parameter
  • 5.2.1 Defining a Text Parameter
  • 5.2.2 Defining a Menu Parameter
    • 5.2.2.1 Customizing the Display of Menu Parameters
  • 5.2.3 Defining a Date Parameter
• 5.3 About Lists of Values
• 5.4 Adding Lists of Values
  • 5.4.1 Creating a List from a SQL Query
  • 5.4.2 Creating a List from a Fixed Data Set

6 Adding Event Triggers

• 6.1 About Triggers
• 6.2 Adding Before Data and After Data Triggers
  • 6.2.1 Order of Execution
• 6.3 Creating Schedule Triggers

7 Adding Flexfields

• 7.1 About Flexfields
• 7.2 Adding Flexfields
  • 7.2.1 Entering Flexfield Details

8 Adding Bursting Definitions

• 8.1 About Bursting
• 8.2 What is the Bursting Definition?
• 8.3 Adding a Bursting Definition to Your Data Model
• 8.4 Defining the Query for the Delivery XML
• 8.5 Passing a Parameter to the Bursting Query
• 8.6 Defining the Split By and Deliver By Elements for a CLOB/XML Data Set
• 8.7 Configuring a Report to Use a Bursting Definition
• 8.8 Sample Bursting Query
• 8.9 Creating a Table to Use as a Delivery Data Source

Index