When logical dimension tables, especially having hierarchies does not have a logical primary key defined, visualizations throws the error: … drilldown levels associated with multiple (likely overlapping) dimensions. And it is really not easy to diagnose the column causing the issue, even if you figure out the column, not easy to guess the solution.
It took enormous effort for me to figure out the reason was not having primary key.
As per this article, it is mandatory to have primary key for logical dimension tables, request dev team to have this validation in consistency checker.
