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 are different types of variables?
What is time series wizard? When and how do you use it?
How do you know which report is hitting which table, either the fact table or the aggregate table?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
What is the purpose of Alias Tables?
Define repository in terms of OBIEE?
What is a table alias in obiee? And where and how will you create it.
What are the key configuration files in obiee?
How we are going to decide which schema we are going to implement in the data warehouse?
What are the things you can do in the BMM layer?
What is authentication? How many types of authentication.
What is level based metrics?