I'm currently exploring to implement Data Level Security in OBIEE 12c ( 12.2.1.4.0 ) .
Scenario I'm Working on : Lets assume I have created 2 users and assigned them Administrator Role . Now I have to Filter out data for users based on the requirements I have . For Example , User 1 can view data related to city -New York and User 2 can view all data related to every city other than New York .
Kindly refer the below Steps I have tried to Implement Data Level Security :
Step 1 : After Completing Data Model , I connected the RPD to Online .
Step 2 : Went to Identity Manager ( Manage -> Identity ) .
Step 3 : Synchronize Application Roles .
Step 4 : Selected the User to which Data Level Security need to be Implemented .
Step 5 : Clicked the " Permission " of the Particular User .
Step 6 : Selected the " Data Filters " Tab and selected the Object .
Challenge I'm Facing : To filter the Data for the User ( Data Filter Column ) / How to write the Expression for Data Filter Column? . If it's the Final Step or much more need to be done ?
These are the Steps I have tried . If it's not in the way it should be done please mention how it should be done , Much Appreciated.
Thanks in Advance .