OBIEE 12C interview questions for freshers/OBIEE 12C Interview Questions and Answers for Freshers & Experienced

Why do we have multiple LTS in BMM layer? What is the purpose?

To improve the performance and query response time we have multiple LTS in BMM.

Posted Date:- 2021-10-07 08:01:03

Can we migrate the presentation layer to a different server.

No we cant migrate the presentation layer to a different server rather we have to migrate the whole web & rpd files.

Posted Date:- 2021-10-07 07:58:10

Oracle doesn’t recommend Opaque Views because of performance considerations, so why/when do we use them?

An opaque view is a physical layer table that contain select statement. An opaque view should be used only if there is no other option.

Posted Date:- 2021-10-07 07:56:14

Define JDK and why do we need it?

Java Development Kit (JDK), is a software package that contains the minimal set of tools needed to write, compile, debug, and run Java applets.

Posted Date:- 2021-10-07 07:55:09

Define repository in terms of Siebel Analytics.

<> Repository stores the Meta data information. Siebel repository is a file system ,extension of the repository file. rpd.
<> With Siebel Analytics Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories.
Every metadata repository can store many business models. Siebel Analytics Server can access many repositories.

Posted Date:- 2021-10-07 07:50:01

Define surrogate key.

A surrogate key is an artificially generated key, usually a number. A surrogate key, in the level aggregate table, simplifies this join and removes unnecessary columns from the fact table, resulting in a smaller-sized fact table.

Posted Date:- 2021-10-07 07:23:21

Have you worked in dashboard? when we run a dashboard? how will we stop the dashboard report run automatically?

By clicking on the cancel button, we can stop a exact report placed on the dashboard.

Posted Date:- 2021-10-07 07:22:40

How can we use saved filters and where we will save the filters?

Shared Folders – XYZ Folder – It have two folders
a. Prompts
b. Reports

Posted Date:- 2021-10-07 07:22:05

How we can have two different columns from two different tables or subject areas?

Using confirmed dimensions,we can fetch many metrics across various facts, but the join should be of same level of data detail.

Posted Date:- 2021-10-07 07:21:31

What Are The Three Layers Of Obiee Repository?

The three layers of OBIEE repository are:

Physical Layer (Schema Design): It contains information about the data sources

Business Model Layer: It outlines the business or logical model of objects and their mapping between business model and Schema in the physical layer

Presentation Layer: Presentation layer is used to provide customized views of Business Model in Business Model layer to users.

Posted Date:- 2021-10-07 07:20:52

How Time based triggered report can be generated?

Using Scheduler – ibots we can generate time based triggered report.

Posted Date:- 2021-10-07 07:19:48

Mention what is the difference between logical table source and logical table?

The difference between logical table source and the logical table is that a logical table consists of one or more logical table source. The mapping between logical column and physical columns are done in this element.

Posted Date:- 2021-10-07 07:18:44

What is a bridge table ?

If we want to connect two tables where there is no relationship we can use a third bridge table for connecting them which will have same columns in both tables.

Posted Date:- 2021-10-07 07:15:36

What is Authentication? How many types of authentication.

Authentication is the procedure by which a system confirms, through the use of a user

<> Operaing system authentication.
<> External table authentication.
<> Database authentication.
<> LDAP authentication

Posted Date:- 2021-10-07 07:14:48

What are the different layers of OBIEE 11g Repository?

Physical Layer.
Business Model.
Mapping Layer.
Presentation Layer.

Posted Date:- 2021-10-07 07:13:49

Mention what are the different log files in OBIEE?

Different log files in OBIEE includes,

* NQServer.log
* NQQuery.log
* NQSAdminTool.log, etc.

Posted Date:- 2021-10-07 07:13:10

What is Level Based Metrics? How we can create it?

Level-base metrics means, having a measure held at a certain level of the dimension. Examples Monthly Total Sales or Quarterly Sales
To create a level based measure, create a new logical column based on the original measure. Drag and drop the new logical column to the appropriate level in the Dimension hierarchy.

Posted Date:- 2021-10-07 07:12:30

How are saved filters used and saved?

Save it to Shared Folders under the heading XYZ Folder There are two types of saved filter folders, namely reports and prompts.

Posted Date:- 2021-10-07 07:11:48

Mention what is LTS in OBIEE?

LTS or Logical Table Source is created when you drag and drop a column from a table that is not presently being used in your logical table. A physical table containing such column is referred as LTS.

Posted Date:- 2021-10-07 07:10:38

Mention what does physical layer is used for?

Physical layer is used for,

* Importing data
* Creating Aliases
* Building physical joins
* Setting up connection pool and its properties
* Enabling/ Disabling cache for individual table

Posted Date:- 2021-10-07 07:10:07

Explain how one gets 2 different columns from 2 different subject areas or tables?

If one uses confirmed dimensions one can fetch as many metrics desired from across different facts as in the example. One needs to ensure that the join is of the same level as the details of data.

Posted Date:- 2021-10-07 07:09:28

How will you go about adding additional column to the repository in the presentation layer?

Check if the table is already existing if so add in physical layer ,then click on BMM and then Presentation layer, then reload server metadata ,then it will be visible to all users.

Posted Date:- 2021-10-07 07:08:48

How will you enable or disable caching in the system level and table level?

In the NQSConfig.ini file use ENABLE under CACHE Section for System Level
For tables, if we want to enable the cache at table level , open the repository in offline mode This should be different from the current repository and click enable or disable the cache .

Posted Date:- 2021-10-07 07:08:20

Mention what are the three layers of OBIEE repository?

The three layers of OBIEE repository are,

1. Physical Layer (Schema Design): It contains information about the data sources.
2. Business Model Layer: It outlines the business or logical model of objects and their mapping between business model and Schema in the physical layer.
3. Presentation Layer: Presentation layer is used to provide customized views of Business Model in Business Model layer to users.

Posted Date:- 2021-10-07 07:07:50

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.

Posted Date:- 2021-10-07 07:06:46

Mention the method following which you can add an additional column in the repository for the 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.

Posted Date:- 2021-10-07 07:06:14

In the 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 the 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.

Posted Date:- 2021-10-07 07:05:41

For reports, dashboards, rpd in OBIEE, mention the method of putting changes to production from development?

To put changes to production from development, in the 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 dashboards, you can use the framework of the content accelerator to port the changes.

Posted Date:- 2021-10-07 07:05:20

In OBIEE RPD what are different types of ‘joins’ possible?

1. Natural Join.

2. Complex Join means multiple conditions are used. For Ex: B.ROW_WID = C.ROW_WID AND / OR B.B_WID = C.C_WID.

Posted Date:- 2021-10-07 07:04:57

Explain how Time-based triggered reports are generated.

A time-based triggered report is generated using the Scheduler ibots.

Posted Date:- 2021-10-07 07:03:00

Explain End to End Lifecycle of OBIEE?

The end to end life cycle of OBIEE is:

* Collecting Business Requirements
* Identify source systems
* Design ETL to load data to the Data Warehouse
* Creating repository
* Create dashboards and reports
* Setting up security (LDAP or External table)
* Decide on aggregations or caching mechanism based on performance
* Testing and QA.

Posted Date:- 2021-10-07 07:01:58

How we can Port changes for dashboards, reports, rpd from development to production?

For the RPD we can use the Merge option in Admin Tool and for dashboards and reports we can use Content Accelerator Framework.

Posted Date:- 2021-10-07 07:00:29

Mention what all information does OBIEE repository contains?

OBIEE repository contains information about the application environment like,

* Data Modeling
* SQL Information
* Caching
* Connectivity Information
* Aggregate Navigation
* Security

Posted Date:- 2021-10-07 07:00:05

Mention what kind of sources can be connected to OBIEE?

Sources like Relational Databases, Cubes or Flat files can be connected to Obiee with following constraints,

1. The sources must be modeled as snowflakes or star schemas for efficient result.

2. In the case of multiple sources connecting directly in OBIee, it has to be used.

Posted Date:- 2021-10-07 06:59:27

Mention what is ODBC Client is used for?

ODBC Client is used to connect to the database and execute SQL commands.

Posted Date:- 2021-10-07 06:58:42

What are the different types of variables in OBIEE 11g? explain

There are two types of variables in OBIEE 11g.

1. Repository variable : This variable is used for the whole repository.
2. Session variable : session variable are of two types: system variable and non system variable. System variable uses NQ_SESSION. Examples of non system variables are user defined filters.

Posted Date:- 2021-10-07 06:58:19

How OBIEE Developer can create report from two subject areas?

From the Criteria Pane of the Report Created from First Subject Area
come to the bottom of the page and click combine request. By this we can create report from two subject areas.

Posted Date:- 2021-10-07 06:57:44

How will you execute Direct SQL in OBIEE?

By clicking Direct Database Request below the subject area in we can execute Direct SQL in OBIEE.

Posted Date:- 2021-10-07 06:57:19

What is write-back in obiee ?

We can give a column as updatable and then view the reports,this option is called write back option.

Posted Date:- 2021-10-07 06:57:03

How will you create Interactive Dashboards ?

By clicking on Administration and Manage dashboards and by adding column selector we can create interactive Dashboard.

Posted Date:- 2021-10-07 06:56:46

Mention the method of creating a report of two areas of the subject in the 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 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.

Posted Date:- 2021-10-07 06:55:41

Is it possible to execute a direct SQL in the 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 a direct database and it is present underneath the area involving the subject.

Posted Date:- 2021-10-07 06:55:22

Mention the use of the write-back option in OBIEE?

In the case of OBIEE, there is a write-back option that is used to give columns in the form of updatable. It also helps in viewing reports.

Posted Date:- 2021-10-07 06:55:03

What is the process of creating a dashboard that is interactive in the case of OBIEE?

The user will create a dashboard that is interactive in the case of OBIEE. It can be done by selecting the administration and also the Manage dashboard option. After this add a column selector that will help in creating the dashboard that is interactive.

Posted Date:- 2021-10-07 06:54:44

Mention the ways of doing different kinds of reports that are narrative in the 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 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.

Posted Date:- 2021-10-07 06:54:30

Mention the method of the sort of reports in case of OBIEE 11g?

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.

Posted Date:- 2021-10-07 06:20:20

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.

1. The request can be changed and then by clicking on the Advance option the user will be able to get the XML code and the original SQL.

2. Select the option of Tools Create a report from the catalog manager. Then click the request SQL option from the create report window. Also, the sales to the physical path should be saved on the computer.

3. In the OBIEE 11g administration tool, go to the mange option and then select the security option. Then by selecting the properties for the user option make sure to enable the level of Log to 2.

Posted Date:- 2021-10-07 06:20:03

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 the 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.

Posted Date:- 2021-10-07 06:19:14

what are the main features of OBIEE?

Key features of OBIEE includes,

1. Hierarchy Drilling
2. Scheduled Report Generation
3. Graphical Reporting (Charts, Pivots, Gauges, )
4. Ad Hoc Analysis
4. Global support and development capability

Posted Date:- 2021-10-07 06:18:12

what is Obiee?

Obiee stands for Oracle Business Intelligence Enterprise Edition (OBIEE). It is a business intelligence system for the enterprise that delivers abilities for reporting, online analytical processing (OLAP), ad hoc query and analysis dashboards, and scorecards.

Posted Date:- 2021-10-07 06:17:30

R4R Team
R4R provides OBIEE 12C Freshers questions and answers (OBIEE 12C Interview Questions and Answers) .The questions on website is done by expert team! Mock Tests and Practice Papers for prepare yourself.. Mock Tests, Practice Papers,OBIEE 12C interview questions for freshers,OBIEE 12C Freshers & Experienced Interview Questions and Answers,OBIEE 12C Objetive choice questions and answers,OBIEE 12C Multiple choice questions and answers,OBIEE 12C objective, OBIEE 12C questions , OBIEE 12C answers,OBIEE 12C MCQs questions and answers R4r provides Python,General knowledge(GK),Computer,PHP,SQL,Java,JSP,Android,CSS,Hibernate,Servlets,Spring etc Interview tips for Freshers and Experienced for OBIEE 12C fresher interview questions ,OBIEE 12C Experienced interview questions,OBIEE 12C fresher interview questions and answers ,OBIEE 12C Experienced interview questions and answers,tricky OBIEE 12C queries for interview pdf,complex OBIEE 12C for practice with answers,OBIEE 12C for practice with answers You can search job and get offer latters by studing .learn in easy ways .