Define repository in terms of OBIEE?1 1369
What is the end to end life cycle of OBIEE?1 4620
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?1 1792
What is connection pool and how many connection pools did you have in your last project?1 1532
What is the purpose of Alias Tables?1 1218
How do you define the relationship between facts and dimensions in BMM layer?1 1588
Did you create any new logical column in BMM layer, how?1 1247
Can you use physical join in BMM layer?1 2042
Can you use outer join in BMM layer?1 1513
What is level based metrics?1 1257
What is logging level? Where can you set logging levels?1 1142
What are different types of variables?1 1059
What is Authentication? How many types of authentication do we have in OBIEE?1 1253
What is object level security?1 1143
What is data level security?1 1117
How will you do different types of narrative reports in obiee?
How will you enable or disable caching in the system level and table level?
What is a bridge table ?
Can you run multiple rpd’s in a single obiee instance?
What are the challenges you faced while making of reports?
what is guided navigation?
How will change port of obiee answers?
What is authentication? How many types of authentication.
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
What is star schema and snowflake schema?
How will you port changes for dashboards,reports,rpd from development to production?
What are the different layers of obiee repository?
What is a table alias in obiee? And where and how will you create it.
How will you go about adding additional column to the repository in the presentation layer?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.