Interview Questions

OBIEE Interview Questions and Answers

OBIEE Interview Questions and Answers

Interview Questions January 12, 2019

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

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.

Best OBIEE Interview Questions and answers

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.

OBIEE Interview Questions and answers for the job placements

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
  • Security
  • Caching
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?

Manual purging

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?
  • Bar
  •  Line
  •  Area
  •  Pie
  •  Line-Bar
  •  Time Series Line
  •  Pareto
  •  Scatter
  •  Bubble
  •  Radar
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?
  • Ago
  • To date
  • Period Rolling

Besant Technologies – Chennai & Bangalore Branch Locations

Besant Technologies - Velachery Branch

Plot No. 119, No.8, 11th Main road, Vijaya nagar,

Velachery, Chennai - 600 042

Tamil Nadu, India

Landmark - Reliance Digital Opposite Street

Besant Technologies - Tambaram Branch

No.2A, 1st Floor, Duraisami Reddy Street,

West Tambaram, Chennai - 600 045

Tamil Nadu, India

Landmark - Near By Passport Seva

Besant Technologies - OMR Branch

No. 5/318, 2nd Floor, Sri Sowdeswari Nagar,

OMR, Okkiyam Thoraipakkam, Chennai - 600 097

Tamil Nadu, India

Landmark - Behind Okkiyampet Bus Stop,

Besant Technologies - Porur Branch

No. 180/84, 1st Floor, Karnataka Bank Building,

Trunk Road, Porur, Chennai - 600 116

Tamil Nadu, India

Landmark - Opposite to Gopalakrishna Theatre

Besant Technologies - Anna Nagar Branch

Plot No:1371, 28th street kambar colony,

I Block, Anna Nagar, Chennai - 600 040

Tamil Nadu, India

Landmark - Behind Reliance Fresh

Besant Technologies - T.Nagar Branch

Old No:146/2- New No: 48,

Habibullah Road,T.Nagar, Chennai - 600 017

Tamil Nadu, India

Landmark - Opposite to SGS Sabha

Besant Technologies - Thiruvanmiyur Branch

22/67, 1st Floor, North mada street, Kamaraj Nagar

Thiruvanmiyur, Chennai 600041

Tamil Nadu, India

Landmark - Above Thiruvanmiyur ICICI Bank

Besant Technologies - Siruseri Branch

No. 4/76, Ambedkar Street, OMR Road, Egatoor, Navallur,

Siruseri, Chennai 600130

Tamil Nadu, India

Landmark - Near Navallur Toll Gate, Next to Yamaha Showroom

Besant Technologies - Maraimalai Nagar Branch

No.37, Ground Floor, Thiruvalluvar Salai,

Maraimalai Nagar,Chennai 603209

Tamil Nadu, India

Landmark - Near to Maraimalai Nagar Arch

Besant Technologies - BTM Layout Branch

No 2, Ground floor, 29th Main Road,

Kuvempu Nagar,BTM Layout 2nd Coming from Silkboard,

AXA company signal, Stage, Bangalore - 560 076

Karnataka, India

Landmark - Next to OI Play School

Besant Technologies - Marathahalli Branch

No. 43/2, 2nd Floor, VMR Arcade,

Varthur Main Road, Silver Springs Layout,

Munnekollal, Marathahalli, Bengaluru - 560037

Karnataka, India

Landmark - Near Kundalahalli Gate Signal

Besant Technologies - Rajaji Nagar Branch

No. 309/43, JRS Ecstasy, First Floor,

59th Cross, 3rd Block, Bashyam Circle,

Rajaji Nagar, Bangalore - 560 010

Karnataka, India

Landmark - Near Bashyam Circle

Besant Technologies - Jaya Nagar Branch

No. 2nd Floor,1575,11th Main Road,

4th T-Block, Pattabhirama Nagar,

Jaya Nagar, Bangalore - 560 041

Karnataka, India

Landmark - Opposite to Shanthi Nursing Home

Besant Technologies - Kalyan Nagar Branch

No.513, 4th Cross Rd

2nd Block, HRBR Layout,

Kalyan Nagar, Bangalore - 560 043

Karnataka, India

Landmark - Opposite to kalayan nagar Axis Bank

Besant Technologies - Electronic City Branch

No. 7, 3rd Floor, Ganga Enclave,

Neeladri Road, Karuna Nagar, Doddathoguru Village,

Electronics City Phase 1, Electronic City,

Bangalore - 560100, karnataka, India

Landmark - Adjacent to HDFC Bank and State Bank Of India

Besant Technologies - Indira Nagar Branch

No.54, 1st Floor,

5th Main kodihalli,

Bengaluru, Karnataka 560008, India

Landmark - Behind Leela Palace Hotel,

Besant Technologies - HSR Layout Branch

Plot No. 2799 & 2800, 27th Main,

1st Sector, HSR Layout,

Bengaluru, Karnataka 560102, India

Besant Technologies - Hebbal Branch

No.29, 2nd Floor, SN Complex,

14th Main Road, E-Block Extention, Sahakara Nagar,

Bengaluru, Karnataka -560092, India

Scroll Up