Hi @何思达 ,
Welcome to the MS Q&A platform.
In Azure Analysis Services, the source column in each hierarchy level corresponds to the Key Column in cubes dimension attributes when working with tabular models.
Tabular models support multi-level hierarchies. You can create a multi-level hierarchy by adding multiple columns to the hierarchy in the desired order. For example, suppose you have a geography hierarchy with Country, State, and City. In that case, you can create a multi-level hierarchy by adding these columns in the specified order: Country -> State -> City.
To create a multi-level hierarchy:
<copied from the documentation page>
To create a hierarchy, right-click a column you want to specify as the parent level, and then click Create Hierarchy. You can multi-select any number of columns (within a single table) to include, or you can later add columns as child levels by clicking and dragging columns to the parent level. When multiple columns are selected, columns are automatically placed in an order based on cardinality.
This will create a multi-level hierarchy in the tabular model, similar to the multi-level attribute relationships in cubes.
You can refer to the below documentation page on Tabular Model Hierarchies for general guidance. https://video2.skills-academy.com/en-us/analysis-services/tabular-models/hierarchies-ssas-tabular?view=asallproducts-allversions
I hope this helps. Please let me know if you have any further questions.