File Name: obiee 11g interview questions and answers .zip
Explore Now! These questions and answers are suitable for both freshers and experienced professionals at any level.
It is a business intelligence system for the enterprise that delivers abilities for reporting, online analytical processing OLAP , ad hoc query and analysis dashboards, and scorecards. Presentation server : The presentation server is responsible to convert the request comes from end user to logical SQL and sends it to Oracle BI Server. Oracle BI server : The main task of Oracle BI server is converting the logical sql to Physical sql so that database will understand the sql. Oracle BI server converts the logical sql to physical sql so that database syntactically identifies the query and send it to the Database. The sources must be modeled as snowflakes or star schema for efficient result In the case of multiple sources connecting directly in OBIEE, it has to be used.
It is a business intelligence system for the enterprise that delivers abilities for reporting, online analytical processing OLAP , ad hoc query and analysis dashboards, and scorecards. The client component is further divided into web-based obiee client and non-web based client. Sources like Relational Databases, Cubes or Flat files can be connected to Obiee with following constraints,. LTS or Logical Table Source is created when you drag and drop a column from a table that is not presently being used in your logical table. A physical table containing such column is referred as LTS. A session variable can be a system variable and non-system variable. It is initialized at login time for each user.
Ans: By clicking on Administration and Manage dashboards and by adding a column selector we can create an interactive Dashboard. Ans: We can give a column as updatable and then view the reports, this option is called write-back option. By this, we can create reports from two subject areas. Repository variable: This variable is used for the whole repository. Session variable: session variable is of two types: system variable and nonsystem variable.
There are a lot of opportunities for many reputed companies in the world.
Views 9 Downloads 1 File size KB. So, in simple words it is a report generation tool such as crystal reports. What Business Intelligence BI means by definition? It is a protocol and a technique to analyze and report about the state of the business data at a particular time.
How will you create Interactive Dashboards? What is write-back in obiee? Click on modify and then click on sort order by icon on the relevant column in the criteria pane. 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. By clicking on Administration and Manage dashboards and by adding column selector we can create interactive Dashboard.
Looking for OBIEE Interview Questions with Answers? Here we have 6Q) What are the different types of variables in OBIEE 11g? explain. Ans: There are two.
There are many ways to extract the sql: a. You will find the SQL for that User. 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. Interview Questions.
Our experts prepared these OBIEE interview questions to accommodate freshers level to most experienced level technical interviews. Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query? If the query runs normally in TOAD then we need to make changes in the repository.
Wisdomjobs will provide you the list of subject-specific questions frequently asked during the interview. Its general infrastructure delivering and producing enterprise reports, dashboards, scorecards, ad-hoc analysis, and OLAP analysis provides a wealthy end-user experience. Question 1. Mention What Is Obiee?
Your email address will not be published. Required fields are marked *