Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
kgarvind
Partner - Contributor
Partner - Contributor

Section Access for Multiple Tables

Hi

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.

1 Reply
sundarakumar
Specialist II
Specialist II

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