SELECT {[Product].[All Products]} ON COLUMNS, {[Measures].[Sales]} ON ROWS FROM [Sales_MDX1] SELECT {[Measures].[Sales]} ON COLUMNS, {[Product].[All Products]} ON ROWS FROM [Sales_MDX1] SELECT {[Measures].[Sales]} ON COLUMNS, {[Product].[All Products].[Food], [Product].[All Products].[Drink], [Product].[All Products].[Non-Consumable]} ON ROWS FROM [Sales_MDX1] SELECT {[Measures].[Sales]} ON COLUMNS, {[Product].[Product Family].[Food].[Baked Goods], [Product].[Product Family].[Food].[Baking Goods], [Product].[Product Family].[Food].[Breakfast Foods], [Product].[Product Family].[Food].[Canned Foods], [Product].[Product Family].[Food].[Canned Products], [Product].[Product Family].[Food].[Dairy], [Product].[Product Family].[Food].[Deli], [Product].[Product Family].[Food].[Eggs], [Product].[Product Family].[Food].[Frozen Foods], [Product].[Product Family].[Food].[Meat], [Product].[Product Family].[Food].[Produce], [Product].[Product Family].[Food].[Seafood], [Product].[Product Family].[Food].[Snack Foods], [Product].[Product Family].[Food].[Snacks], [Product].[Product Family].[Food].[Starchy Foods]} ON ROWS FROM [Sales_MDX1] SELECT {[Measures].[Sales]} ON COLUMNS, {[Product].[All Products].[Food].Children} ON ROWS FROM [Sales_MDX1] SELECT {[Customers].[All Customers]} ON COLUMNS, {[Product].[All Products].Children} ON ROWS FROM [Sales_MDX1] SELECT {[Customers].[All Customers].[USA].Children} ON COLUMNS , {[Product].[All Products].Children} ON ROWS FROM [Sales_MDX1] SELECT {[Customers].[All Customers].[USA].Children} ON COLUMNS, {[Product].[All Products].Children} ON ROWS FROM [Sales_MDX1] WHERE ([Measures].[Sales]) SELECT {[Customers].[All Customers].[USA].Children} ON COLUMNS , {[Product].[All Products].Children} ON ROWS FROM [Sales_MDX1] WHERE ([Measures].[Sales], [Time].[1998]) SELECT {[Customers].[All Customers].[USA].Children} ON COLUMNS , {[Product].[All Products].Children} ON ROWS FROM [Sales_MDX1] WHERE ([Measures].[Sales], [Time].[1998].[Q1])