Overview of Creating Data Sets

Oracle BI Publisher can retrieve data from multiple types of data sources.

To create a data set:

1. On the component pane of the data model editor, click New Data Set and select your source data set type.

   
   Description of the illustration GUID-06083C0C-E591-4B16-8376-D4C4BFD01202-default.gif

2. Complete the required fields. See the corresponding section:

   • Creating Data Sets Using SQL Queries

   • Creating a Data Set Using a MDX Query Against an OLAP Data Source

   • 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 an LDAP Query

   • Creating a Data Set Using a XML File

   • Creating a Data Set Using a Microsoft Excel File

   • Creating a Data Set Using a CSV File

   • Creating a Data Set from an HTTP XML Feed

   • Using Data Stored as a Character Large Object (CLOB) in a Data Model