If you're looking for OBIEE Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research OBIEE has a market share of about 4.5%. So, You still have opportunity to move ahead in your career in OBIEE Development. Mindmajix offers Advanced OBIEE Interview Questions 2019 that helps you in cracking your interview & acquire dream career as OBIEE Developer.
Q. Define OBIEE and illustrate briefly on its versions
OBIEE is the acronym for Oracle Business Intelligence Enterprise Edition. The texts of OBIEE are 11g, and moreover, the previous version is 10.13. OBIEE also refers to an analytical software engine that gives way to data mining and data analysis. It also comprises of publishing capabilities that are on top of the physical data warehouse. In this context, one should note that the base product of OBIEE is also known as Siebel Analytics. It was a result product of the Siebel Corporation. After a considerable time period, it was taken over by the Oracle Corporation.
Q. What are the ways with the help of which you sort Reports in the OBIEE 11g version?
To carry out this task, you need to click on modify, and then you have to click on sort. It is present in the relevant column in the selection tab.
Q. What are the ways with the assistance of which you can create Interactive Dashboards?
You can facilitate the creation of Interactive Dashboards by clicking on the administration and manage dashboards section. In the next step, you have to add column selector so that the process of the creation of Interactive Dashboard can be completed.
Q. How can you create various categories of narrative reports in OBIEE?
You can do that by clicking on the modify request tab. Moreover, you have to click on the narrative view section and have to input results so that one can also give a heading for no results by even clicking on the fictional part.
Q. Define write back in OBIEE
The option of providing a column which is also updatable is also called the write back option.
Q. Illustrate on the process of executing Direct SQL in OBIEE
You can achieve Direct SQL by clicking on the Direct Database Request which is located below the area of the subject tab. In this check, you can facilitate Direct SQL in OBIEE.
Q. Shed light on the various categories of variables that are present in the OBIEE 11g version
There are mainly two types of variables in the OBIEE 11g version. They are the Session Variable and Repository Variable. In this context, it is vital to note that the session variable is of two types. They are the non-system variable and the system variable. The illustrations of the non-system variable usually comprise of user-defined filters. On the other hand, system variables comprise generally of NQ_SESSION.
Q. Define the process of creating changes for reports, dashboards, and RPD from the development of the product
To carry out these assignments, you can use the merge option in the Admin tool. Moreover, in case of reports and dashboards, one can also use the framework of a content accelerator.
Q. How can you carry out adding the additional column to a tab of a repository in the presentation cover?
If you want to carry out this function, you have to make sure that the table exists or not. If the table exists, then you have to click on BMM and later on the cover of presentation. One can also reload the metadata server so that it would be visible to the interested viewers.
Q. Define the phenomenon of table alias that is present in 11g. Which are the areas and how would you create?
Table alias can be used for facilitating self-joins. Moreover, you can create table alias by right-clicking on the table in the natural cover and then you can click on a nickname.
Q. Illustrate on the process of disabling and enabling caching at the table level and system level
To carry out the enabling function, you can use ENABLE function under the CACHE Section for the System Level Administrator. On the other hand, in case you want to enable cache then you have to make sure that you open the repository tab in the offline mode. It would be different from the current repository, and then you can opt to click on enable or disable functions to facilitate cache.
Q. Define level based metrics and illustrate the process of its creation
Level based metrics usually denotes to hold a certain level of the dimension. For instance, quarterly sales or monthly sales can be dragged into the category of standard based metrics. In order to facilitate the creation of level based parameters, you have to generate a measure of concentration found along with a new logical column. However, make sure that you create that to an appropriate level in the hierarchy of the dimension.
Q. Define the process of data warehousing
Data warehouse refers to the primary storehouse of a company's historical data. Hence, it is also referred to as corporate memory. It comprises of the raw material for the decision support of the management. The use of a data warehouse can be determined by the fact that a data analyst can carry out complex queries and assessments. The collection of data in data warehousing refers to the supported form of decision making which is helpful to analyze the various forms of big data critically. It comprises of a plethora of varieties of data that always depicts a consistent image of the business conditions.
Q. Define the process of using Query repository tool
The Query repository tool still facilitates the choice of analyzing and searching data from the collection of a database as per the type, name and other types of attributes. There exists a relationship between the various view layers of data that corresponds to the thickness of concrete columns.
Q. Illustrate the notion of opaque views in a database and when should you create one?
It is important to note that opaque views denote tables that are manufactured with query data. It comprises of the select query option. Moreover, it is also interesting to mention that the misty pictures make use of the logical comprehension for the simple implementation of data. However, there might be constraints related to big performance. They are only utilized when there exists no visible way to calculate the final solution.
Q. Define single and multiple LTS with reference to the context of OBIEE
The logical table that is created at the layer of BMM can be emphasized on the data output which is being generated from a physical stand. In this situation, it is also called a single Logical Table source. When a dependency situation arises on the columns of vivid physical layer tables, it is known by the name of Multiple LTS. As an OBIEE administrator, one would be dealing with Multiple LTS.
Q. Explain the way in which the OBIEE architecture functions
OBIEE architecture functions on the basis of a request that is made by the users which are being sent to the presentation server. In the subsequent process, the presentation server always transforms the application into logical SQL which are being sent to the Business Intelligence Server. In the next operation, the BI server alters the valid SQL into the physical SQL and then is being submitted to the database. In the last process, the results that are generated always get back to the same path.
Q. Illustrate on the main components of OBIEE those are important to carry out various assignments
There comprises of different types of elements that are mainly categorized mainly into two categories. They are Client Components and Server Components. In this context, it is vital to note that the client component is further classified into non-web based client and the web-based client.
Q. What are the security providers that are being used by OBIEE?
There are different kinds of security providers that are being used by OBIEE. For instance, the authentication facilitates the authentic users. The provider of the policy store is being utilized to access various types of privileges on various kinds of applications except for the BI presentation services. The credential store provider is being used to store different kinds of credentials that are internally being used by the applications related to Business Intelligence application.
Q. Illustrate on the differences that exist between a repo variable and the session variable
Repo variables are also known by the name of repository variables. It comprises of a minute exponent at a particular time. The repo variables can be utilized instead of constraints or literals that can arise while executing various functions. The Oracle BI server substitutes the notion of the repo variable in the existence of the metadata. On the other hand, session variables are similar to the dynamic repo variables. They obtain these values from the initialization blocks. However, the initialization of the session variables is not scheduled correctly. There are many instances of a session variable as it comprises of active sessions.
Q. Define management of cache in the context of OBIEE
Managing and monitoring data and cache in the environment of OBIEE is called management of cache. There exist three methods to carry out the notion of management of cache. For instance, persistence time for cache physical tables, setting polling table related to events and disabling cache are the strategies.
Q. Mention the various kinds of management of cache
One can assign a unique quality for physical tables of various natures. For instance, if the queries involve the specified table, it can be added to the cache to answer the future questions. In order to enable cache for a unique type of physical table, you can assign the table layer of the tool which lies in the administration layer. You can choose the option to make table choice properties which are located on the general tab. One can also utilize data for the creation of a unique table. This is also useful for all kinds of data sources of OLTP.
On the other hand, disabling caching for the system by setting the enable parameter would also allow you to make sure that you have created the INI configuration file. Disable of various types of caches also stops the entrance of new queries by using the existing stockpile. The disabling of cache would also allow you to enable it a later time without losing any original entries that are already stored in the cache.
Q. How can you facilitate setting up apolling table of events?
The polling table of events is an exclusive component of the Siebel Analytics Server. It is a polling table which usually stores data about the current updates in various databases. Moreover, an application can also be configured to add rows so that apolling table of events each time can be produced. The server of the analytics in a Siebel environment can be set at particular intervals. It also eliminates the occurrence of any cache during this process. Moreover, for apolling table of events, it is mainly seen as a unique table and does not need to be intersected with the other tables that are present on the natural cover.
Q. Define ibot with reference to OBIEE
It is an arrangement method that is utilized to produce various reports.