Getting Waring/error "One or more loops have been detected in your database structure"
Getting below warning Error when reloading data into QVW file.
"One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog."
What could be the reason and how to resolve it?
I think this is due to same field name in 2 dimension tables and these dimension tables joining to fact table.