Circular loop

[#1]

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.

Here is my internal table view: Does anyone know what my issue is?

[Anonymous · Accepted solution]

Try concatenating these 3 tables together :

     Consolidate...

     Resource L...

     Pivot ChartS

[#3]

I believe in your datamodel 3 synthetic keys are present.

1) first synthetic between table  reports by project and efforts by resource .

2) second syn key between  consolidate and resource table

3) third syn key between  pivot chart and resource tab;e

dashed lined represent loosly coupled table

[Anonymous]

Hey,

there are sync tables are generated due to common columns.

If the dimension attributes are already present in your Fact table, you may rename the columns from dimension tables. Try to merge the Dimensions togeather one table where ever synthetic key happening in scripting side.

I think you can merge consolidated and resource table as all the columns seems to be same..to differenciate the data between these 2 tables after merge, you may have a static flag to identify the source data(like flag field will be  C for consolidated and R for resource table).

like wise you can play with other tablesbased on possibility.

Regards,

Chinna

[#5]

Hi,

I can see a lot of problem in your data model in terms of Synthetic Tables and Circular Reference getting formed.

Please remove them to correct your data model.

Hope the below links help !

Circular Reference :  http://floydmatt.com/2011/06/how-to-prevent-circular-reference-in-a-qlikview-data-model-quick-qlear-...

Synthetic Key : http://community.qlik.com/thread/79109

[#6]

you can try

1) concatenating  resource and consolidate table

2) concatenating  effort by resource and reports by projects

[#7]

Thank you I will try to do this now.

[#8]

Thank you for your response, i'll look into these.

[hic]

Read also Circular References.

HIC