You worked on standalone or integrated system?
Can you use physical join in BMM layer?
How the users created differs from rpd/answers/dashboards level?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
Do you know about Initialization Blocks? Can you give me an example where you used them?
Why do we have multiple LTS in BMM layer? What is the purpose?
How will you create report from two subject areas
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
How will you create interactive dashboards ?
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?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
How will you execute direct sql in obiee?