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 scd type 1 and 2.
How many bi services node can be clustered together?
What is complex join, and where it is used?
Why do we have multiple LTS in BMM layer? What is the purpose?
How do you know which report is hitting which table, either the fact table or the aggregate table?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
can you change the location of the obiee repository?
From where u get the logical query of your request?
What are the challenges you faced while making of reports?
What is authentication? How many types of authentication.
Did you create any new logical column in BMM layer, how?
Can you use outer join in BMM layer?