topic Re: Section Access in Team level with multiple field in QlikView

Section Access in Team level with multiple field

anindya_manna — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Section Access in Team level with multiple field

jmvilaplanap — Wed, 09 May 2018 14:20:06 GMT

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

Re: Section Access in Team level with multiple field

datanibbler — Wed, 09 May 2018 14:20:41 GMT

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‌

Re: Section Access in Team level with multiple field

vishalarote — Thu, 10 May 2018 11:41:29 GMT

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

];