Thu Jun 2 2005

1
Thu Jun 2 2005
FoodMart 2000 OLAP Queries long version
2
Unit Sales by Promotion Media Type Subheading
3
Units Shipped and Ordered by Store Subheading
Store Units Shipped Units Ordered Store
6 10,759 11,699 Store 7 24,587 26,463 Store
24 23,835 26,270 Store 14 1,696 1,875 Store
11 8,515 9,109 Store 13 32,393 35,797 Store
2 2,348 2,454 Store 3 22,734 24,610 Store
15 24,110 26,703 Store 16 11,889 12,828 Store
17 32,411 35,930 Store 22 1,860 2,074 Store
23 10,589 11,426
4
Store Sales (last period) by Department Subheading
5
Accumulated Sales by Product Department
6
Costs and Profit Rate by Product Department
7
Percent of Alcoholic Drinks Subheading
8
Sales and Accumulated Sales by Month (1997)
9
Sales and Accumulated Sales by Month (1997)
10
Ranked top 10 first-level managers Subheading
11
Topcount Example Subheading
12
Descendents example Subheading
13
Store Profit for the first quarter of each year
14
Sales of a Product Brand as a percentage of the
sales of that product within its subcategory
15
Percentage of sales for top 10 promotion compared
only to other promotions
16
Sales Growth Over Time Subheading
17
Monthly Year-to-Date Sales for each product
category in 1997
18
Store Sales Profit for those whose unit sales
exceed 25,000 in 1997 for each city based
against the store type
19
Top Dozen Stores by Sales Count
20
Sales Measures for cities whose sales count
accounts for 50 percent of all the sales
21
Unit Sales and Customer Count by product category
22
Unit Sales and Percent of States Sales by store
23
Percentage Profit for States months 1997
24
Aggregated Store Sqft Member Property Subheading
25
Top Store Costs by City Subheading
26
Store Sales by Month with /- 3 St.Dev. Control
27
Store Sales Growth by Product Month-to-Month 1997