Browser version script Skip Headers

Oracle Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher (Oracle Fusion Applications Edition)
Release 11g (11.1.1)
Part Number E21074-01
Go to next page
Next

Oracle Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher (Oracle Fusion Applications Edition)

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Introduction to the Oracle Business Intelligence Publisher Data Modeling Guide

Introduction to Oracle Business Intelligence Publisher
New Features for Oracle Business Intelligence Publisher 11g (11.1.1)

Using the Data Model Editor

What Is a Data Model?
Components of a Data Model
Features of the Data Model Editor
About the Data Source Options
Process Overview for Creating a Data Model
Launching the Data Model Editor
About the Data Model Editor Interface
Setting Data Model Properties

Creating Data Sets

Overview of Creating Data Sets
Editing an Existing Data Set
Creating a Data Set Using a SQL Query
Using the Query Builder
Creating a Data Set Using an MDX Query Against an OLAP Data Source
Creating a Data Set Using an LDAP Query
Creating a Data Set Using a Microsoft Excel File
Creating a Data Set Using an Oracle BI Analysis
Creating a Data Set Using a View Object
Creating a Data Set Using a Web Service
Creating a Data Set Using a Stored XML File
Using Data Stored as a Character Large Object (CLOB) in a Data Model
Creating a Data Set from an HTTP XML Feed
Testing Data Models and Generating Sample Data
Including User Information Stored in System Variables in Your Report Data

Structuring Data

Working with Data Models
Features of the Data Model Editor
About the Interface
Creating Links Between Data Sets
      Creating Element-Level Links
      Creating Group-Level Links
Creating Subgroups
Creating Group-Level Aggregate Elements
Creating Group Filters
Performing Element-Level Functions
      Setting Element Properties
Sorting Data
Performing Group-Level Functions
Performing Global-Level Functions
Using the Structure View to Edit Your Data Structure
Function Reference

Adding Parameters and Lists of Values

About Parameters
Adding a New Parameter
About Lists of Values
Adding Lists of Values

Adding Event Triggers

About Triggers
Adding Event Triggers

Adding Flexfields

About Flexfields
Adding Flexfields

Adding Bursting Definitions

About Bursting
What is the Bursting Definition?
Adding a Bursting Definition to Your Data Model
Defining the Query for the Delivery XML
Defining the Split By and Deliver By Elements for a CLOB/XML Data Set
Configuring a Report to Use a Bursting Definition
Sample Bursting Query
Creating a Table to Use as a Delivery Data Source

Index