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 Authentication? How many types of authentication do we have in OBIEE?
How do you work in a multi user environment? What are the steps?
What is object level security?
Can you use physical join in BMM layer?
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?
How will you execute direct sql in obiee?
How will change port of obiee answers?
How we are going to decide which schema we are going to implement in the data warehouse?
Why do we have multiple LTS in BMM layer? What is the purpose?
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?
What is data level security?
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?