OBIEE Interview Questions & Answers
1Q) How will you create Interactive Dashboards?
2Q) What is write-back in obiee?
Ans: We can give a column as updatable and then view the reports, this option is called write-back option.
3Q) How will you execute Direct SQL in OBIEE?
Ans: By clicking Direct Database Request below the subject area in we can execute Direct SQL in OBIEE.
4Q) How OBIEE Developer can create reports from two subject areas?
Ans: 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 reports from two subject areas.
5Q) How we can Port changes for dashboards, reports, rpd from development to production?
Ans: For the RPD we can use the Merge option in Admin Tool and for dashboards and reports we can use the Content Accelerator Framework.
Interested in mastering OBIEE Training? Enroll now for a FREE demo on "OBIEE Training".
6Q) What are the different types of variables in OBIEE 11g? explain
Ans: 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 is of two types: system variable and nonsystem variable. The system variable uses NQ_SESSION. Examples of nonsystem variables are user-defined filters.
7Q) Explain the Architecture of OBIEE 11g and the function of each component?
Ans: 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.
8Q) How we can extract SQL from OBIEE for reports?
Ans: 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, the Manager clicks Tools-Create Report. In the Create Report Window –> Click Request SQL and save the SQL to the physical path in your PC. c. Enable Log level 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.
9Q) How can you sort in Reports in OBIEE 11g?
Ans: Click on modify and then click on the sort (order by the icon) on the relevant column in the criteria pane.
10Q) How we can do different types of narrative Reports in OBIEE?
Ans: By clicking modify the 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.
11Q) How will you enable or disable caching in the system level and table level?
Ans: 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.
12Q) How will you go about adding an additional column to the repository in the presentation layer?
Ans: Check if the table is already existing if so add in the physical layer, then click on BMM and then the Presentation layer, then reload server metadata, then it will be visible to all users.
13Q) How will affect the changes for a report if for certain users only the column headings in the report should be changed?
Ans: Using session variables for that user.
14Q) What is a table alias in OBIEE 11g? Where and how will you create it?
Ans: A 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.
15Q) Have you created a Hierarchy in OBIEE 11g? if so where and how?
Ans: Yes, we can create a hierarchy in the 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.
16Q) What are Level Based Metrics? How we can create it?
Ans: 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.
17Q) Different layers of the OBIEE 11g Repository?
Ans: The different layers of the OBIEE 11g Repository are:
18Q) What is Authentication? How many types of authentication?
Ans: 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
19Q) What is the bridge table?
Ans: 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 the same columns in both tables.
20Q) How Time based triggered report can be generated?
Ans: Using Scheduler – ibots we can generate a time-based triggered report.
21Q) What are the different types of joins that are possible in OBIEE RPD?
Ans: 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
22Q) How we can have two different columns from two different tables or subject areas?
Ans: Using confirmed dimensions, we can fetch many metrics across various facts, but the join should be of the same level of data detail.
23Q) How can we use saved filters and where we will save the filters?
Ans: Shared Folders-XYZ Folder- It has two folders a. Prompts b. Reports
24Q) Have you worked on the dashboard? when we run a dashboard? how will we stop the dashboard report run automatically?
Ans: By clicking on the cancel button, we can stop an exact report placed on the dashboard.
25Q) Define the 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.
26Q) Define repository in terms of Siebel Analytics?
Ans: 1.Repository stores the Metadata information. Siebel repository is a file system, extension of the repository file. rpd. METADATA REPOSITORY
2.With Siebel Analytics Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity are stored in metadata repositories.
3. Every metadata repository can store many business models. Siebel Analytics Server can access many repositories.
27Q)Explain the end to the end life cycle of Siebel Analytics?
Ans: 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 a dashboard or use answers for reporting. 6. Define security 7. Based on performance, decide aggregations and/or caching mechanism. 8. Testing and QA.
28Q) How does Siebel Architecture work? Explain the three layers.
Ans: There are five parts of Siebel Architecture.
1. Clients 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. The repository divided into three layers 1. Physical – Signifies the data Sources 2. Business – copies the Data sources into Facts And Dimension 3. Presentation – Specifies the user's view of the model; rendered in Siebel's answer.
29Q) If we have 3 facts and 4 dimensions and we need to join would you recommend joining fact with fact? If no then what is the option?
Ans: In the BMM layer, we can create one logical table (fact) and add the 3 fact table as a logical table source.
30Q) What is a connection pool and how many connection pools did we have in our last project?
Ans: A 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
31Q) Define JDK and why do we need it?
Ans: Java Development Kit (JDK), is a software package that contains the minimal set of tools needed to write, compile, debug, and run Java applets.
32Q) Oracle doesn’t recommend Opaque Views because of performance considerations, so why/when do we use them?
Ans: An opaque view is a physical layer table that contains a select statement. An opaque view should be used only if there is no other option.
33Q) Can we migrate the presentation layer to a different server?
Ans: No, we can't migrate the presentation layer to a different server rather we have to migrate the whole web & rpd files
34Q) How we can identify the dimension tables and how we can decide them during the Business/Data modeling?
Ans: Dimension tables contain descriptions about data analysts which is used as a 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
35Q) Why do we have multiple LTS in the BMM layer? What is the purpose?
Ans: To improve the performance and query response time we have multiple LTS in BMM.
36Q) What is the full form of rpd?
Ans: There is no full form for rpd as such, it is just a repository file which is known as Rapid file Database.
37Q) How we can disable cache for only 2 particular tables?
Ans: We can disable cache in the physical layer, by right-clicking on the table there we can have the option which defines cacheable
38Q) 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.
Ans: We have to make a dubbed table in the physical layer.
39Q) What type of protocol did we use in SAS?
Ans: TCP/IP type protocol.
For an in-depth understanding of OBIEE click on
- New Features in OBIEE11g
- Checking Out a Project in OBIEE 11g
- Making Changes to the Repository in OBIEE