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 enable or disable caching in the system level and table level?
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?
Can you have multiple data sources in OBIEE?
What is star schema and snowflake schema?
What is complex join, and where it is used?
What are the different log files in obiee?
How to enable drills in a given column data?
What is authentication? How many types of authentication.
Why do we have multiple LTS in BMM layer? What is the purpose?
How to hide certain columns from a user?
How analytics process your request when you create your requests?
Can you use physical join in BMM layer?