Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
INF: MDX: How to Query for the 10 Best Customers and the Top 5 Products for Each Customer
Article ID: 304386 - View products that this article applies to.
This article was previously published under Q304386
A common question for any business is "Who are our 10 best customers and what are the 5 top products they purchase"? This article shows you how to use a Multidimensional expression (MDX) query, which answers the preceding question, by using a Named Set.
The following is a sample query against the FoodMart 2000 database that is provided with Microsoft Analysis Services 2000. You can run the following query in the MDX sample application that is also provided with Analysis Services.
REFERENCESFor more information about the Generate, CrossJoin, and TopCount MDX functions as well as Named Sets, refer to Microsoft SQL Server 2000 Books Online.
Article ID: 304386 - Last Review: February 21, 2007 - Revision: 2.2