OBIEE Supervisor Employee Security

user13816768

Hi All,

We had a request to enable the security at supervisor level in OBIEE.

For example: below is the employee table with hierarchy,

Employee Name	Supervisor
Eric
John	Eric
Bob	John
Alex	Bob
Ronald	Bob
Christine	Ronald

 

If Eric log in to OBIEE, he has to see the details of John, Bob, alex, ronald & Christine.

If John log in to OBIEE, he has to see the details of Bob, Alex, Ronald & Christine.

If Ronald log in to OBIEE, he has to see the details only for Christine. Can we achieve this by using parent and child hierarchy?  Please help

Thanks

SriniVEERAVALLI

Check this link might give you some directions

OBIEE GURU: OBIEE Data Level Security - Session Variables