OBIEE Step by Step Guide

July 19, 2010

OBIEE Interview Questions Continued Part 2

Assume we are still talking about OBIEE version until Oracle comes with an OBIEE 11g GA date.

Hope you did go through part1 of OBIEE Interview Questions. Lets dive into Part2 now.

53. What are parameterized nested loop joins (PNLP)? Where are they used? Can you configure a PNLP in your physical or logical layer?

54. You are running a dashboard report and check whether it is using cache? What are the different caches that can be used to serve its customer faster? (remember we are not talking about cache in BI Server only) How does a dashboard request gets served from all available caches?

55. Is it better to cache a fact table or dimension table or both in the BI Server level? Why? (Forget other caches from above question)

56. You recently changed the columns of your presentation catalog as your manager wants to enforce naming standards for all customer facing apps. What happens to all the dashboard requests written prior ot this change? Do they function properly or do they appear broken? If ‘Yes, they will function’ How does they work? ‘If Not, reports appears broken’ what can you do to fix this?  Give examples.

57. What are the different hierarchy types available in OBIEE? When would you use them?

58. How do you create radio buttons on your OBIEE dashboard?

59. Can you create a Master Detail Report in OBIEE and how would you do it?

60. How do you deal with a situation like this when data is coming from a snowflaked data warehouse.

Fact  >—— Dimenion 1 >———-< Dimension 2 >————< Dimension 3

Dimension 1 and Dimension 2 is a M:M relationship and the same for Dimension 2 and Dimension3.

61. How do you resolve a M:M relationship other than using a bridge table?

62. Lets say that you have three tables joined to each other which have been set to be cacheable at physical layer with Table 1 set at cache persistence time 45 min, Table 2 with 60 min and Table 3 with 30 min. You ran your answers request at 9 AM and again at 9:15 AM and again at 9:45 AM. Is the result set the same for all these 3 runs at different times? If so, Why? If Not, why not? There are transactions going on and data is being updated in these tables almost every 10 min.

63. Lets say you are on your local box with a rpd and want to make sure that it can be edited only in offline mode. How can you accomplish this? Is this possible? What settings would you change?

64. Assume there is no MUDE in your environment. Three developers have been working on three seperate projects and they have developed their rpds. As a Server Admin, you were asked to promote these three rpds. What are the next steps for you as an admin to take care of to move them to QA and production? Are there any OBIEE tools that can be handy with this situation?

65. How do you get this type of interaction in your dashboard report? When clicked on a report column, I want multiple options for drill down. Remember that I did not create any hierarchies in my rpd.

66. Lets say that you want to include a prompt to your dashboard with Start Date, End Date and some measures and dimension attributes. You want to use ‘SQL Results’ feature to automatically populate Start Date and End Date with Start Date as trunc(sysdate – 1) and End Date as trunc(sysdate). What would you do? Will you encounter any errors? How do you rectify this problem?

67. How many business models can a presentation catalog refer to? How many presentation catalogues be created from a single business model?

68. How can we create nested presentation folders (nested presentation tables) in your presentation catalog? Lets say we have ‘Facts’ all lumped together in one folder and sub divide these facts as Facts – Logical and Facts – Strategic  folders? How would you create this nested structure in presentation catalog?

69. What are logical keys? Why would you need to create them? Does the physical key gets automatically converted to logical key when the table is moved from physical layer to business model?

70. Lets say you have a report with 4 dimensional attributes and 2 fact measures in the report. Whats the default sort behavior of OBIEE when you try to run the report? On what column/columns does it sort? How do you know this?

71. In the above scenario, Is it better to have atleast one column defined in your criteria manually or just leave it without any sort criteria mentioned? Whats the difference in performance?

Until next time, Kudos to all OBIEE evangelists out there

Always, remember that these are just for your reference and to play around with the tool for different scenarios and get to know the maneuvers available with this tool. Always, practice these scenarios and thats the only way you could register them in your permanent memory of your brain 🙂

Appreciate your feedback on this poll.


  1. Could you please provide answers for these questions as these help beginners to OBIEE.

    Comment by Chetan — September 15, 2010 @ 10:58 pm

    • Chetan,
      I am trying to do a very balancing act here by not posting the answers to the questions. Questions like these lead you to search for answers and you will learn more and more by practicing rather than reading the answers.

      If you have any specific question that you could not get an answer, post a comment and I can give you the answer.


      Comment by harikv — September 16, 2010 @ 11:05 pm

      • That’s good thing what your doing. Please provide the reffernce thing to study
        Thank you

        Comment by goutham — February 7, 2011 @ 4:47 am

      • Goutham,
        Most of these questions are based on practical knowledge. Try it and see it for yourself.

        Comment by harikv — February 7, 2011 @ 10:55 pm

  2. Hi hari

    I found answers to some of the questions u have posted.Could you review them and point out any mistakes ?? also should i post them or mail them to you ?

    Comment by Giriraj — November 12, 2010 @ 1:52 pm

  3. can u plz provide above questions and answers

    Comment by vivek — December 28, 2010 @ 1:59 pm

    • Sorry Vivek..
      You are missing the point here. I want you to PRACTICE rather than just know the answer.

      Comment by harikv — January 13, 2011 @ 7:33 am

  4. i have one question two fact tables and four dimension tables how to use

    Comment by vivek — December 28, 2010 @ 2:01 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply to vivek Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: