June MDX Puzzle Solution Revealed - 20 Jun 2001

Using the FoodMart 2000 Sales cube, show the products (at the product department level) that make up the top 80 percent of Unit Sales. Then, group the rest of the products in one sibling member labeled Other.

The MDX query in Listing A uses a set called Top Product Depts, which consists of the product departments that make up the top 80 percent of the total Unit Sales. Then, the query creates a calculated member called Other, which is the sum of all Unit Sales for the remaining product departments. Finally, the query selects Top Product Depts and Other on the rows and returns the Unit Sales.