topic Re: Getting Waring/error "One or more loops have been detected in your database structure" in QlikView

Getting Waring/error "One or more loops have been detected in your database structure"

Wed, 05 Feb 2014 04:29:13 GMT

Hi Guys,

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.

Re: Getting Waring/error "One or more loops have been detected in your database structure"

Wed, 05 Feb 2014 04:32:49 GMT

Hi,

You are having common fields in more than 2 tables which is making a circular loop. Try to concatenate the two dimension tables in order to remove the loop.

HTH.

-Shruti

Re: Getting Waring/error "One or more loops have been detected in your database structure"

Wed, 05 Feb 2014 06:05:11 GMT

Hi,

This is because a circular loop is created in your tables.

Circular loop :

"A structure in the data model where the keys between at least three tables form a circle."

Try to rename the fields and check

Hope it helps,

Regards,

Divya

Re: Getting Waring/error "One or more loops have been detected in your database structure"

sudeepkm — Wed, 05 Feb 2014 06:14:59 GMT

A good explanation on this can be found in the QlikView Reference Manual

Chapter 14 - Logic and Selections > 14.13 Circular References