Leveraging Performance Point Services - Microsoft Business Intelligence Tools for Excel Analysts - page 311

Figure 16-6: Choosing a Filter template.
The Member Selection template is by far the easiest filter template to work with because you're
provided with a visual interface that allows you to define the behavior of the filter by clicking and
dragging dimension and members. The other filter templates shown in Figure 16-6 require familiarity
with MDX or additional SharePoint configurations.
Follow these steps to add a Member Selection filter:
1. In the Select a Filter Template dialog box (refer to Figure 16-6), click Member Selection and
then click OK.
The Create a Filter Wizard appears.
2. Enter a name for your filter in the Name text box and then click Next.
3. Select the data connection you want to use for the filter and then click Next.
4. Click the Select Members option on the left side of the Select Members dialog box, as shown
in Figure 16-7.
The Select Members dialog box shows the list of dimensions based on the underlying data
connection. Some dimensions contain multiple hierarchies to choose from. In Figure 16-7,
the Calendar Date hierarchy is selected from the Date dimension.