Databases Reference
In-Depth Information
In the following screenshot you can see how the vehicle totals are correct because
the vehicle dimension has already been calculated:
Qtr 1 2009
Jan 2009
Feb 2009
Mar 2009
Sporty
Reserved
4000
5000
9000
300
7800
8100
4000
5000
9000
0
0
2 Door Sedan
0
Functional
Flashy
750
1350
2100
4000
5000
9000
750
1350
2100
0
0
4 Door Sedan
0
Worker
Player
4X2 Pickup
12500
350
12850
750
1350
2100
12500
350
12850
0
0
0
Muddog
Climber
4X4 Pickup
300
7800
8100
4000
5000
9000
300
7800
8100
0
0
0
Total Vehicles
32050
28200
32050
0
Now that we have the sales rolled up in the vehicle dimension, we can now calculate
the
Calendar Periods
dimension which will roll up the values of the months to the
quarters, and then to the years. Can you imagine how the numbers would look if we
rolled up the
Calendar Periods
dimension first?
Qtr 1 2009
Jan 2009
Feb 2009
Mar 2009
Sporty
Reserved
4000
5000
9000
300
7800
8100
4000
5000
9000
8300
17800
26100
2 Door Sedan
Functional
Flashy
750
1350
2100
4000
5000
9000
750
1350
2100
5500
7700
13200
4 Door Sedan
Worker
Player
4X2 Pickup
12500
350
12850
750
1350
2100
12500
350
12850
25750
2050
27800
Muddog
Climber
4X4 Pickup
300
7800
8100
4000
5000
9000
300
7800
8100
4600
20600
25200
Total Vehicles
32050
28200
32050
92300
