topic Re: section access with hierarchical data in QlikView

section access with hierarchical data

kkkumar82 — Wed, 18 Feb 2015 06:42:26 GMT

Hi all,

I have Level3, level2,level1 users in my data and level3 has some level2 under him and level2 has some level1, if a Level3 is accessing I want to implement his , his L2 and L2s L1 data.

for eg if NN logins in I want to implement a section access such that he has to see his(14) ,10 ,11 associated data. I am using hierarchybelongsto but unable to figure out how to map

Authorizationtable -> users table -> bridgetable(hierarchy belongsto) -> fact table

Any help other than hierarchy or hierarchybelongsto??

Thank you

Re: section access with hierarchical data

amit_saini — Wed, 18 Feb 2015 06:48:31 GMT

Hi Kiran,

This may help u:

Authorization using a Hierarchy

Thanks

Re: section access with hierarchical data

avinashelite — Wed, 18 Feb 2015 06:51:44 GMT

Hi Kiran,

Please find the attachment for solution , use 1,2,3,4 and 5 as the userid to log in :

and you can verify the following hierarchy.

USERID,Name,Supervisor_id

1,A,0

2,B,1

3,C,2

4,D,2

5,E,1

];

Re: section access with hierarchical data

kkkumar82 — Wed, 18 Feb 2015 10:58:02 GMT

followed HIC post Authorization using a Hierarchy

finally got the solution by aliasing one of the columns in the fact table for eg user_id as userid and also aliased

ANCESTORS_KEY of bridge table to userid , so able to get association.

Re: section access with hierarchical data

murali986 — Fri, 09 Oct 2020 08:25:24 GMT

Sir can you share hide tab script if possible