Below are most useful obiee interview questions and answers collected from job seekers who had faced interviews in the recent past. These obiee interview questions may not cover all topics but will definitely hep you to some extent.
Q: What is the meaning behind OBIIE?
A: The initials come from Oracle Business intelligence Enterprise Edition which is a package of BI products.
Q: What Business Intelligence (BI) means by definition?
A: It is a protocol and a technique to analyze and report about the state of the business data at a particular time.
Q: What types of variable we find in OBIIE?
A: Two types exist and these are the repository variables and session variables. The first kind remains the same anytime and gives birth to other two types: static and dynamic. The static variable changes only when the Siebel Analytics Server administrator wants to make a change. The dynamic variable updates every time a query is executed by a schedule from the Siebel Analytics Server. The second type (session variables) received a new value every time a user is logging on and this second type also splits into other two subtypes: system and nonsystem.
Q: What does Data Level Security in OBIIE?
A: Its role is the control of data type and amount seen in a report. Each user may see a different report according to the access that they have in the company.
Q: What is Object Level Security?
A: The that Object Level Security has is to protect the things like folder, pages , reports and dashboards that exist in the Siebel Analytics Web Catalog. Obiee security is most commonly asked obiee interview questions. Please concentrate this area.
Q: What is the difference between LTS (Logical Table Source) and multiple LTS?
A: In the majority of our time we will deal with multiple LTS which means that multiple physical layer tables are using data instead of a single layer table that is the conditions for single LTS.
Q: How can we use the Query Repository tool?
A: With this tool we can search and analyze the name and type or other descriptions from a database.
Q: How can we describe the implicit fact column?
A: We can define it as a joining or combination of data or columns from various tables. It is used as a transition layer to the final result.
Q: How can the management of the cache made?
A: It could split in three distinct ways: in the first case we can disable the cache of the server by setting a parameter to NO from the NQConfig.INI file and then a restart of the server. This method will stop the queries from updating or using the cache. In the second case we can adjust the cache at every physical table from the genera settings where we will find the “Make cache-abble” option.
In this way the queries will be able to use the cache and update it. In the third case event polling data table is used to keep an eye of the updates made on each table. Cache management is a must topic to be covered while preparing for obiee interview questions.
Q: Can we tell the difference between a system and a non system variable?
A: Yes, for example system variables are those session variables used by Siebel Analytics Web and Sever and they we can’t use them for static variables, dynamic repository or non system session variables. On the other hand non system variables or non system session variables can be used as a filter for users.
Q: Is it possible to make new logical columns for BMM layer?
A: Yes it is possible and we can see this example: we can right click on fact table and we will find here the command to make new logical column and we can name it.
Q: What is the meaning of LBM?
A: LBM is Level Based Metrics meaning how measure is classified in terms of dimension.
Advanced Obiee Interview Questions for Interviewer
Q: What is the definition and use of Alias tables?
A: The duplicated made for the tables of a database are called Alias tables and they are links to the properties like rows, columns of the original tables.
Q: How to handle ragged hierarchy?
A: It is similar to a geographic hierarchy with Continents, countries, Provinces/States/ and Cities all defined as levels. The Ragged hierarchy comes into place when we have two different models, one with a Provence and one without, because in that case the chosen Country does not support Provinces or States. The second model is a ragged hierarchy.
Q: Is it possible that for a single dimension logical table to have multiple dimensional hierarchy?
A: Once we right click a logical table and make a new dimensional hierarchy it’s not possible to make another one from the same table so for every dimension logical table we will have only one hierarchy.
Q: How can we log on as administrators in Siebel?
A: A dialog box from the Manage area of the admin tool can allow us to setup different user ID’s. From there if we select a user we can see that we can modify the level and save it.
Q: How different levels of access authentication are classified?
A: The levels are in number of four and their role is to block access to various databases or tables: 1) Operating level- without this authentication no one can get access in the application as this is the highest level of restriction. 2) Table- every physical table can be restricted. 3) Database- This can give total or partial access to the database by a user and a password to the user or can restrict all the access. 4) LDAP- or Lightweight Directory Access Protocol it provides access limits for various folders or directories.
Q: How one can know what report corresponds to a given table?
A: In order to discover this, after we run the report, we must arrive in the Administration tab and click Manage Sessions.
Q: What benefits brings OBIIE usage?
A: 1) It brings an excellent interactive, complex BI functionality and environment. 2) Increases in the insight of each individual by the role in the company. 3) Good infrastructure and Unified Business model. 4) Flexibility and good integration with every data. 5) High performance.
Q: What is the solution when connecting to multiple dimensions and fact tables?
A: The logical fact table has to be made on a BMM layer that has an upper level. Further oracle business intelligence questions may be read here.