An alternate hierarchy is based upon an existing “primary” hierarchy but has alternate levels in the dimension. In Table 1, the primary levels are in the four left columns, and the alternate levels are in the two right columns.
Table 1. Alternate Hierarchy
Prod Code | Prod Alias | Gen_01 | Gen_02 | Alt_Gen_01 | Alt_Gen_02 |
|---|
100-10 | Cola | Cola vs. Non-cola | Colas | Regular vs. Diet | Regular |
100-20 | Diet Cola | Cola vs. Non-cola | Colas | Regular vs. Diet | Diet |
100-30 | Decaf Cola | Cola vs. Non-cola | Colas | Regular vs. Diet | Regular |
200-10 | Vanilla | Cola vs. Non-cola | Non-colas | Regular vs. Diet | Regular |
200-20 | Diet Vanilla | Cola vs. Non-cola | Non-colas | Regular vs. Diet | Diet |
200-30 | Cream | Cola vs. Non-cola | Non-colas | Regular vs. Diet | Regular |
200-40 | Diet Cream | Cola vs. Non-cola | Non-colas | Regular vs. Diet | Diet |
400-10 | Grape | Cola vs. Non-cola | Fruit Sodas | Regular vs. Diet | Regular |
400-20 | Diet Grape | Cola vs. Non-cola | Fruit Sodas | Regular vs. Diet | Diet |
400-30 | Orange | Cola vs. Non-cola | Fruit Sodas | Regular vs. Diet | Regular |
400-40 | Diet Orange | Cola vs. Non-cola | Fruit Sodas | Regular vs. Diet | Diet |