OBIEE 11G - Interview Questions for Experienced Professional

OBIEE 11G - Interview Questions for Experienced Professional.

OBIEE Interview depends on the years of experience one posses in OBIEE and the questions really should come from the CV based on areas of expertise. Below questions are for experience level more than 5 years.

1) Tell me about overall OBIEE Experience: 

Answer should include experience with RPD development, Multi user development experience if any , Reports and Dashboard development , Security , Usage accelerator , performance tuning , End User Requirement gathering , OBI Mobile App , BI Publisher , Informatica , DAC etc as per the job requirements. But if you have worked in any of the components listed above then mention it separately.

2) What is the purpose of Alias Tables. What is Conformed Dimension.

3) What are Select Views in Physical Layer and do they have any performance impact in OBIEE. If yes then how can they be avoided.

4) Why snowflake schema becomes necessary  sometimes and can they be avoided all together. What is the impact.

5) How can data level security is handled.

6) What is overall Security Architecture of OBIEE 11G. How can we handle Security Groups within weblogic.

7) Why do we create Multiple LTS, what is the purpose.

8) Where in RPD we create Outer Joins if we have to.

9) What is Content Level Filter and why it is used.

10) What does Logical Level means to you and what happens if that is not defined.

11)What are the steps to troubleshoot if you get an error while running a report : None of the fact tables exists at this level of detail.

12) When you login to OBIEE , you see a message that There are no reports to show ? What does it mean , How can you set your default dashboard.

13) User is trying to export to pdf format and not able to and getting error : Please contact your administrator fro more details, what will be the steps you take to troubleshoot.

14) How to convince users not to use OBIEE as data extraction tool?

15) Is there any limit on how much data we can export from OBIEE? If yes, then how much and can we increase and decrease the limit ?

16) Can we join two unrelated Subject areas to create a single output report? if yes, then how?

  

In Progress : More to come with possible answers. Answers all depends on experience of individual as these are not theoretical questions.