Frequently asked obiee Interview Questions with detailed answers and examples. Tips and Tricks for cracking OBIEE interview. Here are top 63 objective
Frequently asked obiee Interview Questions with detailed answers and examples. Tips and Tricks for cracking OBIEE interview. Here are top 63 objective type admin interview questions and answers pdf OBIEE Interview questions and their answers are given just below to them.
We have taken full care to give correct answers for all the questions. Do comment your thoughts Happy Job Hunting! Explain the Architecture of OBIEE 11g and function of each components? Data sources and recover the data back to the Engine and presents to the presentation Services . How we can extract sql from OBIEE for reports? Change the request and click Advanced in that you get xml code and also the actual sql. In the catalog Manager click Tools-Create Report .
Click Request SQL and save the sql to the physical path in your PC. Security and enable the log level to 2 by clicking properties for the user, then go to the NQ Query. You will find the SQL for that User. How can you sort in Reports in OBIEE 11g? How we can do different types of narrative Reports in OBIEE? 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 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. 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?
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? There are two types of variables in OBIEE 11g.
This variable is used for the whole repository. Examples of non system variables are user defined filters. How will you enable or disable caching in the system level and table 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?
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. 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. 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. What are the different layers of OBIEE 11g Repository? How many types of 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? Ibot is an arrangement agent, used to arrange reports to be sent across many devices such as email, pager, mobile, other devices etc. What are different types of joins that are possible in OBIEE RPD? 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? Have you worked in dashboard? By clicking on the cancel button, we can stop a exact report placed on the dashboard. 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.