Specify a filter to limit the results returned for specific target drill-through columns.
To specify drill-through report filters for relational sources:
In the Report Contents tab of the drill-through reports editor, click Filter.
In the Drill-through Filter dialog box, drag the appropriate elements from the lists of elements in the Source, Functions and Operators tabs and drop them in the Filter box.
For example, to filter a drill through report for members in the “400” product family, you may enter a filter such as the following:
'contains'( connection : \'tbcSource'::'tbc.family'.'FAMILY'=="400")
To filter a drill-through report for members in the “400” product family in the state of New York only, you may enter a filter such as the following;
contains(connection : \'tbcSource'::'tbc.market'.'STATE',"New York") and contains(connection : \'tbcSource'::'tbc.family'.'FAMILY',"400")
Click OK to close the Drill-through Filter dialog box and return to the Report Contents tab of the drill-through report editor.
To complete the remaining tasks in the Report Contents tab of the drill-through report editor, see the following topics: