In this example, we will create a filter for the product category hierarchy. For this filter, we will use the product category hierarchy in the cube, and then we will associate this filter with the sales category of the territory report. Let's see how to do it by performing the following steps:
Go to Dashboard Designer, right-click on the PerformancePoint Content in Workspace Browser, and add a new filter by clicking on New Filter.
In the Select a Filter Template dialog box, choose Member Selection, as shown in the following screenshot:
Now, the Create a Filter wizard will be opened. In the first step, assign Sales Summary Cube Connection as the data source and continue.
In the Select Members window, click on Select Dimension.
In the Select Dimension dialog box, expand the Product dimension and choose the Categories hierarchy.
Click on the Select Members button, and in the Select Members dialog box, check the default member. Then, right-click on All Products...