You worked on standalone or integrated system?
What are global filter and how they differ from column filter?
How analytics process your request when you create your requests?
What is write-back in obiee ?
How will you do sort in reports in obiee.
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?
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?
What is a table alias in obiee 11g? Where and how will you create it?
What are the different types of security you have worked in obiee?
How to enable drills in a given column data?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What are the key configuration files in obiee?
How will you enable or disable caching in the system level and table level?