Michael Barry on 06 Sep 2023 20:45:44
To keep an efficient and logical structure to the data model, it would be ideal to be able to create hierarchies that are built based on columns from separate related tables rather than requiring all columns used in a hierarchy to sit on a single table.
For example, if we have a 'Stores' table, each store resides in a city, county and state. If we want a pre-built hierarchy state=>county=>city, those three columns need to sit directly on the Stores table. Rather the preferred design is that we have separate tables with a relationship from the 'Store' table to the 'City' table (via 'Store'[City]) to the 'County' table to the 'State' table.