LISTING 2: Determining Top 10 Product Categories

select {[Unit Sales]} on COLUMNS,
  TopCount( [Product].[Product Category].Members,
 10, ([Unit Sales]) ) on ROWS
from Sales