)
One of the simplest ways to create a filter is to use the Member Selection template,
which loads a dimension and allows the developer to select what members should
appear in the list. An MDX Query is a better option if the list needs to be dynamic
as in cases where values will be added or removed frequently; in this case, using the
Children method or Descendants function in MDX will be useful. For this example
the Member Selection template will be chosen.
After naming the filter, in this case Product Category, the data source is chosen.
Since the members will come from a dimension, the AdvWorks data source will be
used. The next screen asks for the dimension that contains the members and then the
members themselves. The dimension will be Product.Product Categories. Be careful
when selecting the members as the end users will often want to able to see the All
level (the total for everything) and then individual members as well. Developers
can also right-click on a member in the selector and set that member as the default
member in the filter. In the example of Product Categories, the members selected
are All Products, Accessories, Bikes, Clothing, and Components. Figure 5-36 shows
what this dialog will look like after the selections have been made, assuming that the
All member was chosen as the default value.
The next screen presents the designer with three options for how to display
the members to end users: List, Tree, and Multi-Select Tree.
Pages:
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190