What is level based metrics.how will you create it?
Can you bypass siebel analytics server security ?if so how?
What are the different types of security you have worked in obiee?
Can you migrate the presentation layer to a different server.
What is scd type 1 and 2.
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?
From where u get the logical query of your request?
What is star schema and snowflake schema?
What is logging level? Where can you set logging levels?
How will you create report from two subject areas
What is complex join, and where it is used?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
Do you know about Initialization Blocks? Can you give me an example where you used them?