Designing Data Access - Professional SQL Server 2005 Reporting Services - page 170

Figure 5-60
Adding MDX Filters and Parameters
Filtering MDX queries is quite different than it is with SQL queries and in many ways is easier. One of
the unique characteristics of MDX and cube data is that there is not a clear separation of the data from
the data structure. In Figure 5-61, I have expanded the Organization dimension to expose its members. I
would like this report to be limited to only North America Operations. Adding this filter is simple: Drag
the North America Operations member to the filters and parameters pane in the MDX Query Designer.
Figure 5-61
This creates an expression to filter the report data from the cube. The results are refreshed to reflect this
change to the query. Filter selections are not exposed to users by default. I'd like to add another filter
that may be controlled with user-selectable values, so in addition to a filter expression, I'd like to create
two parameter lists to enable the user's selection of a range of years for the delivery date.