Loop is a join path problem which is a set of joins that defines a closed path through a set of tables
If you model based on the above structure, any query run against the tables in the loop would return only results where the country values for resorts and the country values for customer origin are equivalent. This double restriction on the shared lookup Country table returns fewer rows than expected.
Country is serving two purposes:
This creates a restriction so that data is returned only when the resort country is the same as the customer country. The resulting report shows only the number of visitors from the US who visited resorts in the US.
You can:
Example: with an alias You create an alias for Country and rename it Country_Region. The two “one” ended joins are now separated as follows:
The model now appears as shown below: