Listing A: Code That Creates Two Sets to Solve June's Puzzle
WITH
  SET [Top Products] AS 'TOPCOUNT( [Product Name].Members, 5, [Store Sales] )'
  SET [Top Categories] AS 'GENERATE( [Top Products], { Ancestor( [Product].
     CURRENTMEMBER, [Product Category] ) } )'
SELECT { [Store Sales] } ON COLUMNS,
  [Top Categories] ON ROWS
FROM Sales