File Name: obiee 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.
Answer: The logical table created at the BMM layer can be based on the data from a single physical layer table, when it is called single Logical Table source. When the specific logical layer table is dependent on the columns of different physical layer tables, it is called Multiple LTS. Most of the time we will be dealing with Multiple LTS.
When the specific logical layer table is dependent on the columns of different physical layer tables, it is called Multiple LTS. Most of the time we will be dealing with Multiple LTS. The relationship between the different view layer data and the corresponding the physical layer columns. When is it advisable to create one? The opaque views make the logical understanding simple for implementation but there are heavy performance constraints.
They are only used when there is no other way to get to the final solution. How is Siebel Analytics Server advantageous in this aspect? This type of automatic updates to frequently used measures help you in speeding up the queries. If there is a column for number of products produced for every month and you often want to have the summation of the number per year and average for every year often for all the queries, the aggregate table created will have the option to give you that value without computations every time.
Siebel Analytics server gives the added advantage that the queries need not be aware of the readily available aggregate table names. If this was the case the SQL queries and the entire design might become complex. There may not be the exact data in form of the column in the result or even in the physical layer of database. These are implied from different data and can just be a temporary layer which help us in getting the required result.
After the report generation sessions, you can easily view the log to map each requests to the corresponding tables and databases.
Therefore the presentation layer alone cannot be migrated as a stand-alone aspect of the database. What we can do instead is have a ODBC or similar database connection established across from the different servers to the particular main system and then carry over the presentation semantics from the other server with that database oriented changes in the logic layer.
Creating the new logical column in the repository level or the Dashboard level of view? The logical columns created on the repository level will in turn gets its effect on all the other requests and reports from different view levels. So it is always preferable to have the logical column created at the repository level.
The external tables and LDAP offer the other possibilites. The userID and password for user authentication are stored in the external table. The information on different tables and the access information for each user are stored in this external table. The other way is the Lightweight Directory Access Protocol. This is similar to imposing a access limitation to all the different directories and folders thereby having the limitations to the data viewable for the different users.
The Data level security level is about restrictions that are concerned about the different data that are used to generate the report of other view level information.
The Data level security mostly set in the database level and related logic table level. Operating level authentication: This is the overall higher level access restriction to the application. Without this one cannot get access to the application. Table authentication: The table level authentication is the access permissions set for each physical table. Database authentication: The Database user and password, corresponding previleges can let someone to access specific db or can just give him only partial access.
This authentication is the main thing for the application that coordinates different databases. LDAP authentication. This disables the cache for the server. After the change the server needs a restart. This may lead to slower performances, but will be useful in the case of lesser accesses that are being expected. Enabling of the cache will not be concerned about the cache updates and synchronization. You can click that and go into the general settings.
This has the cache persistence in the option. This will make the queries to and fro from the physical table to use the cache. This can also be set according to specific time interval. This will help you in getting a good interactive response on the view layer. Any table that is frequently updated can have this setting on for reasonable amount of time.
The application is going to updated this event polling table for each query of update into the physical table. This stand-alone table can get the required frequency statistics for each table to maintain the cache policies as required.
Answer: There are two types of variables, namely the session variables and the repository variables. The session variables are pertaining to each session that is created for every login of a user. They may be System or Non-system variables. The repository variables contain the parameters that are corresponding to different attributes of the respository and queries.
They are again classified as static and dynamic variables. The static variables are the ones that are having permanent values through out. The administrator can change it whenever needed. The dynamic variables are the ones that have values that are corresponding to the SQL queries and data fetches.
The dynamic variables can take up values depending on the scheduled updates that are started by the administrator. They can also take up values fue to the SQL queries that have been recently executed from the user side.
Initialization blocks run at specific time or triggered according to specific condition. Such names cannot be used for non system variables or other repository variables.
You can try naming such variables with a prefix to identify their nature and content. This will make it easier for classification within each session. Varaiblename to narrow down the scope to the present session. With the help of the variable manager, all the confguration parameters can be loaded into the specific variable depending upon the different environments we are trying to have. This can help us in making the administrative tasks simpler. This dialog box has the settings for each user id.
Click the specific user id. You can then get the logging level selection inside this settings. You can choose the appropriate level and save the changes. Save my name, email, and website in this browser for the next time I comment. Quick Enquiry Request a call back. Net ASP. Net C. Net VB. Previous: VB. Net interview Questions and answers for Experienced.
Next: Microstrategy Interview Questions and answers for Experienced. Leave a Reply Cancel reply. Quick Enquiry. Categories Categories Select Category. Follow us on facebook twitter instagram youtube linkedin.
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. Ans: In the case of OBIEE 11g, reports can be sort in by the process of selecting the modify option and then clicking on the sort option which there in the column that is relevant in a pane of criteria. It is done by clicking on the modify request option and the following Narrative view. After this, it is advised to give 1 for the result of the first column and 2 for the second column and many more.
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.
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.
When the specific logical layer table is dependent on the columns of different physical layer tables, it is called Multiple LTS. Most of the time we will be dealing with Multiple LTS. The relationship between the different view layer data and the corresponding the physical layer columns. When is it advisable to create one?
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?
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. Click modify and then click sort order by icon on the relevant column in the criteria pane.
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.
Клушар кивнул: - Со спутницей. Роскошной рыжеволосой девицей. Мой Бог. Это была настоящая красотка. - Спутница? - бессмысленно повторил Беккер. - Проститутка, что. Клушар поморщился: - Вот .
Стол, накрытый стеклом, и черный кожаный стул были расположены прямо перед громадным венецианским окном. Три шкафа-картотеки стояли в углу рядом с маленьким столиком с французской кофеваркой. Над Форт-Мидом высоко в небе сияла луна, и серебристый свет падал в окно, лишь подчеркивая спартанскую меблировку. Что же я делаю. - подумал Бринкерхофф.
Утечка информации! - кричал кто-то. - Стремительная. Все люди на подиуме потянулись к терминалу в одно и то же мгновение, образовав единое сплетение вытянутых рук. Но Сьюзан, опередив всех, прикоснулась к клавиатуре и нажала цифру 3. Все повернулись к экрану, где над всем этим хаосом появилась надпись: ВВЕСТИ ПАРОЛЬ. 3 - Да! - скомандовал Фонтейн. - Нажимайте.
Я ничего не нашел на Северную Дакоту, поэтому изменил направление поиска. В записи, которую я обнаружил, фигурирует другое имя - N DAKOTA. Сьюзан покачала головой.
Черные атакующие линии начали исчезать. - Происходит восстановление! - кричал Джабба. - Все становится на свои места.
Тут все без обмана. Он стоит десять раз по двадцать миллионов. - Увы, - сказал Нуматака, которому уже наскучило играть, - мы оба знаем, что Танкадо этого так не оставит. Подумайте о юридических последствиях. Звонивший выдержал зловещую паузу.
Запах показался ей смутно знакомым, и эта мысль пронзила ее холодом.