Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Section Access in Team level with multiple field

Hello Experts,

I have a table with the team hierarchy Manger-Whole seller-Rep.I can implement section access in a single field.But I want to implement this in Manger-Whole seller-Rep fields.Whenever a user logs in as per its position he can view data below his hierarchy.Whenever manager log in he can see data of all his reportee.For Rep they can only view his own data.

Please help me.

Tags (1)
3 Replies
Highlighted
Specialist
Specialist

Re: Section Access in Team level with multiple field

Hi,

I think you can create a section access table with all the logins and later a login-group table.

For example, the employee 1 has access to group 1, the employee 2 to group 2 and the manager 1 has access to group 1 and 2.

I think it´s easy to do.

Regards

Highlighted
Champion
Champion

Re: Section Access in Team level with multiple field

Hi,

[first of all, do you have the Publisher? That would change the possibilities and limitations quite a lot]

in principle, you have the option in SA of reducing data based on some field, like BUKRS, so that people on a certain hierarchy level can only see what they are supposed to see - just what you want.

You need such a field to begin with - so in some way or other you need some field in the qvd's loaded that the SA can use to decide what to show. Do you have such a field or can you have one automatically generated? I suppose there is some name_stamp in every record - you will need the hierarchy in another table so this can be processed to decide, for the person logging in, what is below their level and thus visible for them.

I don't have too much experience with SA myself, but it is quite flexible and I'm sure it can be done.

Best regards,

DataNibbler

P.S.: This document by marcus_sommer explains pretty much everything about SA - https://community.qlik.com/docs/DOC-9039

Highlighted
Partner
Partner

Re: Section Access in Team level with multiple field

Hi Anindya,

Jose is Right Manager is your admin Whole seller your 1st user and Rep is 2nd one

so Manager access both data, Whole seller access his own data and Rep data

and Rep only access his own data.

maybe this is helpful for you.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD,TEAM

ADMIN,MANEGER,***,MANEGER

USER,WHOLE-SELLER,***,WHOLE-SELLER

USER,REP,***,REP

];

Section Application;

load *,

Upper(Team) as TEAM

Inline [

Team

Maneger

Whole-Seller

Rep

];