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 3425
Can you run multiple rpd’s in a single obiee instance?
can you change the location of the obiee repository?
How will you execute direct sql in obiee?
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?
How will you enable or disable caching in the system level and table level?
What are the different types of variables in obiee 11g? Explain
What is authentication? How many types of authentication.
How to enable drills in a given column data?
What is star schema and snowflake schema?
How will you do sort in reports in obiee.
From where u get the logical query of your request?
How to startup obiee in linux?
What is clusterservices in obiee ? Why its used?
How will you create interactive dashboards ?