You can define which members Integration Services retrieves for a drill-through report. The member filters that you define can be used once or can be saved and accessed again, as described inSelecting Data Filters.
To create a member filter:
In Set Filter on Column, select the column to which the condition applies from Column.
The column displayed in the Column list box is the one you selected inSelecting Data Filters.
To build a filter interactively, perform these tasks:
Enter the condition in Condition (for example, West), or click Browse to open a list of all possible values for that column.
Integration Services retrieves these values directly from the relational data source. If the relational data source contains many values, Integration Services confirms whether to view them all.
Select the value, and then click OK.
To select multiple values that are not adjacent, press Ctrl and click each value. To select a range of values, press Shift and click the first and last values. You can select multiple values only if you selected in or not in as the operator.
If you specify multiple conditions, from Add Type, select And or Or.
To define another condition on the filter, return to step 2.
Optional: Edit filters using the SQL syntax required by the relational data source.
To permanently save this filter, see Saving, Deleting, and Renaming Member Filters.