Obiee 11g Interview Questions And Answers Pdf
- and pdf
- Friday, May 28, 2021 8:16:26 AM
- 3 comment
File Name: obiee 11g interview questions and answers .zip
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?
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.
OBIEE Interview Questions & Answers
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. Ans: There are many ways to extract the SQL: a. In the catalog, the Manager clicks Tools-Create Report. You will find the SQL for that User. Ans: Click on modify and then click on the sort order by the icon on the relevant column in the criteria pane. 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.
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. 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.
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. 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. 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.
Physical Layer 2. Business Model 3. Mapping Layer 4. Presentation Layer. 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. 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.
Ans: Using Scheduler — ibots we can generate a time-based triggered report. Ans: 1. Complex Join —it uses multiple conditions, such as A. Natural Join. Ans: Using confirmed dimensions , we can fetch many metrics across various facts, but the join should be of the same level of data detail. Prompts b. Ans: By clicking on the cancel button, we can stop an 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. Repository stores the Metadata information. Siebel repository is a file system, extension of the repository file. With Siebel Analytics Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity are stored in metadata repositories.
Every metadata repository can store many business models. Siebel Analytics Server can access many repositories. Ans: Siebel Analytics life cycle 1. Collect Business Requirements 2. Recognize source systems 3.
Build a repository 5. Build a dashboard or use answers for reporting. Define security 7. Testing and QA. Explain the three layers. Ans: There are five parts of Siebel Architecture. Clients 2. 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. 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. 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. 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 have many connection pools for each group to avoid waiting. 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.
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. 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. What is the purpose? Ans: There is no full form for rpd as such, it is just a repository file which is known as Rapid file Database. Ans: We can disable cache in the physical layer, by right-clicking on the table there we can have the option which defines cacheable. Ans: We have to make a dubbed table in the physical layer.
OBIEE Interview Questions
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.
OBIEE Interview questions and answers · Q1)Difference Between OBIEE & Tableau? · Ans: · Q2) What do you mean by the architecture of OBIEE 11g? · Q3) Mention.
OBIEE Interview Questions and Answers
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.
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?
OBIEE Interview Questions And Answers
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.
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.
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.
Теоретически постоянная мутация такого рода должна привести к тому, что компьютер, атакующий шифр, никогда не найдет узнаваемое словосочетание и не поймет, нашел ли он искомый ключ. Вся эта концепция чем-то напоминала идею колонизации Марса - на интеллектуальном уровне вполне осуществимую, но в настоящее время выходящую за границы человеческих возможностей.
- Попробуем еще… Кухня. - Спальня, - без колебаний отозвался. Сьюзан смутилась.
Росио покачала головой: - Не могу. - Почему? - рассердился Беккер. - У меня его уже нет, - сказала она виноватым тоном. - Я его продала.