If you want to limit the users by the certain region to access only certain data, what would you do?



If you want to limit the users by the certain region to access only certain data, what would you do?..

Answer / madhu

Using data level security.
In the Admin tool: go to Manage -> Security in left hand pane u will find the user, groups, LDAP server, Hierarchy
What you can do is select the user and right click and go to properties, you will find two tabs named as users and logon, go to user tab and click at permission button in front of user name you have selected as soon as u click at permission you will get a new window with user group permission having three tabs named as general ,query limits and filter and you can specify your condition at filter tab, in which you can select presentation table ,presentation columns ,logical table and logical columns where you can apply the condition according to your requirement for the selected user or groups.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More OBIEE Interview Questions

What is the purpose of Alias Tables?

1 Answers  


How analytics process your request when you create your requests?

0 Answers  


What is a table alias in obiee? And where and how will you create it.

0 Answers  


What is the difference between Data Level Security and Object Level Security?

1 Answers  


What are the key configuration files in obiee?

0 Answers  






What you will do when your report is not fetching right data?

0 Answers  


If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 Answers  


Have you created hierarchy in obiee. If so where and how?

0 Answers  


How to hide certain columns from a user?

0 Answers  


What are the different log files in obiee?

0 Answers  


We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?

1 Answers  


What is data level security?

1 Answers  


Categories