A dimensional hierarchy must be built within a single dimension table using parent-child relationships or level-based columns. You cannot build a hierarchy across two separate logical dimension tables because hierarchies require all levels to exist in one table with defined relationships.