OBIEE Supervisor Employee Security

Question

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 NameSupervisorEric

John

EricBob

JohnAlex

BobRonald

BobChristine

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 · Answer

Check this link might give you some directions

OBIEE GURU: OBIEE Data Level Security - Session Variables