Listing 1: MDX Code That Puts Measures on Columns
[SELECT]
{ [Measures].[Store Sales] } 
   ON COLUMNS , 
{ Descendants([Product].[All Products],
   [Product].[Product Name], LEAVES) } ON ROWS, 
NON EMPTY { [Time].[Month].Members }
   ON PAGES
FROM [Sales]