What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
Define repository in terms of OBIEE?
What is scd type 1 and 2.
What is object level security?
Do you know about Initialization Blocks? Can you give me an example where you used them?
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?
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.
Did you create any new logical column in BMM layer, how?
What is a table alias in obiee? And where and how will you create it.
What is the purpose of Alias Tables?
can you change the location of the obiee repository?
If you want to limit the users by the certain region to access only certain data, what would you do?
How online/offline mode impact development and delpoyment?