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 2021 that helps you in cracking your interview & acquire dream career as OBIEE Developer.
|OBIEE Vs Tableau|
|It is a BI & Reporting tool||It is a 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|
Ans: 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.
Ans: There are several ways with the help of which SQL can be extracted from OBIEE.
Ans: In the 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 a pane of criteria.
Ans: 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 the result of the 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.
Ans: The user will create a dashboard that is interactive in the 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.
Ans: In the case of OBIEE, there is a write-back option which is used to give columns in the form of updatable. It also helps in viewing reports.
Ans: Yes, it is possible to execute a direct SQL for OBIEE. You can do this by simply selecting the request that is a direct database and it is present underneath the area involving the subject.
Related Article: OBIEE Tutorial For Beginners
Ans: 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 the subject. Then click on the option of combine request. This procedure will help you in creating a report of two areas of the subject.
Ans: 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 the case of reports and dashboard, you can use the framework of the content accelerator to port the changes.
Ans: Two types of variables are present for OBIEE 11g.
Ans: 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 the cache.
Ans: 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.
Ans: 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.
Ans: For the purpose of creating elf joins, a table alias is utilized. The process of creating a table alias is that you have to first right click on the table of the physical layer and then you can click on the alias.
In the case of OBIEE, the hierarchy is created in the BMM layer for the purpose of the dimensional tables. You have to right-click on the dimension table. Then create a dimension. After this, the hierarchy and levels can be defined manually.
Ans: 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 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.
Ans: The various layers are
1. Physical layer
2. Mapping layer
3. Model of Business and
4. Presentation layer
Ans: 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
Ans: There may be a situation in which there is a need for 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 a bridge table that has the same columns as present in the other two tables.
Ans: 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 modelling, 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.
Ans: The life cycle of Siebel analytics is
1. First, there is a 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.
Ans: The five parts those are included in the architecture of Siebel
1. Data source
3. webserver 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 the administration tool of Siebel analytics is represented by Metadata.
There are three layers in the repository.
1. The 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. A presentation layer that is used for specifying the view of the users regarding the model
Ans: 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 consist of in which column of the presentation later should map with which table of the physical layer.
Ans: The stages that are present in a certain valuation, contract, economics etc. are defined as pipelines.
Ans: Use the option scheduler that will help you in generating triggers reports that are time-based.
Ans: There are mainly two folders known as the prompts and reports.
Ans: You can stop a report run of dashboard automatically by selecting the cancel button.
Ans: 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.
Ans: It is defined as a repository file which is also known as rapid file database.
Ans: ETL stands for Extract, Transform and Load. ETL Plan is to design the flow of the metadata
Extract —> Transform —> Load
Source Transformation Rule Target
Ans: 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
Ans: 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 physical layer columns.
Ans: 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.
Ans: 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 request to the corresponding tables and databases.
Ans: The presentation layer is dependent on the database that is underlying in 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 an 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.
1. The Data level security imposed according to data in a certain column can be used to limit access depending on the regions.
2. The Siebel Analytics admin tool will give you control over user access to the different data according to conditions supplied by you.
Ans: Creation of the logical column on the higher level of the dashboard will have an 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.
Ans: The Siebel Analytics server can be deployed as a stand alone system or can be deployed as an integrated service which interfaces and communicates to the different Analytics server.
Ans: 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 possibilities. 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 an access limitation to all the different directories and folders thereby having the limitations to the data viewable for the different users.
Ans: 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 repository 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 due to the SQL queries that have been recently executed from the user side. Initialization blocks run at a specific time or triggered according to a specific condition.
Ans: The logical table created at the BMM layer can be based on the data from a single physical layer table when it is called a 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.
Ans: 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.
Ans: The Siebel variable is 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 configuration 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.
Ans: NQSConfig.ini, NQSCluster.ini, odbc.ini, instanceconfig.xml
Ans: Whether the issue is specific to this user/general. In 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
Ans: Talk in detail using below material.. this talks of entire flow as to which table is used for what
Ans: Oracle BI Java Host, Oracle BI Presentation Server, and Oracle BI Server
Ans: There are 2 Global Filters as follows:
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 an impact on across the application.
Ans: A materialized view is a physical object and replica of the one or more master objects. It will refresh in intervals.
Ans: Building reports on de-normalized data is not the 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.
Ans: Read the NQSConfig file “Repository Section”. You will easily find the answer. The answer for this is “It can't 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;
Ans: We cannot have outer joins in the Physical 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 were, but in the physical layer – physical join is always an inner join.
Ans: Well, this is situation dependent. The only way is to check with source numbers
Ans: 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)