July MDX Puzzle - 13 Jun 2000

How would you write a query on the FoodMart 2000 Sales cube that returns the unit sales? Put the four quarters of 1997 on the columns; on the rows, put the stores that have more unit sales than the average warehouse sales of all warehouses. Remember that the Sales cube has no warehouse sales measure; the warehouse sales figure comes from the Warehouse cube. (Don't cheat and use the warehouse and sales virtual cube.) Hint: This feature is new to SQL Server 2000 Analysis Services.