Can parent-child dimensions be supported like SSAS

[PenneyHuang]

The difference between the parent-child dimension and other dimensions is that the data in the dimension is recursively hierarchical. The data in the DimEmployee table in the Adventureworksdw library (hierarchical relationship between superiors and subordinates) is a recursive relationship. The primary key in the table is the EmployeeKey column, which corresponds to the ID of each employee. The ID of the employee's superior is saved in the ParentEmployeeKey column. That is to say, the ParentEmployeeKey and EmployeeKey columns are foreign key relationships