LISTING 1: Code That Creates the FoodDrink Member

WITH member [Product].[FoodDrink] as '[Food]+[Drink]'
  member [Store].[CAOR] as '[CA]+[OR]'
SELECT {[Food], [Drink], [FoodDrink] } on Columns,
  { [CA], [OR], [CAOR]} on Rows
FROM Sales
WHERE ([Unit Sales], [1997])