Section Access for Multiple Tables

kgarvind — Sun, 22 Jun 2014 04:37:02 GMT

I have a set of tables Company / Contact / Order / Employee / +5 More tables.

Each user (employee ) has access to a set of records

Employee
USER	DESIGNATION	NTNAME
JACK	MANAGER	DMN\JACK
DAVE	USER	DMN\DAVE
JOHN	SUPERVISOR	DMN\JOHN

Company_Access:
USER	COMPANY_ID
JACK	XX1
JACK	XX2
JACK	XX3
JACK	XX4
JACK	XX5
DAVE	XX1
DAVE	XX2
JOHN	XX3
JOHN	XX4
JOHN	XX5

Contact_Access:
USER	CONTACT_ID
JACK	YY1
JACK	YY2
JACK	YY3
JACK	YY4
JACK	YY5
DAVE	YY1
DAVE	YY2
DAVE	YY3
DAVE	YY4
JOHN	YY1
JOHN	YY2
JOHN	YY3
JOHN	YY5
JOHN	YY100

ORDER_Access:
USER	ORDER_ID
JACK	OR1
JACK	OR2
JACK	OR3
JACK	Or4
JACK	OR5
DAVE	OR1
DAVE	OR2
JOHN	OR3
JOHN	OR4
JOHN	OR5

SECTION Access;

SecureAccess:

LOAD

NTNAME,

[USER],

EMPLOYEE_ID,

COMPANY_ID,

// CONTACT_ID,

// ORDER_ID

FROM C:\SecureAccess.qvd (qvd) where 1=1;

When I apply this section access – the user gets what he is entitled.

However

Problem 1 –

- The contacts / orders (atleast associated contact with the filtered companies / orders with that companies) are not being shown. They show blank

Problem 2 –

- If I enable the Associated Section Access for Contact_ID & Order_ID as well
- Some cases it shows everything or nothing

What am I missing / doing wrong

Any help is appreciated.

Re: Section Access for Multiple Tables

sundarakumar — Sun, 22 Jun 2014 05:17:37 GMT

I think this is a problem with strict exclusion. this option is available in the document properties where u enabled section access.

u filter the access with the employee id , then y would u again use company id.

As u r saying everything is blank, I guess this should be strict exclusion. try unchecking it. then u will see all data if u have restricted it by conflicting fields.

By conflicting fields I mean for eg, u restrict data by employee id and company name. say an employee aaa belong to company xxx. and u have in section access table like

user comany

aaa yyy

this is where the strict exclusion will remove all the data and show a blank. pls use only the field that would be used as a filter in the section access. let this be at the lowest granularity that u would implement section access on.

Pls attach an sample app so that we could assign u more.

Regards,

Sundar

topic Section Access for Multiple Tables in QlikView

Section Access for Multiple Tables

Re: Section Access for Multiple Tables