Go to main content
1/86
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documentation and Other Resources
System Requirements and Certification
Conventions
New Features for Data Model Designers
New Features and Changes for Oracle BI Publisher 12c (12.2.1.1.0)
New Features and Changes for Oracle BI Publisher 12c (12.2.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
XML Output Options
Adding Attachments to the Data Model
Attaching Sample Data
Attaching Schema
Data Files
Managing Private Data Sources
2
Creating Data Sets
Overview of Creating Data Sets
Editing an Existing Data Set
Creating Data Sets Using SQL Queries
Entering SQL Queries
Creating Non-Standard SQL Data Sets
Using the SQL Query Builder
Overview of the Query Builder
Understanding the Query Builder Process
Supported Column Types
Adding Objects to the Design Pane
Removing or Hiding Objects in the Design Pane
Specifying Query Conditions
Creating Relationships Between Objects
About Join Conditions
Joining Objects Manually
Saving a Query
Editing a Saved Query
Adding a Bind Variable to a Query
Adding a Bind Variable Using a Text Editor
Adding Lexical References to SQL Queries
Defining SQL Queries Against the Oracle BI Server
Notes for Queries Against Oracle Fusion Applications Tables
Creating a Data Set Using a MDX Query Against an OLAP Data Source
Creating a Data Set Using a MDX Query
Using MDX Query Builder
Understanding the MDX Query Builder Process
Using the Select Cube Dialog
Selecting Dimensions and Measures
Adding Dimension Members to the Slicer/POV Axis
Performing MDX Query Actions
Applying MDX Query Filters
Selecting MDX Query Options and Saving MDX Queries
Creating a Data Set Using an Oracle BI Analysis
Additional Notes on Oracle BI Analysis Data Sets
Creating a Data Set Using a View Object
Additional Notes on View Object Data Sets
Creating a Data Set Using a Web Service
Web Service Data Source Options
Creating a Data Set Using a Simple Web Service
Creating a Data Set Using a Complex Web Service
Additional Information on Web Service Data Sets
Creating a Data Set Using an LDAP Query
Creating a Data Set Using a XML File
About Supported XML Files
Using a XML File Stored in a File Directory Data Source
Uploading a XML File Stored Locally
Refreshing and Deleting an Uploaded XML File
Creating a Data Set Using a Content Server
Creating a Data Set Using a Microsoft Excel File
Options for Uploading Excel Files to BI Publisher
About Supported Excel Files
Accessing Multiple Tables per Sheet
Using a Microsoft Excel File Stored in a File Directory Data Source
Uploading a Microsoft Excel File Stored Locally
Refreshing and Deleting an Uploaded Excel File
Creating a Data Set Using a CSV File
About Supported CSV Files
Creating a Data Set from a Centrally Stored CSV File
Uploading a CSV File Stored Locally
Editing the Data Type
Refreshing and Deleting an Uploaded CSV File
Creating a Data Set from an HTTP XML Feed
Creating a Data Set from an HTTP XML Data Set
Using Data Stored as a Character Large Object (CLOB) in a Data Model
How the Data Is Returned
Additional Notes on Data Sets Using CLOB Column Data
Handling XHTML Data Stored in a CLOB Column
Retrieving XHTML Data Wrapped in CDATA
Wrapping the XHTML Data in CDATA in the Query
Testing Data Models and Generating Sample Data
Including User Information Stored in System Variables in Your Report Data
Adding the User System Variables as Elements
Sample Use Case: Limit the Returned Data Set by User ID
Creating Bind Variables from LDAP User Attribute Values
Prerequisite
How BI Publisher Constructs the Bind Variable
3
Structuring Data
Working with Data Models
About Multipart Unrelated Data Sets
About Multipart Related Data Sets
Guidelines for Working with Data Sets
Features of the Data Model Editor
About the Interface
Creating Links Between Data Sets
About Element-Level Links
About Group-Level Links
Creating Element-Level Links
Deleting Element-Level Links
Creating Group-Level Links
Deleting Group-Level Links
Creating Subgroups
Moving an Element Between a Parent Group and a Child Group
Creating Group-Level Aggregate Elements
Creating Group Filters
Performing Element-Level Functions
Setting Element Properties
Sorting Data
Performing Group-Level Functions
The Group Action Menu
Editing the Data Set
Removing Elements from the Group
Editing the Group Properties
Performing Global-Level Functions
Adding a Global-Level Aggregate Function
Adding a Group-Level or Global-Level Element by Expression
Adding a Global-Level Element by PL/SQL
Using the Structure View to Edit Your Data Structure
Renaming Elements
Adding Value for Null Elements
Function Reference
4
Adding Parameters and Lists of Values
About Parameters
Adding a New Parameter
Creating a Text Parameter
Creating a Menu Parameter
Customizing the Display of Menu Parameters
Defining a Date Parameter
About Lists of Values
Adding Lists of Values
Creating a List from a SQL Query
Creating a List from a Fixed Data Set
Adding Flexfield Parameters
Prerequisites for Using Flexfields
Adding a Flexfield Parameter and List of Values
Adding the Flexfield List of Values
Adding the Menu Parameter for the Flexfield List of Values
Using the Flexfield Parameter to Pass Values to a Flexfield Defined in the Data Model
Referencing the Flexfield in the SQL Query
Passing a Range of Values
5
Adding Event Triggers
About Triggers
Adding Before Data and After Data Triggers
Order of Execution
Creating Schedule Triggers
6
Adding Flexfields
About Flexfields
Using Flexfields in Your Data Model
Adding Key Flexfields
Entering Flexfield Details
Adding Descriptive Flexfields
Including Descriptive Flexfield Reference in SQL Queries
7
Adding Bursting Definitions
About Bursting
What is the Bursting Definition?
Adding a Bursting Definition to Your Data Model
Attaching PDF to Reports using Bursting Engine
Defining the Query for the Delivery XML
Passing a Parameter to the Bursting Query
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
8
Adding Custom Metadata for Oracle WebCenter Content Server
About Custom Metadata Mapping
Prerequisites
Mapping Data Fields to Custom Metadata Fields
Deleting Unused Metadata Fields
9
Performance Best Practices
Know Oracle WebLogic Server Default Time Out Setting
Best Practices for SQL Data Sets
Only Return the Data You Need
Use Column Aliases to Shorten XML File Length
Avoid Using Group Filters by Enhancing Your Query
Avoid PL/SQL Calls in WHERE Clauses
Avoid Use of the System Dual Table
Avoid PL/SQL Calls at the Element Level
Avoid Including Multiple Data Sets
Avoid Nested Data Sets
Avoid In-Line Queries as Summary Columns
Avoid Excessive Parameter Bind Values
Tips for Multi-value Parameters
Group Break and Sorting Data
Limit Lists of Values
Working with Lexicals/Flexfields
Working with Date Parameters
Run Report Online/Offline (Schedule)
Setting Data Model Properties to Prevent Memory Errors
Query Time Out
DB Fetch Size
Scalable Mode
SQL Pruning
SQL Query Tuning
Generate Explain Plan
Explain Plan for a Single Query
Explaining Plan for Reports
Guidelines for Tuning Queries
Tips for Database Tuning
Scripting on this page enhances content navigation, but does not change the content in any way.