Filter Tab (Drillthrough Options Dialog Box)
Use this tab to specify a filter (WHERE clause expression of an SQL SELECT statement) to limit the result set returned by drillthrough. Type the text that follows WHERE, but exclude the WHERE keyword.
For example, to limit the result set to 1998 data, type:
"the_year"=1998
Another example (alphanumeric data):
"the_month"='January'
Whenever necessary to avoid ambiguity, use a qualified expression. For example, if a column name appears in multiple tables, include the table name in the expression:
"time"."the_month"='January'
The SELECT statement used to retrieve rows for the creation of the result set is generated automatically. The filter expression is connected with an AND to the automatically generated part of the WHERE clause. Therefore, if you specify multiple filter expressions, enclose them all in a pair of parentheses, for example:
("the_year"=1998 OR "the_year"=1999)
The filter expression acts as a pass-through statement, and its syntax is not checked until a drillthrough is executed. If the syntax is incorrect, drillthrough fails.
For more information, see Drillthrough Filters.
If you are editing a cube, the filter in this tab can be overridden in the cube's partitions. For information about accessing the drillthrough filter of a partition, see Specifying Drillthrough Options.