Dimension Filters
You can use a dimension filter to specify which members of the source table are used to build that dimension. This topic provides examples of how to do this in different scenarios.
The following example demonstrates how to limit the members of the Geography dimension to those members in the USA.
Examples
A. Limiting Geography Dimension Members to Members
of the USA Country Level
of the USA Country Level
"Customer.Country" = 'USA'
B. Using Boolean Operators to Combine Selected Sets
"Product.ProductFamily" = 'Drink' and "Store Type.Store Type" = 'Supermarket'
"Store.Store City" = 'Seattle' or "Store.Store City" = 'Tacoma'