
5.4
Dimension Objects and Performance 125
Chapter 5
5.4 Dimension Objects and Performance
When attempting to demonstrate performance improvements using
dimensional object hierarchies, we should first reiterate the list of benefits
described earlier in this chapter. These are the reasons why dimensional
hierarchies should be used in data warehouses:
Easily understandable structure
Easy access to granularity
Easy application of aggregation
Obvious connections between hierarchical levels
Drill down
Improved performance
One of the easiest types of structures to demonstrate multiple dimen-
sional hierarchies is that of time. Figure 5.9 sho