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 4414
How many bi services node can be clustered together?
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 authentication? How many types of authentication.
What you will do when your report is not fetching right data?
Can you run multiple rpd’s in a single obiee instance?
What is scd type 1 and 2.
what is guided navigation?
How will you port changes for dashboards,reports,rpd from development to production?
What is star schema and snowflake schema?
What is time series wizard? When and how do you use it?
How will you execute direct sql in obiee?
What is a table alias in obiee 11g? Where and how will you create it?
What are the major challenges you faced while creating the rpd?
What is write-back in obiee ?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.