Filter by the Value of One or More Dimensions

You can select all rows in a transaction table that have one or more columns whose value matches (or doesn't match) values in dimension tables.

In the following picture, the selection criterion IsChildOf(Channel, '[DIM_CHANNEL].[ATM]') AND IsChildOf(Product, '[DIM_PRODUCT].[Deposit Products].[CHK]') selects the first several rows in the transaction table:

Notice that the IsChildOf property allows you to select from any point in a dimension hierarchy tree, and all children of that hierarchy are filtered as a "Yes" value.