DB2 graphic QMF Version 8

Filtering Options

You can use the Filters dialog to select which cube dimensions will be included in the OLAP query. With this option you can choose to exclude data from the OLAP query.

The Filters dialog box lists the dimensions defined for the cube. Each dimension of a cube has one or more attributes. By checking or unchecking a check box you can choose to include or exclude the attribute's or entire dimension's data from being included in the OLAP query.

Select values to include in results

You cannot de-select an entire dimension, and you need to select at least one value for each dimension.

Procedure

  1. Use the OLAP Query Wizard to select a cube, run the OLAP query and return results.
  2. Open the Filter dialog by:

    The Filters dialog opens.

  3. Click the (+) to expand the dimension.
  4. Uncheck the check box next to each dimension item you want to filter out from the OLAP query.
    Note:
    You cannot filter out an entire dimension.
  5. Click OK.

    The OLAP query is rerun and results are returned recalculated.

Additional Filter Options

There are two additional filtering options:

The Filter out and the Filter Everything but options are available from context menu that opens in the OLAP query results when you right click on a cell in a column. If you select Filter out, the cell of the column is filtered out of the query results. If you select Filter Everything but, then all the cells of the column are filtered out from the query results except for the one that you selected.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004