What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
How we are going to decide which schema we are going to implement in the data warehouse?
How will you execute direct sql in obiee?
What is write-back in obiee ?
What is a table alias in obiee? And where and how will you create it.
What is connection pool and how many connection pools did you have in your last project?
What is Authentication? How many types of authentication do we have in OBIEE?
What are different types of variables?
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.
How will you enable or disable caching in the system level and table level?
How do you implement security using External Tables and LDAP?
How will you do sort in reports in obiee.
What is the difference between Data Level Security and Object Level Security?