When this happens, the name of the dimension and hierarchy are displayed. An
operator column can be changed from Equal to a number of other items, such as Not
Equal, Contains, and Beings With. Next, the developer can choose members from
the hierarchy in the Filter Expression drop-down list. This is useful when the report
has a hard-coded filter on the data that the user can neither see nor modify.
The final column in the filter area is a check box named Parameters. Simply
checking this box makes the current hierarchy a parameter, and this causes at least
three things to happen. First, while nothing changes on the report at design time, the
report at runtime will have a drop-down box for the parameter. Second, the original
query is modified to now include the value of the parameter in the report. Finally, a
new dataset is created that retrieves the data to fill the parameter drop-down list for
the report at runtime. Figure 10-9 shows what the query looks like in design mode
with a parameter added.
Figure 10-9 The query for the sales report now has a filter added to it, and the filter is
marked to be used as a parameter.
330 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
In Figure 10-9, a parameter has been added for product categories. This means
that end users will be able to select one or more product categories and see the
sales data for just the selected categories.
Pages:
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419