The briefing book provides a way to see content offline, or share it with others. Obiee interview questions and answers datawarehousing. Create architecture for the data mart, perform complete analysis and design of all etl. Type a name and a description for the briefing book, and then save the briefing book. Yes we can create hierarchy in bmm layer of obiee in dimensions for the dimension tables.
Below are list of questions you may face during interview. Obiee 11g basics free download as powerpoint presentation. This measure will always return the value for the year even if you drill down. Log into the obiee toolset using your develop credentials to open the welcome screen. A levelbased measure is a column whose values are always calculated to a specific level of aggregation,is a measure pinned at a certain level of the dimension. We looked at how new users were created and assigned to existing ldap groups and application roles, and then left with three tasks that obiee 11g administrators would want to perform with this default configuration. First we have to check the privileges for the briefing book. Select analysis from the analysis and interactive reporting section of the create screen. If your organization licensed oracle bi briefing books, you can store a static snapshot of dashboard pages or. Navigate to a dashboard in oracle bi interactive dashboards and then perform one of the following actions. These solutions allow organizations to increase more insight and larger value from a series of data sources. Specifically, sections in a dashboard page can be set up and only appear when there is interesting information of the data. For example, you can download a briefing book that contains all the brand revenue analyses for the year.
Frequently asked questions obiee reports dashboard. Assume we are still talking about obiee version 10. Obiee is a oracle business intelligence enterprise edition and it is a tool which is used to develop enterprise wide reports. This book contains the necessary information for a beginner to create a high performance obiee 12c system with effective presentation of information. Please use the attached pdf to learn more about briefing books in bi. Capgemini obiee developer interview questions glassdoor. Obiee 11g basics business intelligence oracle database scribd. If there is a compatability issue, is there a workaround.
Click add to briefing book, locate the location of briefing book folder and assign the content types, navigation links, and description and click ok. Obiee questions and answers has been designed with a special intention of helping students and professionals preparing for various certification exams and job interviews. Guided navigation is a feature of oracle bi interactive dashboards that enables the content and layout of oracle bi interactive dashboard to change dynamically based on changes in the information being analyzed. Obiee interview questions and answersoracle bi questions.
Creating a killer pr briefing book crenshaw communications. The pdf version of a briefing book contains an automatically generated table of contents. Briefing books have the same look and feel as a dashboard page. Make decisions based on the data you can trust provide. We can download briefing book as pdf or mhtml format. A briefing book is a collection of static or updatable snapshots of dashboard pages, individual analyses, and bi publisher reports. As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and later they continue based on. I interviewed at capgemini bengaluru india in october 20. Obiee briefing books reports the captured series of snapshots of oracle bi dashboards.
Multipage briefing books have paging controls and are wellsuited for presenting information to others. Read the most frequently asked 50 top obiee interview questions and answers for freshers and experienced job interview questions pdf obiee interview questions and answers list 1. Obiee interview questions and answers for experienced. Download briefing books in pdf format and print them. By the end of this tutorial, you should be able to understand the architecture of otbi, and how it works with fusion. It allows that content to be viewed by anyone with briefing book reader software. Download briefing books to your computer in mhtml format and then share them for offline viewing. Catalog manager obiee deploy metadata obiee faq obiee federated queries obiee gskit obiee gs kit obiee gskit windows install obiee interview questions obiee metadata obiee organization obiee outer join obiee rookie faq obiee sections hiding dashboard obiee security obiee security architecture.
This section provides a useful collection of sample interview questions and multiple choice questions mcqs and their answers with appropriate explanations. In the create report window click request sql and save the sql to the physical path in your pc. Interview internal customers and translate business requirements to. Users have no problems on ie8, however, when using bb reader on ie9 or 10, it hangs. A levelbased measure is a column whose values are always calculated to a specific level of aggregation, is a measure pinned at a certain level of the dimension. Does anyone know if briefing book reader, for obiee 10g, works on ie9 and ie10.
To show this we will create the alias measure columns. Briefing books also provide a way to archive the information in a dashboard, or they can be saved locally on a desktop. Usage of briefing books in obiee 11g working with oracle bi briefing books oracle bi briefing books are used to storecapture a series of static images of pagesrequests at server, allowing the information to be viewed offline and shareable with. Obiee 10g briefing book reader on ie9,10 oracle community. This is part of overall effort to put the interview questions for obiee, dac, informatica, oracle pl\sql and dw concepts. Briefing books provide a way to archive the information in a dashboard and can be saved locally. Commonly contains bios, articles written by the journalist, schedules, messaging and general information the executive might want to have on hand during an interview. Obiee will now create a blank sample sales lite project that uses xml files as a data. The briefing book provides a way to create snapshots of dashboard pages, view them offline, or share them with others. The interview lasted approximately 3 hours and i met indiviudally with the hiring manager and various team members.
Oracle business analyst interview questions glassdoor. Oracle bi briefing books snapshots of dashboard pages to view and share in offline mode. If youre looking for obiee interview questions for experienced or freshers, you are at right place. I have attended informatica interview last week in wipro and couple of other companies, question below i faced in those companies. In yesterdays blog post on obiee 11g security, we looked at obiee 11gs security architecture, and whats called the default security configuration. You want to use a database builtin function bypassing the functions defined in obiee.
I recieved communication from capgemini saying they are hiring obiee developers and i was asked to go to their office for the interview last saturday5th oct,20. Oracle business intelligence applications obia are complete bi solutions that carry intuitive, rolebased intelligence all through an organization. We can all the reports to single briefing book by clicking add to briefing book below of every report. In the bmm layer,we can create one logical table fact and add the 3 fact table as logical table source. There are a lot of opportunities for many reputed companies in the world.
This tutorial deals with otbi oracle transactional business intelligence, which is an analysis tool used for creating reports. Bi working with briefing books in obiee description of briefing books and how to create, edit, download, etc. Obiee 12c architecture with detail explanation blogger. Obiee tutorial a beginner guide by obiee professionals.
It took a couple weeks to line up scheduling and get travel scheduled for the in person interview. What are the different ways to authenticate an user in obiee system. Read oracle business intelligence enterprise edition 12c books. Modify the request and click advanced in that you get xml code and also the actual sql. Real time interview questions on obiee 3 oracletechnotalk. This measure will always return the value for the year even if you drill.
How to create an obiee 11g analysis obiee training tutorial. A book of information preparing the client for an interview with a journalist or interviews at a tradeshow or conference. Click the add to briefing book link that appears with an individual request on the dashboard. Learn english with lets talk free english lessons recommended for you 12. With obiee server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Obiee interview questions and answers for experienced question. Organizing dashboard pages in briefing books oracle docs.
But, to be truly effective, tell the interviewers story include previous articles, former positions, and interesting personal details such as whether the. Dear readers, these obiee interview questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of obiee. Users have the option to make briefing books updateable so they can be refreshed with uptodate information from the corresponding dashboard with a single. Right click on the briefing book from dashboard and select further option to edit or download the briefing book. Used to storecapture a series of static images of pagesrequests at server, allowing the information to be viewed offline and shareable with other users and. The briefing book should include all relevant information about the outlet, the reporters position, and how heshe prefers to interview in person, by phone, over drinks, etc. According to research, obiee has a market share of about 4. The posts will be on oracle concepts, interview question and answers, real time scenarios, solutions for queries are provided.
Thing to remember, it also depends on weather interview you are facing is for consulting or full time. For example, if you have a measure called dollars,you can create a level based measure called yearly dollars which is dollars for a year. Obiee answers interview questions obiee step by step guide. You can see the briefing book on dashboard look like a briefcase. Briefing books in obiee 11g datawarehouse architect. Explore the blog post on obiee 11g training online to become a pro in obiee 11g. Briefing books and their content can be updated, scheduled, and delivered using oracle bi delivers. Hope you did go through part1 of obiee interview questions. Oci call interface connection is available in obiee d. Where as in obiee 11g there is no briefing book reader and no. Want to be on the top of the hog in your obia job interview wisdomjobs obia job interview questions is the solution to solving your interview. 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. Briefing books in obiee 11g datawarehouse architect briefing books in obiee 11g.
1279 84 1585 143 375 998 168 726 1096 747 1309 1522 1072 208 1388 215 1458 626 1054 867 1437 1402 988 1338 1354 833 741 554 304 1179 208 956 259 1395 1197 160 1480 1091 994 61 401 1104 330 222 1395 665 891