Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents

Analysis editor: Criteria tab

Use this tab of the "Analysis editor" for:

Common Components

Subject Areas

Use the "Subject Areas pane" to select the columns and hierarchy levels for an analysis and to work with subject areas.


Use the "Catalog pane" to drag and drop objects from the catalog to add to the analysis.

General Components

Use the following components when you are not creating a direct database request.

Selected Columns

Use the "Selected Columns pane" to modify the columns and hierarchy levels that have been selected for an analysis.


Use the "Filters pane" to create new filters for an analysis.

Selection Steps

Use the "Selection Steps pane" to create and modify steps for data selections. This pane is not visible until you click the button on the toolbar to display it.


The toolbar contains the following buttons:

Direct Database Request Components

Use the following components when you create a direct database request.

For more information, see "Working with Direct Database Requests."

Connection Pool

Enter the name of the connection pool for the database that is defined in the physical layer of the Oracle BI Administration Tool. A sample name is sql_samples.

For information about connection pools, see System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

SQL Statement

Enter the SQL statement to send directly to the database. Oracle BI Server security rules for data are bypassed and cannot be applied when you send a direct database request.

The statement that you execute is affected by the user name that is specified for this connection pool in the Oracle BI Administration Tool. You might find that not all columns from the database are returned to you, if the specified user name is not permitted to see them.

Validate SQL and Retrieve Columns

Click this button to validate the SQL statement and retrieve any columns that you have specified in the request. The columns are displayed in the Result Columns area.

If any errors are returned from the database, then you see them in the area below this button. See Oracle Database SQL Language Reference for information on resolving any errors.

Bypass Oracle BI Presentation Services Cache

Use this box to specify whether to use the Oracle BI Presentation Services Cache. Select this box to specify that you do want the request to use the Presentation Services cache. In general, you should avoid selecting this box as enabling the cache has potential performance degradation issues.

Result Columns

Use this area to work with the columns that are returned, if any, from the valid SQL statement. This area includes each column name and data type with the following options:

To change which columns that are returned, modify and validate the SQL statement.