2 Creating Data Sets

This chapter describes creating data sets, testing data models, and saving sample data in BI Publisher.

This chapter includes the following sections:

• Overview of Creating Data Sets

• Editing an Existing Data Set

• Creating Data Sets Using SQL Queries

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

• Using MDX Query Builder

• 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

• Testing Data Models and Generating Sample Data

• Including User Information Stored in System Variables in Your Report Data