File Name: obiee 11g interview questions and answers .zip
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? 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.
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.
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. What is aggregate navigation? Aggregate tables store pre-computed results, which are measures that have been aggregated typically summed over a set of dimensional attributes. Using aggregate tables is a very popular technique for speeding up query response times in decision support systems.
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. Two types exist and these are the repository variables and session variables.
Explore Now! These questions and answers are suitable for both freshers and experienced professionals at any level. Its proven architecture and common infrastructure producing and delivering enterprise reports, dashboards, ad-hoc analysis, and OLAP analysis provide a rich end-user experience. It contains following information:. Physical layer joins are called as physical joins and attributes can be joined using either equal operator or using any expression.
24) Mention how you will change the port of Obiee? You can change port of Obiee by changing its port in nazarethsr.org · Download PDF.
There are a lot of opportunities for many reputed companies in the world. This course will help you to achieve excellence in this domain. SQL is constructed by the user and it is passed to an analytic engine. Then the data is recovered back to the analytical engine and it is presented to the services related to the presentation.
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.
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. From the Criteria Pane of the Report. How we can Port changes for dashboards, reports, rpd from development to production?
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.
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.
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. Examples of nonsystem variables are user-defined filters.
Новая диагностика. Что-нибудь из Отдела обеспечения системной безопасности.
Она была небольшой, приблизительно, наверное, метр на метр, но очень тяжелой. Когда люк открылся, Чатрукьян невольно отпрянул. Струя горячего воздуха, напоенного фреоном, ударила ему прямо в лицо. Клубы пара вырвались наружу, подкрашенные снизу в красный цвет контрольными лампами.
Your email address will not be published. Required fields are marked *