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

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.

To create and edit the SQL syntax of a column filter:

Create or open a named filter or an analysis that contains an inline filter.
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.
Specify the filter's criteria and select Convert this filter to SQL.
Click OK.

The "Advanced SQL Filter dialog" is displayed.
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.