OBIEE architecture interview questions and answers

What are the major components in the OBIEE architecture?
a. Client
b. Presentation services(along with cache)
c. Repository
d. Database connection
e. Enterprise datawarehouse
f. Scheduler(along with cache)

What are the different layers of OBIEE Repository?
a. Physical Layer
b. Business Model and Mapping Layer
c. Presentation Layer

What are the folders available in OBIEE?

• Oracle BI(Administration)
• Oracle BIdata(analytics)

The folder names may change with the OBIEE 11g.

What are the Key Configuration Files in OBIEE

• NQSConfig.ini,
• DBfeatures.ini,
• NQSCluster.ini,
• odbc.ini,
• instanceconfig.xml

What are the different Log files in OBIEE?

• NQServer.log
• NQSQuery.log
• NQSAdministration.log
• NQS Scheduler.log

What are the minimum services needed to load a repository file onto memory and view a dashboard which has reports that have been refreshed on a scheduled basis?
BI server (Administration Tool)
Presentation Server (Analytics or Answers)
Scheduler server (Scheduling the jobs)

What is the location of the administration configuration files?
drive:\OBIEE 11g\instances\instance1\config\oracleBIservercomponent\
coreapplication_obis1\file name

What is the location of the repository?
drive:\OBIEE 11g\instances\instance1\bifoundation\oracleBIservercomponent\
coreapplication_obis1\repository

What is the location of the presentation services configuration files?
drive:\OBIEE 11g\instances\instance1\config\oracleBIpresentationservices
component\coreapplication_obis1\instanceconfig.xml

What is the location of the administration log files?
C:\OBIEE11g\instances\instance1\diagnostics\logs