Filtering a Pivot Table by a Large Dimension

A common issue I see on the MSDN forums and at clients is how to reduce the number of members available in a filter to only those with data in the pivot table. This question often originates from users wanting to filter the results of a pivot table by a dimension attribute containing a lot of members. Before we dive into a potential solution, let's discuss why this is such a common issue.