topic Re: Re: Need help on Section Access with Hierarchybelongsto in QlikView

Need help on Section Access

avinashelite — Wed, 08 Oct 2014 14:53:39 GMT

Hi Friends,

Requirement: We have employee ID's and their Managers ID's, when the Manager login he should see that data related to him and his reporting employees but when Employee login he should see only his details.

To achieve this I am using section access and Hierarchybelongsto function in script but not able to get the result.

Please see the attachment for Data and qvw file.

Give USERID as 1 or 2 or 3 or 4.

Re: Need help on Section Access with Hierarchybelongsto

avinashelite — Thu, 09 Oct 2014 04:54:41 GMT

Can any one help on this??

Re: Need help on Section Access with Hierarchybelongsto

tresB — Thu, 09 Oct 2014 04:58:28 GMT

See: hierarchy-authorization

Re: Need help on Section Access with Hierarchybelongsto

avinashelite — Thu, 09 Oct 2014 06:05:42 GMT

Hi tresesco

I tried with that but its not working in my scenario. I need to implement section access on Employee Tree, so that the employee can see his details and this reporting employee details. Can you please help on this.

Re: Need help on Section Access with Hierarchybelongsto

tresB — Thu, 09 Oct 2014 06:19:46 GMT

Try to follow the steps shown in the blog and prepare a sample qvw with that and share here. That would help us understand your issue and could help accordingly.

Re: Re: Need help on Section Access with Hierarchybelongsto

avinashelite — Thu, 09 Oct 2014 06:33:29 GMT

Hi tresesco,

Thanks a lot for the response, I have followed all the steps according to the Blog Post you specified but when i login as manger i.e. is with USERID 1 its showing only details of USERID 1, its not showing the details of his Reportees i.e the employees who are working under him.

Please find the attachment for Data and qvw file.

Please use USERID as 1,2,3,4,5 . When 1 login in he should see the details of 1,2 and 5

similarly when 2 login he show see data of 2,3,4 and when 4 login he should see details of 4 only.

Re: Re: Need help on Section Access with Hierarchybelongsto

avinashelite — Thu, 09 Oct 2014 09:31:15 GMT

Hi tresesco,

Any inputs on the above issue??

Re: Re: Re: Need help on Section Access with Hierarchybelongsto

Anonymous — Thu, 09 Oct 2014 10:15:58 GMT

Hi,

see attached qvw.

Hope this helps.

Best regards

Stefan

Re: Re: Re: Need help on Section Access with Hierarchybelongsto

tresB — Thu, 09 Oct 2014 10:42:21 GMT

PFA

SECTION Access;
LOAD Upper(ACCESS) as ACCESS,
USERID,
Upper(Supervisor_id) as PERMISSION // This authorisation field been added here
FROM
Sheet level section access.xlsx
(ooxml, embedded labels, table is Sheet1);

SECTION Application; // Heirarchy making comes under section application
THierarchy:

HierarchyBelongsTo(USERID,Supervisor_id,Name,AncestorID,AncestorName)

Load * Inline [
USERID,Name,Supervisor_id
1,A,0
2,B,1
3,C,2
4,D,2
5,E,1
];

Hierarchy:
Load
Name as NAME,
//USERID,
AncestorID,
Upper(AncestorID) as PERMISSION

Resident THierarchy;
DROP Table THierarchy;

Fact:
load * inline
[
NAME,SALARY,PROJECT
A,10000,QA
B,40000,QIS
C,25000,QCT
D,30000,SFDC
E,45000,LMS
];

Re: Need help on Section Access with Hierarchybelongsto

avinashelite — Thu, 09 Oct 2014 11:10:14 GMT

Hi tresesco

Thanks a lot for the quick response, my requirement is

when a certain employee logs in, he should only see this own tree (his own data and down)

BUT he shouldn't see any facts on the upper nodes in the tree. But in your app file its showing all the data.

When user 1 login I am able to see all the data this is fine, but when 2 login still its showing all the data??

he is the manager for C and D . so he should see only this data and c and D 's data not his managers data.

Re: Need help on Section Access with Hierarchybelongsto

Anonymous — Thu, 09 Oct 2014 11:30:16 GMT

see my post for a possible soution

Best

Stefan

Re: Need help on Section Access with Hierarchybelongsto

avinashelite — Thu, 09 Oct 2014 11:49:39 GMT

Hi Stefan,

Thanks a lot for your time, but my requirement is different!! based on the login i need to reduce the data.

Re: Re: Need help on Section Access with Hierarchybelongsto

tresB — Thu, 09 Oct 2014 11:55:35 GMT

In that case, try:

SECTION Access;

LOAD Upper(ACCESS) as ACCESS,

USERID,

Upper(USERID) as PERMISSION

PFA

Re: Re: Need help on Section Access with Hierarchybelongsto

Anonymous — Thu, 09 Oct 2014 12:00:46 GMT

Hi,

i didn't apply section access, did only the table structure. see this qvw for applied sa.

Best

Stefan

Re: Need help on Section Access with Hierarchybelongsto

avinashelite — Thu, 09 Oct 2014 12:05:10 GMT

thanks a lot tresesco it works fine..Thanks a lot for your valuable time

Re: Need help on Section Access with Hierarchybelongsto

avinashelite — Thu, 09 Oct 2014 12:13:51 GMT

Hi Stefan Kunte

This works too..Thanks a lot for your help