Drillthrough Filters
You can use a drillthrough filter to limit the number of rows returned when users use the Drillthrough qualifier in a Multidimensional Expressions (MDX) query. Because the component elements for a member (that is, the elements that make up the aggregation of the member) from the fact table can be numerous, a mechanism is needed to limit the number of rows that come back as a result of a drillthrough.
Examples
Using a Filter with the Drillthrough Function
The following example limits the results returned by the Drillthrough function to those customers who live in the city of Olympia:
"Customers.City" = "Olympia"