Discussion Board for collaboration related to QlikView App Development.
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??
Go to Solution.
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.
This may help u:
Authorization using a Hierarchy
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.