Creating and Editing the SQL Statements for a Column Filter in an Analysis

Before you start

You can create and edit the logical SQL WHERE clause to be used as a filter. While generally not necessary, this feature is available for users who want advanced filtering capability. For descriptions of SQL clauses, see Appendix D, "Logical SQL Reference."

Note: After you convert a filter to SQL statements, you can view and edit the filter item as SQL statements in the Advanced SQL Filter dialog, only. You can no longer view and edit the filter in the Edit Filter dialog.

You must have one of the following user type permissions:

• BI Author Limited

• BI Author Developer

• BI Tenant Administrator

Home > Oracle Business Intelligence > Catalog or, for Oracle Analytics,

Home > Oracle Analytics > Catalog

Here's what to do

1. Create or open a named filter or an analysis that contains an inline filter.
2. If you are working with a named filter, then locate the Saved Filter pane and from the Subject Areas pane, select the column for which you want to create a filter.
   If you are working with an inline filter, then locate the Filters Pane, and from the Filters Pane toolbar, click the Create a filter for the current Subject Area button and select the column for which you want to create the filter.
   The New Filter dialog is displayed.
3. Specify the filter's criteria and select Convert this filter to SQL.
4. Click OK.
5. Enter your modifications in the SQL field, and click OK. Not that after you convert the filter to a SQL statement, you can no longer view and edit the filter in the Edit Filter dialog.