Can you use physical join in BMM layer?
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 do you know which report is hitting which table, either the fact table or the aggregate table?
What are the different log files in obiee?
Why do we have multiple LTS in BMM layer? What is the purpose?
Define repository in terms of OBIEE?
Define pipeline. Did you use it in your projects?
What is a bridge table ?
How to get sql from obiee for reports?
What is logging level? Where can you set logging levels?
What is a table alias in obiee 11g? Where and how will you create it?
How do implement event polling table?
Did you create any new logical column in BMM layer, how?