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

a b

Köln

Berlin

Germany

Lyon

France

Paris

Q1

Q1

Q2

Q2

Q3

Q3

Q4 Q4

Produce Seafood

Produce Seafood

Beverages Condiments

Beverages Condiments

Product (Category)

Product (Category)

c d

Köln

Berlin

Lyon

Köln

Paris

Berlin

Lyon

Jan

Paris

Feb Q1

Mar Q2

... Q3

Dec Q4

Produce Seafood Condiments Seafood

Produce Beverages Beverages

Condiments

Product (Category)

Product (Category)

e

Seafood

Condiments

Produce

Beverages

Paris

Lyon

Berlin

Köln

Q1 Q2 Q3 Q4

Time (Quarter)

Fig. 3.4 OLAP operations. ( a ) Original cube. ( b ) Roll-up to the Country level.
( c ) Drill-down to the Month level. ( d )Sortproductbyname.( e )Pivot