In a semantic layer, a join path is a series of joins that a semantic query can use to access data in the tables linked by the joins.
Join Path problems
Join Path problems can arise from the limited way that lookup and fact tables are related in a relational database. The three major join path problems that you encounter when designing a model are the following:
Most join path problems can be solved by creating an alias