MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 24: Multidimensional Expressions
The need to query on property values frequently arises in practical situations. The Products dimension has a list of various kinds of apparel that are sold at a retail store chain. Suppose that the [Product Name] level of the Products dimension had three properties associated with it: Color, Type, and [Age Group].
To find the sales for children's red T-shirts (=Type), use the following MDX statement:
SELECT [Measures].[Sales] ON COLUMNS,
Filter(Product.MEMBERS, ([Product Name].[Color] = "Red" AND
[Product Name].[Age Group] = "Children" AND
[Product Name].[Type] = "Tshirt")) ON ROWS
FROM ...
In general, property[.VALUE] is a value expression primary and can be used anywhere a value expression can be used, including most set value expressions and numeric functions.