How will you enable or disable caching in the system level and table level?
Have you created hierarchy in obiee. If so where and how?
What is a bridge table ?
What is star schema and snowflake schema?
How to enable drills in a given column data?
can you change the location of the obiee repository?
How the users created differs from rpd/answers/dashboards level?
How will you execute direct sql in obiee?
What is write-back in obiee ?
How will you port changes for dashboards,reports,rpd from development to production?
What are the different log files in obiee?
What are the major challenges you faced while creating the rpd?
How we are going to decide which schema we are going to implement in the data warehouse?
What is time series wizard? When and how do you use it?
What is a table alias in obiee? And where and how will you create it.