We had a request to enable the security at supervisor level in OBIEE.
For example: below is the employee table with hierarchy,
|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