section access with hierarchical data

[kkkumar82]

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

[amit_saini]

Hi Kiran,

This may help u:

Authorization using a Hierarchy

Thanks

AS

[avinashelite]

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

];

[kkkumar82 · Accepted 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.

[murali986]

Sir can you share hide tab script if possible