Getting [circular] warning while reloading data

[dilip1234]

Hi All,

I am getting one warning because of that my Qlik objects are getting impacted.

I have following tables:

Geo:

LOAD

     GeoDocumentId,

     GeoDocumentDescription,

     GeoName,

     GeographicKey AS GEOKEY;

Zone:

LOAD

     ZoneDocumentId,

     ZoneDocumentDescription,

     ZoneName,

     ZoneKey AS ZoneKEY;

City:

LOAD

     CityDocumentId,

     CityDocumentDescription,

     CityName,

     CityGraphicKey AS CITYKEY;

CMM_Permission:

LOAD

     ACCESS,

     USERID,

     GEOKEY,

     ZONEKEY,

     CITYKEY;

SQL EXECUTE Get_CMM_UserPermissions;

After loading data I am getting following error:

Can anyone suggest that why I am getting this and how to get rid of this?

Thanks

Dilip Solanki

[sunny_talwar]

Read about this here

Circular References

[dilip1234]

Hi Sunny,

Thanks for the answer. I got the cause of circular reference. But I have to give same name to my column in CMM_Permission table, as this table I am using for Section access.

For section access I have to specify column right, to define the reduction column.

Can you suggest me how to resolve this, with section access.

Thanks

Dilip Solanki

[sunny_talwar]

In this script... I don't see any circular reference problem...

Geo:

LOAD

     GeoDocumentId,

     GeoDocumentDescription,

     GeoName,

     GeographicKey AS GEOKEY;

Zone:

LOAD

     ZoneDocumentId,

     ZoneDocumentDescription,

     ZoneName,

     ZoneKey AS ZoneKEY;

City:

LOAD

     CityDocumentId,

     CityDocumentDescription,

     CityName,

     CityGraphicKey AS CITYKEY;

CMM_Permission:

LOAD

     ACCESS,

     USERID,

     GEOKEY,

     ZONEKEY,

     CITYKEY;

SQL EXECUTE Get_CMM_UserPermissions;

Is this the complete script? or are you accidentally running more script then this?

[dilip1234]

Yes this is complete script. I do not have any other script. I have only these 4 tables Geo, Zone, City and CMM_Permission.

[sunny_talwar]

Can you post an image of your data model after the reload?