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 |
How will you create interactive dashboards ?
What are the key configuration files in obiee?
what is guided navigation?
What is write-back in obiee ?
Can you migrate the presentation layer to a different server.
What is query repository tool?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
How will you do sort in reports in obiee.
What are the things you can do in the BMM layer?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
How to enable drills in a given column data?
What is connection pool and how many connection pools did you have in your last project?