OBIEE Architecture

OBIEE(Oracle Business Intelligence Enterprise Edition) latest version is 11.1.1.5 or 6.It is a reporting tool for generate the reports to analyse the data.OBIEE has 2 default servers BI server and Presentation server.It has 6 components in the architecture

1.Presentation services(Answers or Analysis)

2.Presentation server

3. Repository

4. BI server

5. Database connection(ODBC (Open database connectivity) or OCI (Oracle call Interface))

6. Enterprise Data ware House

Presentation Services:This is a front-end page for users or clients.User can see the reports from the Answers or Analysis  page.It contains answers, dashboards, account details privileges of the specific users.We can the reports and dashboards based on the client requirement.By starting the presentation server,we can operate the presentation services.

Repository:It is also called as RPD or RCU.Metadata settings are configured in the rpd level.It has 3 layers

Physical layer:It has the direct connection with the database.We can apply the joins between fact tables and dimension tables based on the data-modelling.

Business model and mapping layer:The logical changes will be done here like creating logical joins(complex joins),new columns or tables,hierarchies etc.

Presentation layer:The objects will be visible to the users what placed in the presentation layer.We can apply the security setting in the presentation layer.

We can operate the Repository settings by starting the BI server.we can open the RPD in either online or offline mode

Database connection:This is the database connection between database and OBIEE.The database connection  is either ODBC or OCI.

Data-ware House: Data-ware House is a huge data storage space for retrieving data.

OBIEE architecture interview questions