Member Variable Filters

  To set a member variable filter:

1. In the data layout, double-click the item you want to define as a member filter.

   The Filter dialog box is displayed.

2. Select the method for retrieving items from the database from the Operator Type list.

   The selections shown on this list depend on the database to which you are connected. See Operator Types and Data Operators.

3. Specify any database-specific parameter requests.

4. Click Show Values to display values in the database.

5. In the Members field, select a member(s).

6. Move the member(s) to the Applied Filters list.

7. Click Set As Variable and click OK.

   The OLAPQuery section is redisplayed.

8. Click Process.

   The Filter dialog box is redisplayed.

9. Select the member(s) that you want to define as a variable filter in the Members field.

10. Move the member(s) as a variable filter to the Applied Filters list and click OK.