If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
How we are going to decide which schema we are going to implement in the data warehouse?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
Explain the architecture of obiee and what each components do?
You worked on standalone or integrated system?
What are the different types of variables in obiee 11g? Explain
What are different types of variables?
Did you create any new logical column in BMM layer, how?
What are the major challenges you faced while creating the rpd?
What is star schema and snowflake schema?
What are global filter and how they differ from column filter?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?