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. Users have no problems on ie8, however, when using bb reader on ie9 or 10, it hangs. Real time interview questions on obiee1 oracletechnotalk. Hope this helped you understand a bit of the logic behind users, groups and application roles. From the bottom of the dashboard page, click the add to briefing book button. In access access to briefing books provide who are all can access the briefing books functionality. Briefing books in obiee 11g scorecard in obiee 11g steps.
How itll go down upgrading obiee 11g to 12c red pill. Obiee 11g writeback functionality write back it provides users of a dashboard page or an analysis with the ability to modify the data that they see i. 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. In briefing book section download briefing book this enables to option to download or print captured information. If youre looking for obiee interview questions for experienced or freshers, you are at right place. Where as in obiee 11g there is no briefing book reader and no. Heres an opportunity to learn all the key elements of the obiee 11g suite by doing. Oracle bi briefing books snapshots of dashboard pages to view and share in offline mode. A briefing book is a collection of static or updatable.
Obiee 11g impersonates the option of calling a webservice in the answers that resides in weblogic, we can use this feature to see the individual uses and their groups. 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. To add the contents of the dashboard page to a briefing book. Sometimes obiee is used interchangeably with oracle business intelligence applications obia, which is a prebuilt bi and data warehousing system built on the obiee technology stack, however, obiee is the platform whereas obia is an application that uses the platform. A briefing book is a collection of static or updatable snapshots of dashboard pages, individual analyses, and bi publisher reports. This last role is a generic obiee application role that any user who can login to your system will have by default. Obiee 11g uses weblogic server as the application server as compared to oracle as or oc4j in obiee 10g. The briefing book provides a way to create snapshots of dashboard pages, view them offline, or share them with others.
Modify the request and click advanced in that you get xml code and also the actual sql. Obiee security 1 users, groups and application roles. But, to be truly effective, tell the interviewers story include previous articles, former positions, and interesting personal details such as whether the. What is connection pool and how many connection pools did.
Click page options and select add to briefing book. Does anyone know if briefing book reader, for obiee 10g, works on ie9 and ie10. With the above steps you have successfully created briefing book in obiee 11g. Obiee interview questions and answers for experienced question. Obiee interview questions and answersoracle bi questions. How to create users and groups in obiee11g obiee by.
If your organization licensed oracle bi briefing books, you can store a static snapshot of dashboard pages or. This measure will always return the value for the year even if you drill. Obiee briefing books reports the captured series of snapshots of oracle bi dashboards. Informatica sample project datawarehouse architect. Obiee interview questions and answers for experienced. 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. Obiee 11g basics free download as powerpoint presentation. Obiee 10g briefing book reader on ie9,10 oracle community. Obiee tutorial a beginner guide by obiee professionals. 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 11g creating column selector and view select. Right click on my computer and select properties click on advanced system settings on the top left corner and select device manager.
If there is a compatability issue, is there a workaround. Briefing books and their content can be updated, scheduled, and delivered using oracle bi delivers. Briefing books provide a way to archive the information in a dashboard and can be saved locally. This measure will always return the value for the year even if you drill down. The briefing book provides a way to see content offline, or share it with others. Oracle business intelligence applications obia are complete bi solutions that carry intuitive, rolebased intelligence all through an organization. You can see the briefing book on dashboard look like a briefcase.
March 8, 2017 by santosh bhairi in business intelligence. Filters are applied before the query is aggregated meaning that it could affect calculations and measures because the query is affected. There are a lot of opportunities for many reputed companies in the world. These solutions allow organizations to increase more insight and larger value from a series of data sources. 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.
With obiee server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Edit the dashboard, and select tools, then page report links. That indicates that every user has the access to add the dashboard in briefing book or edit the briefing book, as well as download the briefing book. 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. We can import the data from the different data sources, no. What are the new features addedchanges made in obiee 11g compared to obiee 10g. Basic concepts of obiee obiee online training by bigclasses. According to research, obiee has a market share of about 4. We can all the reports to single briefing book by clicking add to briefing book below of every report.
Briefing books have the same look and feel as a dashboard page. 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. We can download briefing book as pdf or mhtml format. 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. This data warehouse was expanded by adding functionality from many other.
Click new to add a new user obieeuser and provide a password. Using custom group, current view or all views in obiee 11. Then click browse with above screen to add this dashboard page to briefing book. Adding briefing book in dashboard after successful creation of briefing book, edit the dashboard page where you want to add the briefing book. This link appears only if the request was added to the dashboard with the option to show the link add to briefing. Adding scorecard to briefing book in obiee 11g oracle. Bi is sometimes used interchangeably with briefing books, report and query tools and executive information systems. What you did in physical layer,bmm layer and presentation layer. By clicking on this the destinated reportdashpage will open in the same window or new window. Some times we need the information of users that are available in weblogic console, like the group user is assigned to. This brief overview highlights the new features and capabilities delivered in oracle business intelligence version 11g. Obiee 11g basics business intelligence oracle database scribd. Select the customize option and click add to briefing book. A briefing book navigation link is a special type of link that can be added to a.
Creating a killer pr briefing book crenshaw communications. Buzz words and questions around obiee 11g and obiee 10g. Top 50 interview questions with answers for obiee 11g q1. Top 50 interview questions with answers for obiee 11g. In the bmm layer,we can create one logical table fact and add the 3 fact table as logical table source.
To add the results of an individual request to a briefing book, locate the request on the dashboard and click the following link. Explore the blog post on obiee 11g training online to become a pro in obiee 11g. Physical layer is a connection between database and repository by using connection pool. You can add the content of dashboard pages or individual analyses to new or existing briefing books. I miss a brief introduction to the kimball dimensional modelling, that would help. 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. For the love of physics walter lewin may 16, 2011 duration. To add the results of an individual analysis to a briefing book. Right click the computer name and select add legacy hardware as shown in the screenshot below. Multipage briefing books have paging controls and are wellsuited for presenting information to others. A handson tutorial, and authored by three obiee experts, christian screen, haroun khan, adrian ward. The upgrade to 12c is an out of place upgrade as was the 10g to 11g which means new software install followed by migratingupgrading 11g artifactsweb catalog, rpd file and permisssion to the 12c versions. Adding content to an oracle bi briefing book use the following procedure to add the content of a dashboard page or an individual request to a briefing book. Click add to briefing book, locate the location of briefing book folder and assign the content types, navigation links, and description and click ok.
There are a lot of enhancements in the obiee 11g as compared to obiee 10g. This section provides a useful collection of sample interview questions and multiple choice questions mcqs and their answers with appropriate explanations. The obi ee plus incorporates the components of the toolset to include a serviceoriented architecture, an analytic, data. Obiee 10g11g translate the webcat dashboard, page and report names 3. In 11g the security is managed by the welogic server. An obiee 11g briefing book is a collection of static or updatable snapshots of. Their differences and how to use the two selection steps and filters in obiee 11g analyses overall serve a similar purpose by limiting the data for the user. How to get list of users and their assigned groups. Specifically, two new options have been added, include custom member and.
Bi working with briefing books in obiee description of briefing books and how to create, edit, download, etc. Obiee questions and answers has been designed with a special intention of helping students and professionals preparing for various certification exams and job interviews. From the admin page under activities, select schedule briefing book. Organizing dashboard pages in briefing books oracle docs. 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. In the create report window click request sql and save the sql to the physical path in your pc. Read oracle business intelligence enterprise edition 12c books. Short answer is there is a lot less pain going from 11g to 12c than there was going from obiee 10g to 11g. 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.
Briefing books in obiee 11g datawarehouse architect. Use of prune days in dac frequently asked in interviews. If briefing book is already created then select that book and add this page otherwise browse to the location where you want to save the briefing book and give the new name for briefing book and click ok to save. To add additional briefing books, click the add to briefing book link or button, and then create them using the preceding steps. 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. It allows that content to be viewed by anyone with briefing book reader software. Please use the attached pdf to learn more about briefing books in bi. I have attended informatica interview last week in wipro and couple of other.
1436 1577 1414 1061 90 508 740 711 349 1126 67 1549 778 605 203 1276 339 380 978 411 849 1183 856 823 1379 980 1443 1193 694 800 27 115