A single-chain hierarchy is the simplest of hierarchies. Note that the levels in a hierarchy must come from the same data source; however, the hierarchy can contain levels from physical and logical elements.
Figure 5, Simple single-chain hierarchy is an example of a simple single-chain hierarchy for Market. This hierarchy has two levels. The parent level is the Region column from the Region table in the TBC database. The child level is the State column from the Market table.
Figure 6, Single-chain, multigeneration hierarchy is a single-chain, multigeneration hierarchy, meaning there are more than two levels in the hierarchy. Based on the FoodMart database, the levels in this hierarchy come from the same table. Note that the levels in a multigeneration hierarchy need not come from the same table.
