Important Obiee Interview Questions And Answers (2021)

2 Mar 2021

Introduction

OBIEE full form is also known as the Oracle Business Intelligence Enterprise Edition and is a premier BI suite built by Oracle. It has another name in OBIEE Plus and is written in Java and C languages. Thus, it has the ability to function well on multiple platforms. OBIEE professionals will find this set of OBIEE interview questions given below easy to revise the subject with. The questions and answers are given for some in an attempt to get the OBIEE developer interviewee to think along with the suggested answers and answer similarly.

The OBIEE interview questions are also divided into sets of questions to help freshers, intermediate-level professionals, and those who have some experience on the subject. In Siebel analytics one should revise answers to Siebel interview questions, Siebel configuration interview questions, Siebel architecture interview questions, Siebel scripting interview questions, etc along with interview questions on OBIEE 11g, OBIEE 11g security interview questions and answers.

Basic Interview Questions

1. Compare Tableau and OBIEE.

Tableau is end-user friendly while OBIEE needs trained developers to handle it. In terms of data visualization, Tableau is slightly better though both perform well. For those enterprise reports, the OBIEE suite is easily managed and deployed whereas the Tableau suite is way harder.

2. Explain the function of components and the architecture of OBIEE 11g.

The components in OBIEE are its Oracle BI server and its Presentation Services.

The Oracle BI Server user constructs SQL commands and sends them to the Analytic Engine of the Oracle BI suite. Here it is described to the data sources in physical SQL language. On analysis, the recovery of data begins which relays it back to the server where its Presentation Services provides the user-friendly reports.

3. How does one extract SQL for reporting functions from OBIEE?

One way is to alter the request and click on the Advanced tab where one can get the actual SQL and the XML code.
One can use the catalog Manager tools and create reports in the Create Report Window. From here one can Request SQL by clicking on it and saving its physical path to the computer.
One can also use Manage and Security tabs of the OBIEE 11g Administration Tool to enable Log level to 2. To do so one clicks on user properties and then heads to NQ Query.log in the path BI_HOME/OracleBI/Server/Logs to find the user SQL. Use Manage sessions under Administration and click on the View SQL tab.

4. Explain how to sort OBIEE 11g in Reports?

Head to the modify option and then click on the icon for sort. Ensure it is the relevant column available in the option called the criteria pane.

5. Explain the generation of different types of OBIEE 11g narrative Reports?

In OBIEE 11g click the ‘modify request’ tab and then the set on Narrative View. Give @1 location for the result of 1^st column, @2 if you need the 2^nd one, and so on. One can also provide a heading for the option of ‘No Results’ in the Narrative view by clicking on it.

Now for some test interview questions to help with topics like Siebel Analytics, OBIEE 11g, etc

6. Explain the creation of an Interactive Dashboard.

7. What is the OBIEE write-back?

8. How is a Direct SQL executed in OBIEE?

9. Explain how OBIEE Developers create two subject areas reports?

10. Explain OBIEE 11g types of variables.

11. How can one Port changes for reports, dashboards, RPD etc to production from development?

12. Explain disable and enable system and table level caching.

13. How does one add an additional column in the presentation layer to the repository?

14. When certain users have just a report column heading should a change be effected? How is report change ‘affected’?

15. What is the OBIEE 11g table alias? How and where is it created?

16. How and wherein OBIEE 11g does one create Hierarchy?

17. What is meant by Level Based Metrics? How does one create it?

18. Explain the various layers of OBIEE 11g Repository.

19. What is meant by Authentication? How many types of authentication are there?

20. What is meant by a bridge table?

Intermediate interview questions:

21. Explain how Time-based triggered reports are generated.

A time-based triggered report is generated using the Scheduler ibots.

22. Explain an ibot?

The ibot is an agent arrangement used when reports need to be sent to different types of devices like email, mobile, pager, other devices etc.

23. In OBIEE RPD what are different types of ‘joins’ possible?

Natural Join
Complex Join means multiple conditions are used. For Ex: B.ROW_WID = C.ROW_WID AND / OR B.B_WID = C.C_WID.

24. Explain how one gets 2 different columns from 2 different subject areas or tables?

If one uses confirmed dimensions one can fetch as many metrics desired from across different facts as in the example. One needs to ensure that the join is of the same level as the details of data.

25. How are saved filters used and saved?

Save it to Shared Folders under the heading XYZ Folder There are two types of saved filter folders, namely reports and prompts.

Now here are OBIEE interview questions to check out the answers for.

26. When running a dashboard how does one automatically stop the dashboard report run?

27. Define and explain the surrogate key.

28. Define Siebel Analytics repository.

29. Explain Siebel Analytics’ end-to-end life cycle.

30. What are the 3 layers of Siebel Architecture and how does it work?

31. One has 4 dimensions and 3 facts that need to be joined. Can we use fact with fact joins? If no, how to proceed?

32. How many connection pools can one have and what is it?

33. Why do we need JDK?

34. Opaque Views are not recommended by Oracle. When and why should one use them?

.35. Can the presentation layer be migrated to a different server? How?

Advanced interview questions:

Note: The OBIEE interview questions answers here are typically short and include advanced OBIEE interview questions.

36. Explain the SAS protocol.

SAS uses TCP/IP Protocol.

37. In Siebel Analytics can one use multiple data sources?

Yes, Siebel Analytics uses multiple data sources.

38. What can one do at the BMM layer?

39. Where are userid passwords found?

40. Explain the pipeline.

41. Explain OBIEE Key Configuration Files.

42. How we can deal with case statements and expressions in Siebel analytics?

43. Explain Initialization Blocks.

44. Explain the tool query repository.

45. Explain how one bypasses server security in Siebel Analytics?

46. What is R? Explain how to set permissions and add new groups.

47. Introduce some OBIEE details.

48. Explain the Presentation Catalog in Oracle BI?

49. What is meant by OBIEE 11G and where is it used?

50. Explain OBIEE 11G main features.

Conclusion

The above article has offered a list of OBIEE interview questions for OBIEE professionals taking interviews for a job or hoping to change career paths. However, interview skills that can get one success are not covered here and only a list of OBIEE interview questions will not suffice. One needs confidence, communication skills, and the right personality to succeed. Do brush up on these too, and all the best for the interviews!

If you are interested in making a career in the Data Science domain, our 11-month in-person Postgraduate Certificate Diploma in Data Science course can help you immensely in becoming a successful Data Science professional.