Querying on Property Values

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 being 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 hence can be used anywhere a value expression can be used, including most set value expressions and numeric functions.