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.
You must have one of the following user type
permissions:
BI Author Limited
BI Author Developer
BI Tenant Administrator