If you are using Flexfields, bind variables, or other special processing in your query, edit the SQL returned by the Query Builder to include the required statements. See Section 2.3.3, "Using the SQL Query Builder" for more information about the Query Builder utility. See Section 2.3.2, "Creating Non-Standard SQL Data Sets" for information on using other types of SQL.Įnter the SQL query or click Query Builder to launch the Query Builder page. The SQL type defaults to Standard SQL used for normal SELECT statements interpreted to understand database schema. See Section 1.8, "Managing Private Data Sources" for information about private data source connections. You can also use your private data source connections as data sources for SQL query data sets. If you are not using the default data source for this data set, select the Data Source from the list. The data source defaults to the default data source that you selected on the Properties page. Section 2.17, "Including User Information Stored in System Variables in Your Report Data"įigure 2-3 New Data Set - SQL Query Dialog Section 2.16, "Testing Data Models and Generating Sample Data" Section 2.15, "Using Data Stored as a Character Large Object (CLOB) in a Data Model" Section 2.14, "Creating a Data Set from an Oracle Endeca Query" Section 2.13, "Creating a Data Set from an HTTP XML Feed" Section 2.12, "Creating a Data Set Using a CSV File" Section 2.11, "Creating a Data Set Using a Microsoft Excel File" Section 2.10, "Creating a Data Set Using a XML File" Section 2.9, "Creating a Data Set Using an LDAP Query" Section 2.8, "Creating a Data Set Using a Web Service" Section 2.7, "Creating a Data Set Using a View Object" Section 2.6, "Creating a Data Set Using an Oracle BI Analysis" Section 2.4, "Creating a Data Set Using a MDX Query Against an OLAP Data Source" Section 2.3, "Creating a Data Set Using a SQL Query" Section 2.2, "Editing an Existing Data Set" Section 2.1, "Overview of Creating Data Sets" This chapter includes the following sections: This chapter describes creating data sets, testing data models, and saving sample data in BI Publisher.