Section access with hierarchy

[sujit_nath]

 There is a table in data with hierarchy such that.. Manager | Team Lead | Employee

I want to create section access such that Employee should only see employee data, Tead Lead should see Team Lead Data and Employee Data, and Manager should see all the data.

[asinha1991 · Accepted solution]

can you share example of dataset?

I need to understand what is employee data and team lead data.

are you trying to implement hierarchy such that a manager should see data related to all his direct/indirect hierarchy? simlarly for team lead , and employee should see only his data?

if that's the case then you will have to maintain a hierarchy table and while creating section access identify all employees that either report to that person or reports to someone who reports to that person, add all those employeeids in your section access reduce field.

I am assuming you have a role playing dimension employeeid that stores manager, teamlead and employees

[jeeva3095]

Hi Sujit,

Have you implemented the section access?

I need to implement the same in my report. Kindly help to implement.

Thanks,

Jeeva