Latest Obiee Interview Questions
1) Mention 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.
2) Mention what are the main features of OBIEE?
Key features of OBIEE includes,
Hierarchy Drilling
Scheduled Report Generation
Graphical Reporting (Charts, Pivots, Gauges, )
Ad Hoc Analysis
Global support and development capability
3) Mention what is the 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.
4) Explain how OBIEE architecture works?
OBIEE architecture works in following way,
A request is made by the Users and sent to the Presentation Server.
The Presentation Server transforms the request into logical SQL and sent to the BI server.
The BI server transforms logical SQL into physical SQL and sent it to the database
The result gets back to the user through the same path
6) Mention what is ODBC Client is used for?
ODBC Client is used to connect to the database and execute SQL commands.
7) 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,
The sources must be modeled as snowflakes or star schemas for efficient result
In the case of multiple sources connecting directly in OBIee, it has to be used
8) 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
9) Mention 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.
10) 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
11) 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.
12) Mention what is session variable in OBIEE?
A session variable can be a system variable and non-system variable. It is initialized at login time for each user. System variable uses NQ_SESSION.(system reserved variable). Examples of non-system variables are user defined filters etc.
13) Mention what are the different log files in OBIEE?
Different log files in OBIEE includes,
NQServer.log
NQQuery.log
NQSAdminTool.log, etc.
14) Mention what are the Key Configuration Files in OBIEE?
Key Configuration Files in OBIEE are,
NQSConfig.ini
NQSCluster.ini
odbc.ini
instanceconfig.xml
15) Mention what are the security providers used by OBIEE?
Security providers used by OBIEE are,
Authentication provider to authenticate users
Policy store provider is used to access privileges on all applications except for BI Presentation Services
Credential store provider is used to store credentials used internally by the BI application
16) 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.
17) Mention how many server instances can coexist in an OBIEE cluster?
Maximum 16 server instances coexist in an OBIEE cluster.
18) Mention whether it is possible to create an Outer join in an OBIEE physical layer?
In an OBIEE physical layer, it is not possible to create the Outer join. You will create the join type in the Business Layer.
19) Mention how to bypass the server authentication?
To bypass the server authentication in NQSConfig.ini and instance config.xml, BYPASS SERVER AUTHENTICATION = YES.
20) Mention what is ibot?
Ibot is a scheduling agent, used to schedule reports to be sent across various devices such as email, pager, mobile, other devices, etc.
21) Mention how to get real physical SQL sent by OBIee to the database?
To get real physical SQL sent by OBIee to the database, check following details
Verify the value of your session variable LOGLEVEL (5 is fine)
Go into Administration -> Manage sessions
Find your query (at the bottom of the list), and click on “View log.”
Below the logical SQL, you will see the physical SQL.
22) Mention what does a Fact table consist of?
A Fact table consists of two types of columns
Facts and
Foreign key to dimension tables
23) Mention how to hide certain columns from a user?
To hide certain columns from a user,
Do not add the column in the report
Do not add the column in the presentation layer
24) Mention how you will change the port of Obiee?
You can change port of Obiee by changing its port in instanceconfig.xml