What is object level security?
Answer / madhu
There are two types of object level security: Repository level and Web level
Repository level: In presentation layer we can set Repository level security by giving permission or deny permission to users/groups to see particular table or column.
Web level: this provides security for objects stored in the OBIEE web catalog, such as dashboards, dashboards pages, folder, and reports you can only view the objects for which you are authorized. For example, a mid-level manager may not be granted access to a dashboard containing summary information for an entire department.
| Is This Answer Correct ? | 1 Yes | 0 No |
How will you create report from two subject areas
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
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 are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
What are the different types of security you have worked in obiee?
What is authentication? How many types of authentication.
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 will change port of obiee answers?
What is connection pool and how many connection pools did you have in your last project?
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?