OBIEE Interview Questions

OBIEE Interview Questions

  • Explain the Architecture of OBIEE and what each components do?

OBIEE Consists of Presentation Services(Web),Oracle BI (Analytics Engine) Server
The client (Answers) constructs sql and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) parses the physical sql to the Datasources and retrieve the data back to the Engine and presents to the presentation Services.

OBIEE Interview Questions

  • How to get sql from obiee for reports?

There are many ways to get the sql

Modify the request and click Advanced in that you get xml code and also the actual sql.
In the catalog Manager click Tools –>Create Report .In the Create Report Window –> Click Request SQL and save the sql to the physical path in your PC.
Enable Loglevel to 2 in the OBIEE Admin Tool from Mange-> Security and enable the log level to 2 by clicking properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.
By clicking Administration->Manage sessions-> view sql.

OBIEE Interview Questions

  • How will you do sort in Reports in OBIEE Answers

Click modify and then click sort (order by icon) on the relevant column in the criteria pane.

OBIEE Interview Questions

  • How will you do different types of narrative Reports in OBIEE?

By clicking modify request and Narrative View and by giving @1 for the first column result and @2 for the 2nd column and son on and we can also give a heading for No Results by clicking the Narrative view.

OBIEE Interview Questions

OBIEE Interview Questions

  • What is write-back in obiee?

In Reports of Answer you can give a column as updatebale and then view the reports,this option is called write back.

OBIEE Interview Questions

  • How will you execute Direct SQL in OBIEE?

By clicking Direct Database Request below the subject area in Answers.

OBIEE Interview Questions

  • How will you create report from two subject areas

From the Criteria Pane of the Report Created from First Subject Area
come to the bottom of the page and click combine request. but the options are limited for combining like union etc..

OBIEE Interview Questions

  • How will you Port changes for dashboards,reports,rpd from development to

For the RPD use the Merge option in Admin Tool and for dashboards and reports use Content Accelerator Framework.

OBIEE Interview Questions

  • What are the different types of variables in OBIEE? explain

There are two types of variables in obiee.

Repository variable.
This variable is for the whole repository.
session variable . session variable can be system variable and non system variable. system variable uses NQ_SESSION. —- (system reserved variable). examples of non system variables are user defined filters etc.

OBIEE Interview Questions

  • How will you enable or disable caching in the system level and table level?

In the NQSConfig.ini file use ENABLE under CACHE Section for System Level
for tables .If you want to enable the cache at table level , open the repository in offline mode(not the current working repository). this should be different from the current repository and click enable or disable the cache . right click the table and properties and click the cache or deselect the cache. then merge the repository with the current working one.

OBIEE Interview Questions

  • How will you go about adding additional column to the repository in the
    presentation layer?

Check whether the table is already existing if so add in physical layer ,then BMM and then Presentation layer, then reload server metadata ,then it will be visible to all users.

 OBIEE Interview Questions

  • How will effect the changes for a report , if for certain users only the column
    heading in the report should be changed?

Using session variables for that user.

OBIEE Interview Questions

  • What is a table alias in obiee? and where and how will you create it.

Table alias can be created by right clicking the table in the physical layer then click alias,
Table alias is mostly used for creating self joins.

  • How will you create Interactive Dashboards ?

By clicking on Administration and Manage dashboards and by adding column selector we can create interactive Dashboard.

  • What is write-back in obiee ?

We can give a column as updatable and then view the reports,this option is called write back option.

  • What are the different layers of OBIEE 11g Repository?

Physical Layer.
Business Model.
Mapping Layer.
Presentation Layer.

  • What is Authentication? How many types of authentication.

Authentication is the procedure by which a system confirms, through the use of a user
Operaing system authentication.
External table authentication.
Database authentication.
LDAP authentication

  • What is a bridge table ?

If we want to connect two tables where there is no relationship we can use a third bridge table for connecting them which will have same columns in both tables.

  • How Time based triggered report can be generated?

Using Scheduler – ibots we can generate time based triggered report.

  • What is ibot?

Ibot is an arrangement agent, used to arrange reports to be sent across many devices such as email, pager, mobile, other devices etc.


This information box about the author only appears if the author has biographical information. Otherwise there is not author box shown. Follow YOOtheme on Twitter or read the blog.
+91 9952948899