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. Obiee 11g basics business intelligence oracle database scribd. Obiee 11g basics free download as powerpoint presentation. Download briefing books in pdf format and print them. Obiee briefing books reports the captured series of snapshots of oracle bi dashboards. Explain the architecture of obiee and what each components do. Obiee send content to ftp server network folder oracle obiee.
Oct 05, 2014 what are the new features addedchanges made in obiee 11g compared to obiee 10g. Obiee consists of presentation servicesweb,oracle bi analytics engine server the client answers constructs sql and passes it to the analytic engine and then the oracle bi analytic engine parses the physical sql to the datasources and retrieve the data back to the engine and presents to the presentation services. Jul 29, 20 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 others users or we can keep track of changes offline. If youre looking for obiee interview questions for experienced or freshers, you are at right place.
Multipage briefing books have paging controls and are wellsuited for presenting. If your organization licensed oracle bi briefing books, you can store a static snapshot of dashboard pages or individual requests in one or more briefing books. May 02, 2012 2 comments on real time interview questions on obiee1 real time interview questions on obiee 3 oracletechnotalk says. We can import the data from the different data sources, no. If there is a compatability issue, is there a workaround. 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. Obiee administration interview questions mindmajix. Obiee send content to ftp server network folder oracle. For follow briefing book navigation links, choose one of the following options.
Where as in obiee 11g there is no briefing book reader and no. Read oracle business intelligence enterprise edition 12c books. Genwish infotech offers obiee 11g training in chennai by experienced professionals genwish infotech is the best live project training institute with placement in chennai. A handson tutorial, and authored by three obiee experts, christian screen, haroun khan, adrian ward. By clicking on this the destinated reportdashpage will open in the same window or new window. Briefing books and their content can be updated, scheduled, and delivered using oracle bi delivers. 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. By default obiee 11g agents do not have the option to deliver the content to an ftp server or to a network folder to accomplish this purpose, we can use a server script which will allow us to take the generated file from obiee and send it to a ftp server. Obiee 11g uses weblogic server as the application server as compared to oracle as or oc4j in obiee 10g. Obiee interview questions and answers 1 slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. How to create a basic obiee 11g repository oracle bi 11g training duration.
This oracle database notes for professionals book is compiled from stack. From the admin page under activities, select schedule briefing book. How to schedule a report in obiee 11g using agents. Briefing books in obiee 11g datawarehouse architect. Oracle bi briefing books snapshots of dashboard pages to view and share in offline mode. Obiee 11g training program with placement assured in guindy, adyar, virugambakkam, vadapalani, ashok nagar in chennai. We can download briefing book as pdf or mhtml format. The clustering process in much easier and automated in obiee 11g. Aug 03, 2015 obiee 11g creating column selector and view select.
Briefing book navigation links will not be followed. Oct 28, 2009 obiee 11g refreshing user guids process flow. Multipage briefing books have paging controls and are wellsuited for presenting information to others. This section provides a useful collection of sample interview questions and multiple choice questions mcqs and their answers with appropriate explanations. When the presentation varaible is part of a column prompt, it is associated with a specific column and takes on that columns value. You can see the briefing book on dashboard look like a briefcase. Click the add to briefing book link that appears with an individual request on the dashboard. Users have no problems on ie8, however, when using bb reader on ie9 or 10, it hangs. It is responsible to schedule jobs in obiee repository. Explore the blog post on obiee 11g training online to become a pro in obiee 11g. Aiming to offer exclusive obiee 11g, which is customized according to your expectations in terms of.
In 11g the security is managed by the welogic server. As you may be aware, oracle released its latest bi techstack version 12c during october 2015 which is packed with abundant new enhancements and stunning new visualisations. Powered by create your own unique website with customizable templates. Aug 22, 2016 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. Jul 29, 20 biapps interview questionscovering obiee,informa. When you create repository, obiee also create a table inside repository which saves all schedule related information. Briefing books in obiee 11g scorecard in obiee 11g steps. A book of information preparing the client for an interview with a. Authentication is the procedure by which a system confirms, through the use of a user.
An obiee 11g briefing book is a collection of static or updatable snapshots of. Use the oracle bi briefing book reader application to view downloaded briefing books. How to display the export link above a analysisreport. We can all the reports to single briefing book by clicking add to briefing book below of every report. Click the add to briefing book button, located near the. It allows that content to be viewed by anyone with briefing book reader software.
We can then download and share briefing books for viewing offline. If you continue browsing the site, you agree to the use of cookies on this website. The briefing book provides a way to create snapshots of dashboard pages, view them offline, or share them with others. May 17, 2011 obiee interview questions and answers 1 slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. What you did in physical layer,bmm layer and presentation layer. March 8, 2017 by santosh bhairi in business intelligence. Reports captured series of snapshots of oracle bi dashboards.
Real time interview questions on obiee1 oracletechnotalk. A book of information preparing the client for an interview with a journalist or interviews at a tradeshow or conference. This brief overview highlights the new features and capabilities delivered in oracle business intelligence version 11g. So, you still have an opportunity to move ahead in your career in obiee development. If you want to connect two tables where there is no relation ship you can use a thrid bridge table for connecting them which will have common columns in both tables, this is used in bmm layer. The content is refreshed whenever the briefing book is downloaded, or when it is specified as the delivery content for an ibot in oracle bi delivers. I miss a brief introduction to the kimball dimensional modelling, that would help. Most popular oracle plsql and dba technical interview questions with. Please use the attached pdf to learn more about briefing books in bi. Obiee interview questions and answers 1 linkedin slideshare. Heres an opportunity to learn all the key elements of the obiee 11g suite by doing tasks rather than.
Informatica sample project datawarehouse architect. Obiee questions and answers has been designed with a special intention of helping students and professionals preparing for various certification exams and job interviews. With obiee server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Jun 27, 2014 top 50 interview questions with answers for obiee 11g q1. 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. This measure will always return the value for the year even if you drill down. Download briefing books to your computer in mhtml format and then share them for offline viewing. The briefing book provides a way to see content offline, or share it with others. 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. Obiee 11g addresses these by where possible moving administration and configuration into fusion middleware control also referred to as enterprise manager. Create a measure using the periodrolling function in obiee rightclick the f1 revenue logical table and select new object logical column. Navigate to a dashboard in oracle bi interactive dashboards and then perform one of the following actions.
Top 50 interview questions with answers for obiee 11g q1. This post will be a brief summary of how to deploy the getting. Obiee tutorial a beginner guide by obiee professionals. July 6 june 10 may 16 april 20 march 2 february 28. Does anyone know if briefing book reader, for obiee 10g, works on ie9 and ie10. Class room training for obiee will be given for student who located in chennai, india. Dec 06, 20 u obiee 10g need to install the obi briefing book reader software in order to open the. Report are apprehended or stored from oracle bi dashboards as a book like pdf. May 09, 2012 an obiee 11g briefing book is a collection of static or updatable snapshots of. Bi is sometimes used interchangeably with briefing books, report and. Adding scorecard to briefing book in obiee 11g oracle. Oracle business intelligence applications obia are complete bi solutions that carry intuitive, rolebased intelligence all through an organization. Obiee 10g briefing book reader on ie9,10 oracle community.
Consult your oracle bi administrator if you need the oracle bi briefing book reader application. Obiee interview questions and answersoracle bi questions. Bi working with briefing books in obiee description of briefing books and how to create, edit, download, etc. Obiee 10g11g translate the webcat dashboard, page and report names 3. These solutions allow organizations to increase more insight and larger value from a series of data sources. If your organization licensed oracle bi briefing books, you can store a static snapshot of dashboard pages or. 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. Organizing dashboard pages in briefing books oracle docs. Jun 24, 2015 obiee training, obiee 11g online training. Obiee 11g training program with placement assured in. Real time interview questions on obiee 3 oracletechnotalk. It is used to read the information of the reports with the static and dynamic image of pages and requests. There are a lot of enhancements in the obiee 11g as compared to obiee 10g.
From the bottom of the dashboard page, click the add to briefing book button. Top 50 interview questions with answers for obiee 11g. Biapps interview questionscovering obiee,informatica,dac. Connection pool is needed for each and every physical database. According to research, obiee has a market share of about 4. Also to run agents in 11g, this component is mandatory. Buzz words and questions around obiee 11g and obiee 10g. Aug 27, 2015 by default obiee 11g agents do not have the option to deliver the content to an ftp server or to a network folder to accomplish this purpose, we can use a server script which will allow us to take the generated file from obiee and send it to a ftp server. Oct 25, 2009 from the admin page under activities, select schedule briefing book. Obiee 11g creating column selector and view select. Right click on the briefing book from dashboard and select further option to edit or download the briefing book. On the general tab, name the new logical column revenue 3period rolling sum.
This measure will always return the value for the year even if you drill. 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 others users or we can keep track of changes offline. What is connection pool and how many connection pools did we have in our last project. Aug 22, 2012 if we have a licensed version of oracle bi briefing books, we can store a static snapshot of dashboard pages or individual requests in one or more briefing books. 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. The pdf version of a briefing book contains an automatically generated table of contents. For example, you can download a briefing book that contains all the brand revenue analyses for the year. I have attended informatica interview last week in wipro and couple of. Create a measure using the periodrolling function in obiee.
Click add to briefing book, locate the location of briefing book folder and assign the content types, navigation links, and description and click ok. Physical layer is a connection between database and repository by using connection pool. Briefing books have the same look and feel as a dashboard page. Oracle sql oracle plsql oracle 11g dba obiee oracle apps technical functional. To start off with something familiar, the administration tool that was present in obiee 10g is also present in 11g, is also windowsbased, and is used to maintain the semantic model used by. Last n monthsrolling months data by yearmonth prompt in.