Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @Adiuser,
No. As there is no mapping relationship between region and city, it is not possible to determine current city belongs to which region. It is not possible to create hierarchy on unrelated tables. In your scenario, you have to create an extra table to list the mapping rule between region and city.
Regards,
Yuliana Gu
Hi @Adiuser,
No. As there is no mapping relationship between region and city, it is not possible to determine current city belongs to which region. It is not possible to create hierarchy on unrelated tables. In your scenario, you have to create an extra table to list the mapping rule between region and city.
Regards,
Yuliana Gu
Agree. Thank you !
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |