Can we have Circular Reference between Section Access and Section Application table(s)?

krishPal24 — Mon, 13 Aug 2018 09:07:38 GMT

Hi Friends,

I would need some help to understand what happens while having Circular Reference between Section Access table and Section Application Table. I am also doing data reduction and using DMS Authorization(which may not matter here). But to my surprise, this is behaving differently for same user configuration, each time.

To be precise, I have exactly similar requirement as scripted below. But for some reason, my Product list is very huge, so I can't build compound key of Customer and Product in my data model.

I know QV tries to break the circular reference by making some tables loosely coupled. But at times data reduction is not working completely. So I just want to understand what is happening exactly on this case.

Section Access;

Security: //IS_EXTERNAL_USER field tells if the user is external(outside domain), for them only few products are shown

LOAD * Inline [

NTNAME,CUSTOMERID,IS_EXTERNAL_USER

ABCD,C1,0

BCDE,C2,0

CDEF,C1,1

DEFG,C3,1

];

SECTION Application;

Fact:

LOAD * Inline [

Date,Customer,Product,SoldAmount

01/01/2010,Cust1,Prod1,120

01/02/2010,Cust3,Prod2,415

01/02/2010,Cust2,Prod3,150

01/03/2010,Cust1,Prod4,155

];

Exclusive_Products_External: //this means, only products which are listed here will be shown to External users

LOAD * Inline [

IS_EXTERNAL_USER,Product

1,Prod1

1,Prod2

];

Customer:

LOAD * Inline [

CUSTOMERID,Customer

C1,Cust1

C2,Cust2

C3,Cust3

];

Any explanation is appreciated!

Thanks!

Krishna.

topic Can we have Circular Reference between Section Access and Section Application table(s)? in QlikView

Can we have Circular Reference between Section Access and Section Application table(s)?