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.
You cannot de-select an entire dimension, and you need to select at least one value for each dimension.
The Filters dialog opens.
The OLAP query is rerun and results are returned recalculated.
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.