Measure Variable Filters

  To set a measure variable filter:

  1. Double-click the item to define as a measure filter in the data layout.

    The Filter dialog box is displayed.

  2. Select the data operator from the Data Operator drop-down list.

    The selections shown on this list depend on the database to which you are connected.

  3. Specify any database-specific parameter requests, such as a column index or value.

  4. Move the measure to the Applied Filters list.

  5. Click Set As Variable and click OK.

    The OLAPQuery Section is redisplayed.

  6. Click Process.

    The Filter dialog box is redisplayed.

  7. Select a measure variable filter by selecting the data operator from the Data Operator drop-down list and specifying any database-specific parameter requests, such as a column index or value.

  8. Move the measure variable filter to the Applied Filters list and click OK.