OBIEE Interview Questions & Answers
How will you create Interactive Dashboards ?
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.
How will you execute Direct SQL in OBIEE?
By clicking Direct Database Request below the subject area in we can execute Direct SQL in OBIEE.
How OBIEE Developer can 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. By this we can create report from two subject areas.
How we can Port changes for dashboards, reports, rpd from development to production?
For the RPD we can use the Merge option in Admin Tool and for dashboards and reports we can use Content Accelerator Framework.
What are the different types of variables in OBIEE 11g? explain
There are two types of variables in OBIEE 11g.
a. Repository variable:
This variable is used for the whole repository.
b. Session variable:
session variable are of two types: system variable and non system variable.
System variable uses NQ_SESSION. Examples of non system variables are user defined filters.
Explain the Architecture of OBIEE 11g and function of each components?
OBIEE Comprises Presentation Services,Oracle BI Server:
The user constructs sql and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) describes the physical sql to the Datasources and recover the data back to the Engine and presents to the presentation Services.
How we can extract sql from OBIEE for reports?
There are many ways to extract the sql:
a. Change the request and click Advanced in that you get xml code and also the actual sql.
b. 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.
c. Enable Loglevel to 2 in the OBIEE 11g Administration Tool from Manage-> 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.
d. By clicking Administration->Manage sessions-> view sql.
How can you sort in Reports in OBIEE 11g?
Click on modify and then click on sort (order by icon) on the relevant column in the criteria pane.
How we can 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 so on and we can also give a heading for No Results by clicking the Narrative view.
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 we want to enable the cache at table level , open the repository in offline mode This should be different from the current repository and click enable or disable the cache.
How will you go about adding additional column to the repository in the presentation layer?
Check if the table is already existing if so add in physical layer ,then click on BMM and then Presentation layer, then reload server metadata ,then it will be visible to all users.
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.
What is a table alias in OBIEE 11g? Where and how will you create it?
Table alias is used for creating self joins. Table alias can be created by right clicking the table in the physical layer then click alias.
Have you created Hierarchy in OBIEE 11g. if so where and how?
Yes, we can create hierarchy in BMM Layer of OBIEE in dimensions for the dimension tables. This can be done by right clicking the dimension table and click create dimension and then we can manually define the hierarchy and its levels.
What is Level Based Metrics? How we can create it?
Level-base metrics means, having a measure held at a certain level of the dimension. Examples Monthly Total Sales or Quarterly Sales
To create a level based measure, create a new logical column based on the original measure .Drag and drop the new logical column to the appropriate level in the Dimension hierarchy.
Different layers of OBIEE 11g Repository?
The different layers of OBIEE 11g Repository are:
3. Mapping Layer
4. 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
a. Operating system authentication
b. External table authentication
c. Database authentication
d. LDAP authentication
What is a bridge table ?
If we want to connect two tables where there is no relationship we can use a thrived 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 are different types of joins that are possible in OBIEE RPD?
1. Complex Join –it uses multiple conditions, such as A.ROW_WID = B.ROW_WID AND / OR A.A_WID = B.B_WID
2. Natural Join
How we can have two different columns from two different tables or subject areas?
Using confirmed dimensions,we can fetch many metrics across various facts, but the join should be of same level of data detail.
How can we use saved filters and where we will save the filters?
Shared Folders-XYZ Folder- It have two folders
Have you worked in dashboard? when we run a dashboard? how will we stop the dashboard report run automatically?
By clicking on the cancel button, we can stop a exact report placed on the dashboard.
Define surrogate key.
A surrogate key is an artificially generated key, usually a number. A surrogate key, in the level aggregate table, simplifies this join and removes unnecessary columns from the fact table, resulting in a smaller-sized fact table.
Define repository in terms of Siebel Analytics.
1.Repository stores the Meta data information. Siebel repository is a file system ,extension of the repository file. rpd.
META DATA REPOSITORY
2.With Siebel Analytics Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories.
3.Every metadata repository can store many business models. Siebel Analytics Server can access many repositories.
Explain the end to end life cycle of Siebel Analytics?
Siebel Analytics life cycle
1. Collect Business Requirements
2. Recognize source systems
3. Plan ETL to load to a DW if source data doesn’t exist.
4. Build a repository
5. Build dashboard or use answers for reporting.
6. Define security
7. Based on performance, decide an aggregations and/or caching mechanism.
8. Testing and QA.
How does Siebel Architecture works? Explain the three layers.
There are five parts of Siebel Architecture.
2. data sources
3. Siebel analytics Web Server data sources
4. Siebel analytics scheduler
5. Siebel analytics server
Metadata represents the analytical Model which is created using the siebel Analytics Administration tool.
Repository divided into three layer
1. Physical – Signifies the data Sources
2. Business – copies the Data sources into Facts And Dimension
3. Presentation – Specifies the users view of the model ; rendered in Siebel answer.
If we have 3 facts and 4 dimension and we need to join would you recommend joining fact with fact? If no than what is the option?
In the BMM layer,we can create one logical table (fact) and add the 3 fact table as logical table source.
Desired to gain proficiency on OBIEE 11g ?
Explore the blog post on OBIEE 11g training online to become a pro in OBIEE 11g
What is connection pool and how many connection pools did we have in our last project?
Connection pool is needed for each and every physical database.
It contains material about the connection to the database, not the database itself.
We can use either shared user accounts or pass-through accounts -Use: USER and PASSWORD for pass through.
We can have many connection pools for each group to avoid waiting
Define JDK and why do we need it?
Java Development Kit (JDK), is a software package that contains the minimal set of tools needed to write, compile, debug, and run Java applets.
Oracle doesn’t recommend Opaque Views because of performance considerations, so why/when do we use them?
An opaque view is a physical layer table that contain select statement. An opaque view should be used only if there is no other option.
Can we migrate the presentation layer to a different server?
No we cant migrate the presentation layer to a different server rather we have to migrate the whole web & rpd files
How we can identify the dimension tables and how we can decide them during the Business/Data modeling?
Dimension tables contain descriptions about data analysts which is used as query in the database. Every table contains a primary key that contains one or more columns; each row in a table is uniquely identified by its primary-key value or values
Why do we have multiple LTS in BMM layer?What is the purpose?
To improve the performance and query response time we have multiple LTS in BMM.
What is the full form of rpd?
There is no full form for rpd as such, it is just a repository file which is known as Rapidfile Database.
How we can disable cache for only 2 particular tables?
We can disable cache in the physical layer, by right clicking on the table there we can have the option which define cacheable
How we can split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
We have to make a dubbed table in the physical layer.
What type of protocol did we use in SAS?
TCP/IP type protocol.
For indepth understanding of OBIEE click on