Prepare for your OBIEE job interview with this list of top OBIEE Interview Questions and Answers for Freshers and Experienced which is Prepared by 10+ Years Experienced OBIEE Experts.
OBIEE Interview Questions and answers for beginners and experts. List of frequently asked OBIEE Interview Questions with answers by Besant Technologies. We hope these OBIEE Interview Questions and answers are useful and will help you to get the best job in the networking industry. This OBIEE Interview Questions and answers are prepared by OBIEE Professionals based on MNC Companies expectation. Stay tuned we will update New OBIEE Interview questions with Answers Frequently. If you want to learn Practical OBIEE Training then please go through this OBIEE Training in Chennai.
Besant Technologies supports the students by providing OBIEE Interview Questions and answers for the job placements and job purposes. OBIEE is the leading important course in the present situation because more job openings and the high salary pay for this OBIEE and more related jobs. We provide OBIEE online training also for all students around the world through the Gangboard medium. These are top OBIEE Interview Questions and answers, prepared by our institute experienced trainers.
Here is the list of most frequently asked OBIEE Interview Questions and answers in technical interviews. These questions and answers are suitable for both freshers and experienced professionals at any level. The questions are for intermediate to somewhat advanced OBIEE professionals, but even if you are just a beginner or fresher you should be able to understand the answers and explanations here we give.
Q1) What is OBIEE?
Oracle Business Intelligence Enterprise Edition (OBIEE) is a Business Intelligence (BI) tool provided by Oracle Corporation. Its proven architecture and common infrastructure producing and delivering enterprise reports, dashboards, ad-hoc analysis, and OLAP analysis provide a rich end-user experience.
Q2) Why do you learn OBIEE?
- To make Decision quickly
- To Data Visualization and Dashboard Design
- To understand Business Performance Management Systems
- To get the solution for business growth
Q3) Who can use OBIEE?
- SQL developers
- Project Managers
- Database Professionals
- Mainframe Professionals
- Who want to become Business Object Professionals and Business Intelligence Professionals
- Entry-level trainees
Q4) Pre requisites to learn OBIEE
- Basic knowledge of SQL
- Basic knowledge of Reports
- Basic knowledge of MS Excel
Q5) Architecture of OBIEE
- Presentation server:Which convert the request comes from end user to logical SQL and sends it to Oracle BI Server.
- Oracle BI server: TheBI server is converting the logical sql to Physical sql so that database will understand the sql.
- Database: Database fetches the required result using the Physical query
Q6) Main features of OBIEE
There are following main features of OBIEE:
- Hierarchy Drilling (Drill up and Drill down)
- Report and Dashboard Scheduling
- Graphical Reporting
- Ad Hoc Analysis
- Global support and development capability
Q7) Explain end to end Life cycle of OBIEE
- Collecting Business Requirements from Business people
- Identify source systems which is required to develop suitable reports
- Design ETL to load data from source to the Data Warehouse
- Creating repository
- Create reports and dashboards
- Set up security
- Build cache mechanism and aggregations
- Testing and QA.
Q8) What kind of Data Sources we can use for OBIEE
The OBIEE can connect to Sources like Relational Databases like Oracle, SQL Server, Cubes or Flat files can be connected to OBIEE.
Q9) What set up is possible in OBIEE Repository?
OBIEE repository contains metadata of Same Data base or different databases. It contains following information:
- Data Modelling
- Connectivity Information
- SQL Information
- Aggregate Navigation
Q10) What Are The Three Layers Of Obiee RepositoryAnswer:
Physical Layer (Schema Design): Contains the Schema information and place where import the tables from source.
Business Model Layer: Where hierarchy can be build and multiple LTS is possible.
Presentation Layer: Presentation layer is used to provide object level security and provide customized views of Business Model in Business Model layer to users.
Q11) What is the use of Physical layer?
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
Q12) What types of joins we can use in OBIEE Physical layer?
Physical layer joins are called as physical joins and attributes can be joined using either equal operator or using any expression.
Q13) What type of joins possible in OBIEE BMM layer?
BMM layer joins are called as logical joins and can be define as inner join or Left join or Right join.
Q14) What is the difference between physical join sand logical joins?
In physical join we can’t define type of join and in logical join we can’t make expression or greater than or less than in join.
Q15) What is connection pool in OBIEE RPD?
Connection pool contains the data base information and is useful to import meta data into Physical layer.
Q16) What is alias table?
Alias table is exactly replica to any physical table in Physical layer. If any changes are happened in main table it will reflect in alias table also.
Q17) What is duplicate table and difference between alias and Duplicate tables?
Duplicate table is replica of main table at an instance only, If any changes are happed in main table it will not reflect in duplicate table.
Q18) What is circular join?
In any join there is a table used in more than once then t is called as circular join.
Q19) Types of variables?
There are 4 types of variables in OBIEE
- Repository variable
- Session variable
- Presentation variable
- Request variable
Q20) What is Initialization block?
To define dynamic repository variable using any SQL expression Initialization block is needed.
Q21) What is Subject area?
The main object in presentation layer is Subject area and defines one subject area for one business entity.
Q22) What is presentation tables?
The tables which are available in presentation layer is Presentation tables and it might be built by using one or more physical tables.
Q23) What is cache and how to set up cache in RPD?
Cache is log of any query developed in Analytics page. Go to manage and get identity and select any user then you can define log level for that particular user or role.
Q24) How to purge cache in RPD?
Using EPT tables
By setting cache persistence time at table level.
Q25) How to check users and Roles in RPD?
Go to manage in RPD and click on identity and click on active user filter and give value as * and enter, you will get all user list.
Q26) What is Event pooling table?
Event pooling table is used to purge data automatically having table information whose cache should be purge.
Q27) What is basic web pages in OBIEE?
Analytics page: Presentation server component.
Console: WebLogic server component.
Enterprise Manager: BI server component.
Q28) What type of reports can build in analytics page?
- Time Series Line
Q29) What is the configuration file used by Analytics page?
Q30) How to check query in analytics page?
Go to administration and click on manage session
Q31) Type of cache available in obiee
BI presentation server cache
BI server cache
Data Base cache
Q32) How to skip and bypass OBIEE presentation server cache?
Click on advance tab in analytics age and click on the check box bypass BI presentation server cache.
Q33) What is action links?
To navigate one report to another report or another dashboard or web page action links are used.
Q34) What is agent?
Agent is used to schedule report or dash board agent is used.
Q35) What is dashboard
Dash board published content in OBIEE and contains one or more than one report in a dash board page.
Q36) What is Enterprise manager?
EM is Fusion middle ware control page and it controls the all BI server components.
EM is the place where RPD and catalog deployment process is going on.
Q37) What is console?
Console is Weblogic Server web page, and is useful to control the Admin server and managed servers.
Q38) What is OPMNCTL?
Operation process management network control is the BI control component to control the BI server components like Presentation server, Java host, BI publisher etc.
Q39) What is node manager?
Node manager is the bridge between admin server and managed server in Weblogic server.
Q40) What is Direct data base request?
Getting report in Analytics page by writing SQL query without RPD Meta data.
Q41) What is right back?
Update the values in report directly in report and will be updated in Data base called right back.
Q42) Types of security in OBIEE
- Object level security
- Data level security
Q43) What master detail report?
There are two reports and the second report is navigated through first report called master detail report.
Q44) Types of hierarchies in OBIEE
Level based hierarchies
Skipped and Ragged hierarchies
Parent child hierarchies
Q45) What is catalog manager?
Catalog manager is window component and is used to connect to catalog.
Q46) What is job manager?
Job manager is also window based component and is used to monitor the scheduled jobs.
Q47) What is opaque view?
Opaque is a view build by SQL query in physical layer in RPD.
Q48) What is MUDE?
Multi user development environment is used to work multiple people on a same RPD and to deploy their work without disturbing others work.
Q49) What is usage tracking?
To find the usage of reports by the users called usage tracking, We need set of configurations are needed for this Usage tracking.
Q50) What is implicit fact column?
To guide the OBIEE to build query by using specific tables we will define implicit fact column in Presentation layer columns.
Q51) What are the time series functions?
- To date
- Period Rolling