LISTING 7: Determining the Top Five Stores 
and the Top Five Customers

select {[Unit Sales]} on COLUMNS,
 Generate( TopCount([Store].[Store Name].Members, 5,
 [Unit Sales]),
 { [Store].CurrentMember } * TopCount( [Customers]
.[Name].Members, 5, ([Unit Sales], 
[Store].CurrentMember) ) ) on ROWS
from Sales