Problem: This market-basket analysis problem isn't for the faint of heart. Use the FoodMart 2000 Sales cube to determine which 10 non-beer products customers purchased most frequently in the same transaction with beer products. For this problem, I define a transaction as a unique combination of a customer, a store, and a month. Be careful with this one: If you write your query inefficiently, you might have Analysis Services looking for the answer overnight.

Format...