topic Re: Circular loop in QlikView

Circular loop

Fri, 07 Nov 2014 16:28:27 GMT

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?

Re: Circular loop

Anonymous — Fri, 07 Nov 2014 16:37:52 GMT

Try concatenating these 3 tables together :

Consolidate...

Resource L...

Pivot ChartS

Re: Circular loop

Fri, 07 Nov 2014 16:43:22 GMT

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

Re: Circular loop

Anonymous — Fri, 07 Nov 2014 16:44:58 GMT

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

Re: Circular loop

Fri, 07 Nov 2014 16:45:23 GMT

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-qool/

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

Re: Circular loop

Fri, 07 Nov 2014 16:46:33 GMT

you can try

1) concatenating resource and consolidate table

2) concatenating effort by resource and reports by projects

Re: Circular loop

Fri, 07 Nov 2014 16:47:18 GMT

Thank you I will try to do this now.

Re: Circular loop

Fri, 07 Nov 2014 16:47:31 GMT

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

Re: Circular loop

hic — Mon, 10 Nov 2014 12:23:45 GMT