Circular reference on my model

[#1]

Hello,

I was having a Circular Reference problem while creating my data model, then I renamed a field and the warning of this problem just stopped, but when I look at my table viewer both of models seem to have a circular reference.

Can someone explain me why the in second image I have a circular reference and in the first one I don't?

[its_anandrjs]

Hi,

Try to rename the field that create the circular loop or weather check if possible take one of the table in another table by concatenate the tables.

Regards

Anand

[MK_QSL]

Change as below in your load script..

CustomerTable

RETAILER_CODE as RETAILER_CODE1

[its_anandrjs]

Hi,

Another possible ways is

1. Do not use RETAILER_CODE in branch table remove there or rename here in the branch table like

branch:

Load

RETAILER_CODE  as Brach_RETAILER_CODE

From Source;

2.Use RETAILER_CODE  via FullOrdersCognos table no need to keep RETAILER_CODE   in two tables

Regards

Anand

[mukesh24 · Accepted solution]

Hi Cesar,

In Second image having circular reference because assume following scenario:-

Table A --            Table B                 Table C

Key1                   Key1                     Key2 

Key3                   Key2                     Key3

when u link table A with B (Linkage between to suppose Key1)

B Table link with another table C(linkage with Key2)

C automatically link with Table A through Key3

In above case circular reference occure. Same thing happen in your case.

In first Image If you check Synthetic Key occure.

Regards,

Mukesh Chaudhari

[#6]

Thank you Mukesh Chaudhari!!