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?
How will you port changes for dashboards,reports,rpd from development to production?
How online/offline mode impact development and delpoyment?
Have you created hierarchy in obiee. If so where and how?
Can you run multiple rpd’s in a single obiee instance?
What is write-back in obiee ?
What is a table alias in obiee? And where and how will you create it.
What are different types of joins that are possible in obiee rpd?
What are the different log files in obiee?
How many bi services node can be clustered together?
How to hide certain columns from a user?
How will you enable or disable caching in the system level and table level?
How will you do different types of narrative reports in obiee?
What is level based metrics.how will you create it?