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.