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 |
What is the purpose of Alias Tables?
How analytics process your request when you create your requests?
What is a table alias in obiee? And where and how will you create it.
What is the difference between Data Level Security and Object Level Security?
What are the key configuration files in obiee?
What you will do when your report is not fetching right data?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
Have you created hierarchy in obiee. If so where and how?
How to hide certain columns from a user?
What are the different log files in obiee?
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?
What is data level security?