Techno Level 1: Basic Level
1.
Overview of OBIEE Real Time Project
1.1. Why
OBIEE?
1.2. What
is OBIEE?
1.3. OBIEE
Real Time Project Types
1.3.1. OBIEE without ETL
(Directly from OLTP or any Database)
1.3.2. OBIEE with ETL
(OLAP using ETL Tools like Informatica, DAC, and ODI)
1.3.3. OBIEE with OBIA or Oracle BI Apps
(Using OBIA 7.9.6.4, OBIA 11.1.1.10.1)
1.4. OLTP vs
OLAP
1.5. OBIEE
11g Installation
1.5.1. Certification Matrix
1.5.2. Downloads (OTN & edelivery)
1.5.3. Installation Types
1.5.4. Installation
1.5.4.1. On Windows Server
1.5.4.2. On Linux Server
1.5.4. Bugs and Patches (Oracle Support)
2.
OBIEE Introduction
2.1.
History of OBIEE
2.2.
Components and Types
2.3. Data
Modelling Elements
2.3.1. Columns
2.3.2. Tables
2.3.3. Schemes
3.
BI ADMIN TOOL
3.1.
Physical Layer
3.1.1. Hands on Main Objectives
3.2. BMM
Layer
3.2.1. Hands on Main Objectives
3.3.
Presentation Layer
3.3.1.
Hands on Main Objectives
3.4.
Validating and Testing a RPD
4.
OFMW Enterprise Manager
4.1.
Overview
4.2.
Deploying or Loading RPD and Catalog
4.3.
Disabling Cache
4.4.
Setting up Query Log
5.
BI Analytics
5.1. Accessing
Analytics for First Time
5.2. Creating
or Developing First Analysis
5.3. Enhancing
an Analysis by Adding views
6.
BI Interactive Dashboards
6.1. Exploring
and Editing My Dashboard
6.2. Building
or Developing First Dashboard
6.3.
Catalog
Techno Level 2: Experienced Level
7.
OBIEE Architecture
7.1.
Physical Architecture
7.2.
Logical Architecture
8.
Weblogic Server (WLS) Admin Console
8.1.
Overview
8.2.
Creating a user
8.3.
Creating a group
8.3.1.
Assigning a user or users to a group or groups
8.4.
Creating an application role in OFMW EM
8.4.1. Assigning a group or groups to an application role or roles
8.5. Deleting
users, groups and roles.
9.
BI ADMIN TOOL
9.1. Adding
Multiple Sources
9.2.
Calculations
9.2.1. Calculations based on logical columns
9.2.2. Calculations based on Physical columns
9.2.3. Calculations using Calculations wizard
9.3.
Dimensional Hierarchies
9.3.1. Level based Hierarchy
9.3.2. Time Dimension Hierarchy
9.3.3. Unbalanced Hierarchies (Ragged and Skipped)
9.3.4. Parent-Child Hierarchy
9.4. Level
Based Measures (LBM)
9.5.
Modelling Time Series Data
9.6. Variables
9.6.1. Repository Variables
9.6.2. Session Variables
9.6.3. Presentation Variable
9.6.4. Request Variable
9.6.5. Global Variable
10.
BI Analytics
10.1. Working
with analyses and properties
10.2.
Working with filters and Prompts
10.3.
Working with Views
10.4.
Advance features of Analysis
10.4.1. Cross Subject Analysis
10.4.2. Combining the similar request
11.
BI Interactive Dashboards
11.1. Working
with Dashboard and properties
11.2. Dashboard
Prompts
11.3.
Catalog Manager
12.
BI Delivers
12.1.
Configuration of Scheduler and Mail Server.
12.2.
Creating a Delivery Device
12.3.
Creating a Delivery Profile
12.4.
Creating and Scheduling an Agent (iBOT)
12.5.
Job Manager
13.
Security
13.1
Authentication
13.1.1. LDAP Authentication
13.1.2. External Table Authentication
13.1.3. SSL and SSO Authentication
13.2
Authorization
13.2.1. Object Level
13.2.2. Data Level or Row Level
13.2.3. Precedence and Inheritance
13.3
Direct Database Request (DDR)
14.
Performance Tuning
14.1.
Cache management
14.2.
Connection Pools
14.3.
Aggregate tables
14.4.
Partitioning and Fragmenting of Data
14.5.
Tuning Thread pooling using WLS Admin Console
14.6.
Indexing on Tables
14.7.
Usage tracking
15.
Troubleshooting
15.1.
Troubleshooting using logs
15.2.
Troubleshooting using BI Admin Tool
15.3.
Troubleshooting using OFMW EM
15.4.
Troubleshooting using WLS Admin Console
15.5.
Troubleshooting using Configuration files
16.
BI Publisher
16.1.
Overview
16.2. BI
Publisher Administration
16.3. BI
Publisher Reports
16.3.1. Reports based on any Database
16.3.2. Reports based on OBIEE Reports
16.3.3. Reports based on OBIEE Subject Area
16.3.4. Reports based on RTF Templates
Techno Level 3: Interview Level (Technical +SME+ Managerial Rounds)
Note: At this level, Real Time Scenarios(S),
Interview questions (I) and Advanced
topics (A) and Topic wise Expected questions (E) are discussed from
OBIEE,
OBIA, BIP, SQL, Informatica, DAC, ODI and Linux.
Interview Level – Real Time Questions
And Answers with Explanation
I.19. On a scale of 5, how you rate yourself in BI
Admin Tool? [OR]
On a
scale of 10, how you rate yourself in OBIEE? --- Oracle India
(Hyderabad), PWC
(Bangalore), Capegemini (Mumbai), Accenture
(Kolkata),Dubai Islamic
Bank (UAE).
S.2. What are the hard or tough reports or
requirement you had done? --- Oracle
India (Hyderabad), Oracle
India (Bangalore), Dell
(Bangalore),British
Telecom (Bangalore),
Accenture (Kolkata), Deyaar (Dubai).
I. Do you
have done any performance tuning? How?----- Oracle India
(Bangalore), Dell
(Bangalore), PWC (Bangalore).
S.47. If copy and paste options are disabled how will
you do changes to a report?----
Genpact (Hyderabad)
A.I. Did you enable cache in your project? [OR] What
are the types of cache? ----
Oracle India
(Bangalore), Accenture (Kolkata),TCS (Bangalore)
I6. What is a degenerate dimension? ------ Capegemini
(Mumbai)
I7. What is a junk dimension?------ Sapient (Bangalore)
I.52. Write a query in SQL to count duplicates in a
table and then deleting duplicates.-
--- PWC
(Bangalore), British Telecom (Bangalore)
I.14. Do you have done code migration? ---- Oracle India
(Bangalore), Dell
(Bangalore), PWC
(Bangalore), Accenture (Kolkata).
I.43. Can we assign different presentation tables to
different users? How? ------ PWC
(Bangalore), Oracle
India (Bangalore), Dubai Islamic Bank (DIB) (UAE)
I.47. In dashboard can we hide certain reports based
on a condition? How? ------
Accion Labs (Malaysia)
I.S.48.Can we add images to analysis or report? How?----- Raqmiat
(Dubai), ITC
Infotech (Bangalore)
…….
More Questions…………………………...100+ Interview Questions with Answers
Interview Level – Expected Questions
And Answers with Explanation
I.Introduction:
1. What is the end to end life cycle (SDLC) of
OBIEE?
3. What are the OBIEE 11g components and types?
4. What are the types of tables and columns in
OBIEE?
8. What is meant by conformed dimensions? ------Genpact
(Hyderabad), TCS
(Bangalore)
9. Difference between snow flake and star schemas. ------ Oracle
India (Hyderabad),
Brillio (Bangalore),
Genpact (Hyderabad)
10. What is surrogate key? —Genpact (Hyderabad)
----------
II.BI Admin Tool(RPD)
A.Introduction:
1. What is use of BI admin tool?
2. What do you mean by metadata and RPD?
3. What are the three layers in RPD?----- Deyaar
(Dubai),ITC InfoTech,Tech
Mahindra (Hyderabad)
4. What did an RPD stores and what is it
size general and in your Project? -----
Genpact (Hyderabad), British
Telecom (Bangalore),HCL (Chennai)
--------
B.Physcial Layer:
1. What are objects of physical layer?
2. Is OBIEE supports multiple databases?
3. Can we access all the tables of a
database using one connection pool?
4. What are the connection types to
import metadata in RPD?
6. What are the steps of importing
metadata from DWH to RPD?
7. What are the joins in OBIEE 11g?-----Genpact
(Hyderabad),HCL (Chennai),
Oracle India (Hyderabad),
Sapient (Banglore),KPMG (Bangalore)
-------
J. Modelling Time Series Data
1. Are there any analytical function in
OBIEE?
2. What are Time series functions and
uses?-------
Capegemini (Pune)
3. What is the analytical function used
in period rolling function in OBIEE 11g?
4. What is Chronological key? ---------TCS
(Bangalore),HCL (Chennai)
----------
More Excepted questions…………………...………….200+ questions and answers
Additional Topics:
A1.
OBIA 7.9.6.4
A1.1.
Architecture
A1.2.
Installation and Configuration
A1.3.
Informatica
A1.4.
DAC
A2.
OBIA 11.1.1.10.1
A2.1.
Architecture
A2.2.
Installation and Configuration
A2.3.
ODI
A3.
SQL
A4.
Linux
