Listing 3: MDX Statement That Returns Beer and Wine Sales and Cost by Month
SELECT 
{ [Measures].[Store Sales],[Measures]
   .[Store Cost] } ON ROWS , 
{ [Product].[Product Category].[Beer 
   and Wine] } ON COLUMNS,
NON EMPTY { [Time].[Month].Members }
   ON PAGES
FROM [Sales]