OBIEE Interview Questions Real time
Obiee Interview Questions and Answers:
This website is for OBIEE / BI developers who are interested to make repositories using BI administration tool and create reports using Presentation tools such as Answers or dashboard.
I am going to put all the OBIEE interview questions and also OBIEE trouble shooting issues, real time examples and challenges that I have faced during my complete obiee development experience.
First Let us see what are the main areas you may need to cover to become a successful obiee report developer.
What is OBIEE & OBIEE definition:
Before going further, first you may need to know what is obiee and why it is used?
Obiee is a ‘Oracle Business Intelligence Enterprise Edition’ and it is a tool which is used to develop enterprise wide reports. So, in simple words it is a report generation tool such as crystal reports. OBIEE is previous called as Sibel Analytic tool before it is acquired by Oracle. So do not get confused, that now it is called OBIEE tool.
Where is OBIEE stands in the development environment?
OLTP(Transactional Database) —-> OLAP (Data warehouse environment)—-> OBIEE(report generation tool).
(or)
OLTP(Transactional database)—–> OBIEE (reporting tool)
i.e Obiee tool can extract data directly from transacttional databse or data warehouse environment to build reports. It all depends upon the environment setup at clients place.
Pre-requisites of a OBIEE developer:
- Need to have good SQL knowledge and understanding or developing of PL/SQL statements.
- Data warehouse knowledge or little bit of experience such as Informatica.
- Good Analytical skills as you need to make reports out of existing data warehouse tables.
- Ability to talk to clients to gather requirements.
- Good understanding of various industrial modules such as sales, finance, inventory, marketing etc..
Setup your own BI environment in your system to practice OBIEE tool before attending any interviews. You need to install oracle 10g or Oracle 11g as a database and OBIEE 10 or OBIEE 11g . It is better to practice obiee 11g as many clients are going to implement obiee 11g in future..
Some Important OBIEE Interview Questions:
- What is multiple LTS?
- What are the difference between OBIEE 10g & 11g ?
- How do you create a business model when you have only one source table in Physical layer?
- Tell me one limitation that you know in OBIEE while creating BMM layer?
- Tell me a complex scenario you faced while creating reports from multiple data sources?
- What is log level in obiee? how many log levels are there?
- What are the different types of Variables in OBIEE?
- What problems we may face when using OLTP (in case there is no olap) as a source for reporting purpose in obiee?
- What is guided navigation in OBIEE?
- Tell me the relation between all these words.. ‘obiee’, ‘informatica’, ‘dac’, ‘BI Apps’
- What is Fragmentation in OBIEE and how it is used?
- What is Partition in OBIEE and why/how it is used?
- What it is advantage of using aggregate tables?
- Explain different Cache settings in OBIEE?
- Can we use Foreign key join for Logical data diagram? (normally we use ‘complex join’, but the other option also available. Then why can’t we use it?
- Can I have 2 fact tables in BMM layer?
- Explain me the concept of having multiple Fact tables instead of one.
- Why my cache settings are disabled in repository? Do I need to configure anything to enable it?
(Please Answer the above questions in your comments. Indicate the question number.)
Can you please provide the answers for these questions !!
regards
Kiran
multiple lts means, multiple logical table sources. This is normally, when we have 2 or 3 fact tables in the physical layer and we want to move them to BMM layer, we will create one logical table in bmm and add all the fact tables from physical layer as logical sources.
can u post the answers for the above questions?
Ans 1. LTS stands for Logical Table Source. Each logical table in BMM has got a SOURCE folder. As the name suggests SOURCE folder contains the table (physical table) which is the source for all the logical column in the logical table in BMM. So we can have multiple LTS (physical tables) as the source for the logical column(s) in a particular logical table.
Ans 2. Main diff. between 10g & 11g is terms of the following
1. In 10g OC4J (Oracle container for java) . In 11g its Weblogic server
2. Security is managed by RPD in 10 g. In 11g the security is managed by the welogic server.
3. In 10g we had Foreign key join (physical layer) & complex key join (BMM). We only have a New Key Join in case of 11g , which is used at both the BMM & Physical layer.
4. 11g supports cross join hierarchies example we can move from customer dimension to product dimension during drilling down. Supports ragged hierarchies etc.
5. 11g also has column hierarchies available in the presentation services, which are created simply by dragging the dimension hierarchies from the BMM layer to the presentation layer in RPD. when column hierarchies are used to build an analyses the default view is Pivot table.
6. The time series functions Ago & ToDate which where only available in the RPD with 10g are now also available in the presentation services along with a new function RollingPeriod.
7. The analyses can now by reconstructed at run time, that means we can move column attribute from the x-axis to the y-axis and reverse as well.
8.KPI’s are available in the 11g along with KPI Watchlist on which they are deployed to be viewed by the end user. Key Performance indicators (metrics very essential for the business)
9. Concept of scorecards is available in 11g, which can measure the goal/mission by using KPI’s as the building blocks for the same
10. concept of Seletions is now available in the presentation services in 11g.
11. There is a single portal for the bi publisher/bi intelligence. The reports that are built in the BI Publisher are stored in the same catalog, as the analyses created using the bi intelligence.
12. 11g has Action Framework which can by used to invoke, existing analyses, html, java procedures.
Ans 3. To create Business model in BMM, we require at least one dimension table and one Fact table. Since we have only one table in the physical layer, we need to create an Alias of that table and hence we will land with two tables in the physical table. Drag the two tables from the physical layer to the BMM and setup the cardinality so that one table is considered as the dimension and the other as Fact.
ans 6. when ever a request is sent from the Ans & Dashboard to the presentation services & then to BI server logs are generated. The logs generally contain the following info.
subject area, logical sql, physical sql etc. when the BI system is being developed/tested the log levels are set from 1 to 7. 1 log level being minimum level of logs and 7 being maximum level of log generation. In both 10g / 11g the logs are set in terms of users/ roles in the RPD.
thanks regguy. Great answers. Please post more obiee important questions here. Will be helpful.
WILL U PLEASE PROVIDE ANSWERS FOR ALL THESE QUESTIONS?
A.KIRAN
Ans 7: Variable is the one which hold some value in it. There are totally three types of variables in OBIEE. These are :
1)Session Variables: These are activated for every session. These include user name,password, group etc..
These are of two types.These are: System and non system variables.
2)Repository variables: These are activated when ever the server starts. These hold only one value at a time. These are of two types.These are static(constant) and dynamic( these are scheduled every time and changed accordingly).
3)Presentation Variables: These are used in the answers level mainly for the dashboard prompts.
Even though all people of ones own see 1 another each day, developing continues to be necessary. This really is basically the easiest method to strengthen the call one of the close relatives and in many cases create your romantic relationship to each other better. It really is excellent to do something out of doors but if your temperature isn’t that great or maybe it is really raining out of doors, you can consider a variety of interior activities and actions that can actually make all people feel happy. This is an excellent different that you could take into account. Listed here are the video games or even the actions you can do inside your own home.Hide and seek is probably the most widely used games ever played this can definitely be exercised inside your home. Somebody has to be an InchitIn . who’ll be liable of in search of other members of the family who will be concealing. The first one which will be discovered without the need of coming in contact withPeraccomplishing your home base will likely then are the upcoming Inchesit.In But when you are imagine that this is not a good choice, you can investigate charade that is a further interior activity. Within this online game, if at all possible, there ought to be two squads. You’ll encounter a user that should act up the phrase that is certainly authored on certificates as you move the fellow members are typically in-handle of speculating the term. The group with the most issues will likely then be reported as being the victor.Other than hide and seek and charade, a large variety of greeting card and games may also be on the list of suitable selections you could take a look at. Card games incorporate Menagerie, Older House maid, Running, Jewel, Slapjack and many other. For games, you’ll be able to opt for Scrabble, Chess, Monopoly, Household Feud and Checkers. When you have a lot of options to observe, you just have to pick the brains behind you feel really is pleasurable.However, if you feel that playing the activities who were stated previously will not be sufficient, you possibly can choose other pursuits which almost all of the family have passions in. For example, if you like cookingVersusfarrenheit whilst your kids, then you could makes action in an effort to rapport with your family. It is possible to give every new member to complete some perhaps the preparing your receipeePerpreparing practice making sure that every person will delight in. Guarantee that everybody actually gets to attend like hobby. Whenever food is baked or perhaps the pastry is cooked, then you can certainly take it together considering the close relatives. Everyone will surely be delighted to consume the fruits with their job. Apart from food preparationAndthis baking, additionally you can consider a few other pursuits like artwork, moving, performing, reading through, observing shows and plenty of a lot more.Mentioned pretty solutions for connect with the fam but the are actually successful. You do not have in your case shell out big money because very simple things can absolutely bring happiness to everybody specifically if the parents are complete. It is not actually critical that these products carried out daily. Once or perhaps a rare occasions per month are going to do.
Even when all people of your family see one daily, developing continues to be vital. This is simply the simplest way to improve the partnership one of the relatives and even build your romantic relationship to each other tougher. It is really excellent to behave outside but if your climate isn’t that very good or if it can be pouring exterior, you can consider several types of indoor video games and exercises that can definitely make absolutely everyone feel good. This is an excellent option that one could think about. In this article are some of the online games and the pursuits you can apply in the house.Hide and go seek is probably the most popular video games ever competed this also will be performed in the house. An individual ought to be an Init” that happen to be dependable of trying to get other members of the family who’re covering. The first that’ll be identified devoid of pressingPerachieving your home foundation might become the next Init.Inch But should you be feel that it’s not an excellent method, you possibly can consider charade that’s another inside sport. In this activity, essentially, there must be two clubs. There will be a user that will act on the phrase that may be published on certificates although the fellow members are usually in-power over betting the saying. The team with more factors will then be reported because the safe bet.As well as hide and seek and charade, a lot of avenues of unit card and games will also be among the ideal choices that you may check into. Card games include Menagerie, Old Maid, In business, Stone, Slapjack and more. For board games, it is possible to go with Scrabble, Chess, Monopoly, Loved ones Feud and Pieces. Since you also have a lot of options to check out, you need to simply pick one that you think that is basically enjoyment.However, if you find that playing the activities that were already mentioned will never be sufficient, it is possible to opt for other activities which a lot of the members of the family have likes and dislikes in. As an example, if you value in order to smokeOrcook if you want your son or daughter, then you can definitely turn this into activity so as to relationship with the fam. You are able to assign just about every fellow member to try and do some section of the bakingPerpreparing method to ensure that every person will enjoy. Guarantee that all people actually gets to attend these kinds of hobby. And once the food is grilled and the meal is baked, you may consume it in concert with all the loved ones. All people will certainly be content to have the fresh fruit of their total labour. As well as bakingAndpreparing, additionally you can think about several other activities like art work, dancing, vocal range, examining, observing shows and many more.I have listed incredibly approaches to rapport with your loved ones but these are actually helpful. You shouldn’t have to suit your needs spend big money simply because straightforward points can definitely provide enjoyment to every person specifically if the folks are full. It isn’t really truly critical that these things carried out everyday. Once a week or perhaps a rare occasions per 30 days are going to do.
ANS 7: There are two types of variables in OBIEE:
REPOSITORY VARIABLES and SESSION VARIABLES….
Repository variables are two types :-
1. Static variables
2. Dynamic variables
Session variables are two types:-
1. System session variables
2. Non-System session variables
OBIEE creates a query log in NQQuery.log file which is located by default at {installation drive}\OracleBI\server\Log. The log can be viewed using a text editor or the nQLogViewer. The query long becomes very handy in testing environment and troubleshooting.
Generally we have LOG LEVEL 0 – LOG LEVEL 5…………..
9) We have guided navigation and guided navigation link in dashboard. The purpose of guided navigation is to hide the section report and the purpose of guided navigation link is to navigate from one report in one dashboard to another report in the dashboard.
Dear Sir,
Thank you so much for your Effort to provide information regarding OBIEE.
I am doing OBIEE certification… can u tell me sumthng more about OBIEE wich is helpfull for me.. Regarding certification & Job.
Thanks & Regards,
Siddhesh