Data Warehouse Maintenance, Evolution and Versioning - Data Warehousing Design and Advanced Engineering Applications - page 177

Table 1. Cell data for the example company

Cars sold
2005

Cars sold
2006

Cars sold
2007

All Cars 111 All Cars 145 All Cars 181

BMW 40 BMW 67 BMW&Rolls-Royce 71

BMW 3 30 BMW 1 20 BMW 67

BMW 5 10 BMW 3 35 BMW 1 22

Rolls-Royce 7 BMW 5 12 BMW 3 34

Silver Spirit 3 Rolls-Royce 6 BMW 5 11

Phantom V 4 Silver Spirit II 3 Rolls-Royce 4

Mercedes 44 Phantom V 3 Silver Spirit II 4

C 320 34 Mercedes 49 Daimer-Chrysler 110

CLK 320 10 C 320 38 Mercedes 75

Puch 20 CLK 320 11 C 320 40

Modell G 20 Puch 23 CLK 320 11

Modell G 23 Modell G 24

Chrysler 35

Voyager 35

Figure 2. Example charts for changed structure