Last Updated: May 23rd, 2018
If you're looking for OBIEE Interview Questions for Experienced or Freshers, you are at right place. There are a lot of opportunities for many reputed companies in the world. According to research, OBIEE has a market share of about 4.5%. So, You still have an opportunity to move ahead in your career in OBIEE Development. Mindmajix offers Advanced OBIEE Interview Questions 2018 that helps you in cracking your interview & acquire dream career as OBIEE Developer.
Q1) Difference Between OBIEE & Tableau?
|OBIEE Vs Tableau|
|It is a BI & Reporting tool||It is data visualization tool|
|It is high in cost & has standard pricing's||It is less in cost for smaller enterprise and high for large enterprise|
|It is less in visualization||It has plenty of visualizations|
|It should be used after the training session on it||It is very easy for a beginner as it is drag & drop functionality|
|For this finalized BI solutions is implemented||It is mostly used for POC reporting|
|It has predefined BI frames for multiple sectors||In this we need to start from the scrap|
|It suits for medium & large industries||It suits for small & medium scale industries|
|It helps to create perfect reports||No tool available|
Q2) What do you mean by the architecture of OBIEE 11g? Also, mention the function of every component.
The presentation services and Oracle BI server are part of OBIEE
SQL is constructed by the user and it is passed to an analytic engine. After this, the Oracle BI which is the analytic engine will give a description of the data source of physical SQL. Then the data is recovered back to the analytical engine and it is presented to the services related to the presentation.
Q3) Mention the process of extracting SQL for reports from OBIEE.
There are several ways with the help of which SQL can be extracted from OBIEE.
Q4) Mention the method of the sort of reports in case of OBIEE 11g.
In case of OBIEE 11g, reports can be sort in by the process of selecting the modify option and then clicking on the sort option which there in the column that is relevant in pane of citeria.
Q5) Mention the ways of doing different kinds of reports that are narrative in case of OBIEE.
For OBIEE, the user is given the opportunity of doing different kinds of reports. It is done by clicking on the modify request option and the following Narrative view. After this, it is advised to give @1 for result of first column and @2 for the second column and many more. Also, there is the option of giving a heading in case of no result that is done by clicking on the view that is narrative.
Q6) What is the process of creating a dashboard which is interactive in case of OBIEE?
The user will create a dashboard that is interactive in case of OBIEE. It can be done by selecting the administration and also Manage dashboard option. After this add a column selector that will help in creating the dashboard that is interactive.
Q7) Mention the use of the write-back option in OBIEE.
In case of OBIEE, there is a write-back option which is used to give columns in form of updatable. It also helps in viewing reports.
Q8) Is it possible to execute a direct SQL in case of OBIEE? If so how can we do it?
Yes, it is possible to execute a direct SQL for OBIEE. You can do this by simply selecting the request that is direct database and it is present underneath the area involving the subject.
Q9) Mention the method of creating a report of two areas of subject in case of OBIEE.
The developers of OBIEE are able to create a report of two subject areas. First, you have to come down to the bottom of a page from the pane of criteria of the repository is created that is present in the first area of subject. Then click on the option of combine request. This procedure will help you in creating a report of two areas of subject.
Q10) For reports, dashboards, rpd in OBIEE, mention the method of putting changes to production from development.
To put changes to production from development, in case of RPD you can make use of the option of merge that is present in the admin tool. In case of reports and dashboard, you can use the framework of content accelerator to port the changes.
Q11) Mention the various kinds of variables that are present on OBIEE 11g and also give explanations regarding them.
Two types of variables are present for OBIEE 11g.
1. First, it is the repository variable that is used in case of the entire repository.
2. Secondly, it is the session variable that is again of two kinds. One is the non-system variable and another one is the system variable. NQ_Session is used by system variable. And those filters which are defined by users are mainly considered as non-system variables.
Q12) In case of table level and also system level, mention the method in which caching can be enabled or disabled.
For the system level, under the cache section, the enable option is used. And in case of table level, for enabling the cache then the repository that is used for offline mode should be opened. Remember thus repository must not be the present repository. After this, you can select the disable or enable an option for cache.
Q13) Mention the method following which you can add an additional column in the repository for presentation layer.
First, you have to check whether the table already exists or not. If it exists then you can add a physical layer. After this, you can select the BMM option and then select the presentation later. After this, you have to make sure to reload the metadata of the serve. The added column will become visible for every user.
Q14) In a situation when for a few certain users if changes are made only for the heading of the column of the report then what method should be followed by the users?
If a user is serious wants to just change the column heading of the report then the user should make use of the session variable.
Q15) Explain the concept of table alias of OBIEE 11g. Also, state how and where to create it.
For the purpose of creating elf joins, table alias is utilized. The process of creating a table alias is that you have to first right click on the table of physical layer and then you can click on the alias.
Q16) What is the method of craw ting a hierarchy in case of OBIEE?
In case of OBIEE, the hierarchy is created in the BMM layer for the purpose of the dimensional tables. You have to right-click on dimension table. Then create a dimension. After this, the hierarchy and the levels can be defined manually.
Q17) Define metrics that are level based and also mention the process of creating it.
The method of containing a measure which is held on a particular level of dimension is referred to as Level base metrics. Quarterly sales or monthly sales in one such example of metrics that are level based.
In order for creating a metrics that are level based, you need to first make a new column that is logical and it should be based on original measures. After this, you have to drag and then drop this new column accordingly.
Q18) Mention the various layers in repository of OBIEE 11g.
The various layers are
1. Physical layer
2. Mapping layer
3. Model of Business and
4. Presentation layer
Q19) Define the term Authentic in OBIEE and also mention the kinds of authentication.
The process with the help a system gives confirmation is known as authentication. The various types of authentication are
1. Operating system authentication
2. Database authentication
3. Authentication of External table
4. Authentication of LDAP
Q20) What do you mean by bridge table?
There may be a situation in which there is the need of connecting two tables that have no relation to them. In this case, another table is used that helps in connecting the other two tables. This third table is known as bridge table that has same columns as present in the other two tables.
Q21) In case of Siebel analytics, how can you define repository?
The metadata information is stored in the repository. The Siebel repository is known as a file system which has the repository file extensions of file.rpd. Metadata repository.
The rules which are connected with data modeling, connectivity, aggregate navigation and security and caching are stored in the repositories of the metadata. This happens with Siebel Analytical server.
Several repositories can be accessed with the help of Siebel analytics server. Also, each repository of metadata is able to store several business models.
Q22) Give a description of the Siebel analytics life cycle.
The life cycle of Siebel analytics is
1. First, there is the collection of requirements related to business.
2. Then source system recognition is achieved.
3. For the purpose of loading to DW in case there is no existence of source data then you have to plan an ETL.
4. The repository is then built.
5. The dashboard is built or you can use answers in case of reporting.
6. Security is defined then
7. After this, you have to make a decision on aggregation and also on caching mechanisms. This should performance basis.
8. The final step is testing.
Q23) Explain the working mechanism of architecture of Siebel. Also, give brief description of three layers.
The five parts those are included on architecture of Siebel
1. Data source
3. web server data sources of Siebel analytics
4. scheduler of Siebel analytics
5. server of Siebel analytics
The analytical model which is made with the help of administration tool of Siebel analytics is represented by Metadata.
There are three layers in the repository.
1. Physical layer which used for mentioning the sources of data
2. The business layer is used for copying the sources of data into dimensions and facts.
3. Presentation layer that is used for specifying the view of the users regarding the model
Q24) Give a brief description of Query repository tool.
The query repository tool is used for OBIEE or Siebel admin tool. It also allows the user to make an examination of the tool of repository Metadata. Also, the relation between certain objects of Metadata is examined by this. The objects generally consists of in which column of the presentation later should map with which table of the physical layer.
Q25) What do you mean by pipeline?
The stages that are present in a certain valuation, contract, economics etc. are defined as pipelines.
Q26) Mention the method of generating triggered report that is time-based.
Use the option scheduler that will help you in generating triggers reports that are time-based.
Q27) Mention the use of filters that are saved and also mention where to save the filters.
There are mainly two folders known as the prompts and reports.
Q28) How can you stop automatically a report run on the dashboard?
You can stop a report run of dashboard automatically by selecting the cancel button.
Q29) What is the need of JDK?
The term JDK stands for Java development kit which is basically a package of software that consists of tools which are required for writing, compiling, debugging and also for running Java applets.
Q30) What do you mean by RPD?
It is defined as a repository file which is also known as rapid file database.
Q31) What is ETL Plan?
ETL stands for Extract, Transform and Load. ETL Plan is to design the flow of the metadata
Extract ———————-> Transform ———————-> Load
Source Transformation Rule Target
Q32) What is ODBC and OCI?
ODBC stands for Open Database Connectivity and is also known as Universal Data Connector.
ODBC can be used to connect to any type of data source
OCI stands for Oracle Call Interface and is used to connect only to Oracle data source
Q33) How do we import data from an Excel work sheet?
To import metadata from an excel sheet we need to create a driver for excel data source. This can be achieved by using the following steps
Open Control Panel > Administrative Tools > DataSources (ODBC)Click on the System DSN tab
Click on Add
Select the Excel driver from the given list
Click on OK
A new window opens
Enter the data source name
Select the excel work from which you want to import metadata
Now open BI Administration tool
Go to File > Import Metadata
Select the Data Source that you have just created
Now you can import the required data from your Excel Worksheet
Q34) How is the Query repository tool used?
The Query repository tool gives the option to search and analyse the data from the database according to the name, type and other attributes that are describing the database.
The relationship between the different view layer data and the corresponding the physical layer columns.
Q35) What are opaque views in database? When is it advisable to create one?
The opaque views are tables that are created with join or other query data that contain “SELECT” query output. The opaque views make the logical understanding simple for implementation but there are heavy performance constraints. They are only used when there is no other way to get to the final solution.
Q36) How can you map each of the reports across to the different tables that are being accessed?
The Admin tool has the “Manage Sessions” tab which gives you the access to the logs that are being generated for each session.After the report generation sessions, you can easily view the log to map each requests to the corresponding tables and databases.
Q37) How can you migrate the presentation layers across to different servers?
The presentation layer is dependent on the database that is underlying in the each server. Therefore the presentation layer alone cannot be migrated as a stand-alone aspect of the database. What we can do instead is have a ODBC or similar database connection established across from the different servers to the particular main system and then carry over the presentation semantics from the other server with that database oriented changes in the logic layer.
Q38) How will you impose access limitation to the database according to the region of access?
1. The Data level security imposed according to data in certain column can be used to limit access depending on the regions.
2. The Siebel Analytics admin tool will give you the control over user access to the different data according to conditions supplied by you.
Q39) Which is preferable? Creating the new logical column in the repository level or the Dashboard level of view?
Creation of the logical column on the higher level of dashboard will have effect on the tables only on that view level and not on the other dashboards and other requests. The logical columns created on the repository level will in turn gets its effect on all the other requests and reports from different view levels. So it is always preferable to have the logical column created at the repository level.
Q40) What are the different deployment cases for the Siebel Analytics server?
The Siebel Analytics server can be deployed as a stand alone system or can be deployed as an integrated server which interfaces and communicates to the different Analytics server.
Q41) What are the External table based and LDAP based security?
The user ID and password need not be stored in the repository of the Siebel Analytics server. The external tables and LDAP offer the other possibilites. The userID and password for user authentication are stored in the external table. The information on different tables and the access information for each user are stored in this external table. The other way is the Lightweight Directory Access Protocol. This is similar to imposing a access limitation to all the different directories and folders thereby having the limitations to the data viewable for the different users.
Q42) What are the various levels of access authentications?
Q43) What are two main categories of variables overall?
There are two types of variables, namely the session variables and the repository variables. The session variables are pertaining to each session that is created for every login of a user. They may be System or Non-system variables.
The repository variables are the ones that are specific to a repository/database. The repository variables contain the parameters that are corresponding to different attributes of the respository and queries. They are again classified as static and dynamic variables. The static variables are the ones that are having permanent values through out. The administrator can change it whenever needed. The dynamic variables are the ones that have values that are corresponding to the SQL queries and data fetches. The dynamic variables can take up values depending on the scheduled updates that are started by the administrator. They can also take up values fue to the SQL queries that have been recently executed from the user side. Initialization blocks run at specific time or triggered according to specific condition.
Q44) What is single LTS and multiple LTS?
The logical table created at the BMM layer can be based on the data from a single physical layer table, when it is called single Logical Table source. When the specific logical layer table is dependent on the columns of different physical layer tables, it is called Multiple LTS. Most of the time we will be dealing with Multiple LTS.
Q45) If we have 5 different dimension tables and we need to have hierarchies for only one table, is it mandatory to have hierarchies implemented for all the tables?
No, it is not mandatory to create the hierarchies for all the tables, we can just define hierarchies to those tables that need to have it.
Q46) How can you use the Siebel variables to cope up with dynamic data environments?
The Siebel variable are the storage parameters that we can link within the metadata and other configuration parameters in the Siebel. With the help of the variable manager, all the confguration parameters can be loaded into the specific variable depending upon the different environments we are trying to have. This can help us in making the administrative tasks simpler.
Q47) What are the Key Configuration Files in OBIEE?
NQSConfig.ini, NQSCluster.ini, odbc.ini, instanceconfig.xml
Q48) What is task scheme and In production… if users are running the report.. but not getting the data… what could be the reason and list all the checks step by step.. How u will resolve the problem
Whether the issue is specific to this user / general. If general, then you might want to check the joins, referential integrity between tables. If specific, then you may have to check his security authorization, business model filters, session variable initialization / any query timing limitations, number of connection pool parameters etc
Q49) Couple of table names in Oracle GL,AR..ect
Talk in detail using below material.. this talks of entire flow as to which table is used for what
Q50) What are the minimum services needed to load a repository file onto memory and view a dashboard which has reports that have been refreshed on a scheduled basis?
Oracle BI Java Host, Oracle BI Presentation Server, and Oracle BI Server
Q51) What are Global Filter and how thery differ From Column Filter?
Column filter- Simply a filter applied on a column which we can use to restrict our column values while pulling the data or in charts to see the related content.
Global filter- This filter will have impact on across the application.
Q52) What is a materialized view?
Materialized view is a physical object and replica of the one or more master objects.It will refresh in an intervals.
Q53) Have you ever tried with de-normalized Database to build reports? If yes, How to handle?
Building reports on de-normalized data is not a best practice it leads to performance issues but we can build the reports. These are reports can’t be used for business analysis because the data will fluctuate non regular intervals.
Q54) Can you change the location of your RPD file in your OBIEE Configuration? If Yes, Where would you mention the new location of this RPD file for Bi Server?
Read the NQSConfig file “Repository Section”. You will easily find the answer. The answer for this is “It cant be changed”.
The repository location can be changed, this must be done when clustering the BI Server. The parameters in the NQSCONFIG.INI file are
REQUIRE_PUBLISHING_DIRECTORY = YES;
Q55) What kind of joins would you perform in the physical layer of the repository file when opened with Administration tool?
We cannot have outer joins in Physicla layer. We can outer joins in BMM layer. In BMM layer – complex join can be full inner join or full outer join or whatever your criteria was,but in physical layer – physical join is always an inner join.
Q56) When u run optimization and suppose u get some number….so how u know that the number is too bad or too good….
Well, this is situation dependent.. Only way is to check with source numbers
Q57) What is the default location of a repository file?
Q58) What’s XMLA and where is it used for in OBIEE context
The Provider Services tool that comes with Essbase is used to provide the interface, with Oracle BI Server talking to Essbase through its XMLA interface. (Need to find the answer still)