Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?1 2017
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?1 2071
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?1 1552
Can you have multiple data sources in OBIEE?1 1815
Do you know about Initialization Blocks? Can you give me an example where you used them?1 1658
What is query repository tool?1 2596
Can you migrate the presentation layer to a different server.2 2468
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?1 1669
Why do we have multiple LTS in BMM layer? What is the purpose?1 2978
How do i disable cache for only 2 particular tables?1 1962
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.1 2498
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?1 1693
How to sort columns in rpd and web?2 3373
You worked on standalone or integrated system?1 2039
What is clusterservices in obiee ? Why its used?
What is star schema and snowflake schema?
What is a table alias in obiee 11g? Where and how will you create it?
What are the different types of security you have worked in obiee?
Explain the architecture of obiee and what each components do?
How will you port changes for dashboards,reports,rpd from development to production?
What are the key configuration files in obiee?
can you change the location of the obiee repository?
How the users created differs from rpd/answers/dashboards level?
what is guided navigation?
How online/offline mode impact development and delpoyment?
What are the major challenges you faced while creating the rpd?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How will you create interactive dashboards ?
How to enable drills in a given column data?