MDX Named Sets in SQL Server 2005/2008

An MDX Named Set is a list of members, based on some pre-defined retrieval logic. You may have a named set that lists your Customers in zip code order or products sold for 2005 in sales order amount. Since an MDX Named Set is simply an MDX expression, you could create a more complex Named Set using other MDX functions like DESCENDANTS to build a list of members from a customer geography, starting at a certain level (Region) down to another level (Market).