Views use the presentation capabilities of oracle bi enterprise edition to help you look at. A channel carries masterdetail events to the detail view. Webinar obiee 11g bi publisher overview part 1 of 5. In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you can include additional subject areas that.
I would like to have the detail refreshed with the first row of the master. In the interaction tab, you can specify interactions for column headings and values. Hello, i have installed obiee 11g sampleapp 825 and just exploring the provided set of dashboards. Obiee comparison between 10g and 11g features my oracle blog. To assess your business performance, you must first understand how success is defined. Obiee 11g download alldisplay all of rows in answers.
How to suppress detail rows of a master group in a pivot view. Other options are to send masterdetail events, which allow user actions in a column in a master analysis to reflect in child analyses, and to initiate an action using action links. The master column is the column whose values when clicked will send a masterdetail event, which passes information to update the data in a detail view. Using master detail view in obiee 11g master detail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views.
Exploring advanced features of oracle bi publisher 11g. What is conditional formatting and how do you do that. Helping teams, developers, project managers, directors, innovators and clients understand and implement data applications since 2009. An oracle 11g database that is installed and running.
It is the vehicle that carries masterdetail events from the master view to the detail view. Master detail event in obiee 11g and pass multiple events to one detail report master detail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views. In this release, you can work with multiple subject areas. What is a masterdetail report and how do you create it. Detail report columns are item family,item name, cost and revenue. Oracle bi publisher 11g formerly xml publisher enables the creation, management and delivery of various reports, making it a desirable tool for any company to achieve the. Once you have each of these prerequisites in place, you are ready to proceed.
Master detail event in obiee 11g and pass multiple events to one. Master detail linking new features included in obiee 11g. In the general tab, it is set to listen to masterdetail events. Working with the masterdetail report feature of obi 11g. Obiee12 tips and tricks obiee master detail report. Using master detail view in obiee 11g masterdetail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views.
Obiee comparison between 10g and 11g features apart from major architectural differences, obiee 11g has several new features that were not available in 10g. Before building your obiee 11g analysis report, you will need. When i am selecting item family in master i am getting correct changes in detail graph but not in table view. The default interaction is to drill in any associated hierarchy. Master report migration, template design, and ebusiness suite integration.
Obiee 10g web catalog best practices 8 years ago carpediemconsulting blog. For example, if the information in the event is regioncentral and year2009, and the page edge of the detail view has region and the section slider has years, then only the region will be. Oracle business intelligence obiee 101 a collection of obiee obise stuff from 101 till 404. Master details events help us to trigger events on a view based on users interactions on same or different view. The multiplequery reports are, however, sometimes easier to understand conceptually and easier to maintain. Report has interaction set to sent master details event and also includes a horizontal bar chart. Obiee credentials with the appropriate level of permissions. Hi team, how to implement master detail report in obiee 10g. You may use departments employees or order and order items as an example.
For examples, lets say there are two views in your analysis i am referring to sample app that comes with obiee 11g a simple table with columns products, regions, revenue a graph with products as graph prompts. Masterdetail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data. Master detail report with oracle bi publisher duration. Masterdetail linking of views allows us to establish a relationship between two or more views such that one view, called the master view, will drive data changes in the other connected views, called detail views. In bi publisher obiee 10g report is a single entity and data sets are the part of report definition. Defining masterdetail links for an analysis in oracle fusion hcm cloud duration. The masterdetail linking allows you to establish a relationship between 2 or more views. Masterdetail linking of views allows you to establish a relationship between two or more. Properly installed and configured oracle business intelligence 11g obiee tools. You can think of a master detail relationship in a similar manner that you would when navigating from 1 report to another works, but you do not lose sight of the. Obiee interview questions what is the difference between a filter and a prompt. The integration of oracle bi ee with oracle business intelligence addin for microsoft office has been enhanced. In the following example, a table view of a city revenue analysis is linked to a bar graph through a masterdetail relationship. Working with the masterdetail report feature of obi 11g pt 2 posted by marty mersinger at monday, january 31, 2011 in previous part of this series, i stepped through how to configure a masterdetail report link when using the same analysis criteria to create the master and detail views.
A master view can be the same analysis as the detail view or in a different analysis. This is an upgrade to the existing advanced bi publisher 10g oracle by example. Obiee how to get started oracle business intelligence. Master detail linking is the new interaction type which is added to 11g version of obiee along with the existing drill down,navigation and no interaction in obiee 10g. I am very new to obieei have acheived naviagting from the master report to detail report but what i also want is my deatil. Masterdetail linking new features included in obiee 11g. The masterdetails are working great when i click on cells. Obiee 10g11g passing filters through the go and dashboard url. A master view can update the data in one or more detail views. Short answer is there is a lot less pain going from 11g to 12c than there was going from obiee 10g to 11g.
As you can see above, a twoquery group report appears much the same as a singlequery group report. Its been a long time since i posted something new, useful and innovative in my 108obiee. Master detail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views. Master detail event in obiee 11g and pass multiple events to one detail report masterdetail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views. Working with the master detail report feature of obiee. Obiee reporting on multiple subject area advanced logical sql obiee 10g web catalog best practices obiee 11g 11. The same channel must be used for both the master view and the detail view in a masterdetail relationship, for example, channel1. Master detail interaction allows the multiple other views to change when selecting value in one view. Working with the masterdetail report feature of obi 11g pt. Oracle bi publisher master detail report with oracle bi publisher. The following new and revised sql functions enable you to create time series calculations and levelbased measures. If a detail column is on a section slider and a page edge is present, the detail column will not be updated by the information in the master detail event. 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.
Masterdetail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views. In most cases, singlequery reports will run faster than multiplequery reports. Obiee online training by exrittman mead and oracle trainer. Performance is the key issue when contrasting singlequery and multiplequery group reports. Oracle business intelligence obiee training tutorial as part of our ongoing obiee training curriculum tutorials we will discuss an example of how to use kpis in an obiee 11g analysis. A practical guide brimming with tips about all the new features of the 11g release.
Linking views in masterdetail relationships oracle docs. A view becomes a master when you set up the interaction of a column in the view to send masterdetail events on designated channels. The master column cant display on the page edge or section slider. The new ui called unified framework now combines answers, dashboards, and delivers. Obiee master obiee master detail report, master detail. Here is a list of all the new features introduced with obiee 11. Sql functions for time series calculations periodrolling is a new function that computes the sum of a measure over the period starting x units of time and ending y units of time from the current time. Using master detail view in obiee 11g its all about data. How to create an obiee 11g analysis obiee training tutorial. For graphs in masterdetail relationships, if you want to simplify the. In this sticky article i want to give you some basic starting points. The master column is the column whose values when clicked send a masterdetail event, which passes information to update the data in a detail view. If the previous table included all reportbased totals, then all measure columns and.
Periodrolling is a new function that computes the sum of a measure over the period starting x units of time and ending y units of time from the current time aggregate at is a new function that aggregates columns based on the level or levels specified. Obiee 11g is more preferable than obiee 10g as it has got remarkable features which are as follows. Master detail linking obiee 11g download obiee best. Adding views for display in dashboards oracle docs. Reporting and data access tools oracle business intelligence. In the general tab, it is set to listen to master detail events. Difference between obiee 10g and obiee 11g datawarehouse.
Supports creating hierarchy objects in subject area export to xml or export to tab delimited and power point 11g lets variable have multiple values 11g. In oracle forms youll have two blocks, one is master and the second is detail. Obiee master detail relationship obiee dashboard obiee. This allows to update a second table or graph based on a click within the master report. Obiee 11g master detail linking view iconsulting01. For the love of physics walter lewin may 16, 2011 duration. A master view contains a master column, where you set up the interaction that sends masterdetail events on a channel.
45 1165 907 1221 1312 1158 507 1135 1526 304 1083 1091 929 406 511 1311 1299 925 145 373 1133 1073 86 1267 114 1413 1521 708 378 567 779 1128 819 1342 139 1084 1499 213 4 482 165