Analysis editor: Criteria tab

Use this tab of the "Analysis editor" for:

• "Specifying the Criteria for Analyses"

• "Editing the Formula for a Column"

• "Formatting Columns in Analyses"

• "Creating Column Filters"

• "Working with Selections of Data"

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.

Catalog

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.

Filters

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.

Toolbar

The toolbar contains the following buttons:

• Show/Hide Filters pane — Click this button to show and hide the "Filters pane".

• Show/Hide Selection Steps pane — Click this button to show and hide the "Selection Steps pane".

• Edit Analysis Properties — Click this button to display the "Analysis Properties dialog", where you specify properties for the entire analysis.

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 Oracle Fusion Middleware 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:

• Column Properties — Click this button to display the "Column Properties dialog", in which you modify the properties of the column. The "Column Properties dialog: Conditional Format tab" is not available in this case, because you cannot apply conditional formatting to a column that is returned using a direct database request.

• Edit Formula — Click this button to display the "Change Aggregation Rule dialog", in which you modify the aggregation rule for the column.

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