Data Warehouse Concepts - Data Warehouse Systems: Design and Implementation - page 59

f g

Q1

Lyon

Q2

Paris

Q1

Q3

Q2

Q4

Produce Seafood

Produce Seafood

Beverages

Condiments

Beverages

Condiments

Product (Category)

Product (Category)

h i

Köln Köln

Berlin Berlin

Lyon Lyon

Paris Paris

Q1 Q1

Q2 Q2

Q3 Q3

Q4 Q4

Produce Seafood Produce Seafood

Beverages Condiments Beverages Condiments

Product (Category) Product (Category)

j

Köln

Berlin

k

Lyon

Paris

Q1 Q1 84 89 106 84

Q2 Q2 82 77 93 79

Q3 Q3 105 72 65 88

Q4 Q4 112 61 96 102

Produce Seafood Lyon Köln

Beverages Condiments Paris Berlin

Customer (City)

Product (Category)

Fig. 3.4 (continued) ( f ) Slice on City =' Paris '.( g )Diceon City =' Paris ' or ' Lyon ' and
Quarter =' Q1 ' or ' Q2 '.( h ) Cube for 2011. ( i ) Drill-across operation. ( j ) Percentage
change. ( k ) Total sales by quarter and city