The new release allows you to connect seamlessly to obiee subject area and reports with tableau. Also download of data is possible for the rows available on page o. Renaming columns in the business model and mapping layer automatically creates aliases synonyms for presentation layer columns that have the property use logical column name selected. Analytic views av take obiees metadata modeling concept and move it at. Obiee comparison between 10g and 11g features apart from major architectural differences, obiee 11g has several new features that were not available in 10g. Expose the new columns to users by dragging product total revenue and product type revenue to the base facts presentation table in the sample sales subject area in the presentation layer. Jan 23, 20 how to make accessible to the users information about metrics or attributes from repository objects with obiee metadata dictionary in 11g. Sep 21, 20 obiee comparison between 10g and 11g features apart from major architectural differences, obiee 11g has several new features that were not available in 10g. I have made a presentation table in a subject area, but it was not ok, so i deleted the columns of that presentation table. So, by dragging over a logical hierarchy at any level, but i wont go into that now into a subject area s presentation table, a presentation hierarchical column is created. Apr 14, 2020 in obiee answers, when you mix hierarchy columns with attribute columns that make up the hierarchy, the sort order of the corresponding attribute columns does not work.
Obiee bi server obisnqsservernqs gerardnico the data. 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. Subject areas and columns are the building blocks for an analysis. Difference between obiee 10g and obiee 11g datawarehouse architect difference between obiee 10g and obiee 11g. Oracle bi answers supports drilldown on these hierarchical columns. You can include additional sql clauses and change the subject area or the from clause for certain analyses.
Obiee 11g is more preferable than obiee 10g as it has got remarkable features which are as follows. 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 are. When a query containing a presentation hierarchy includes a levelbased measure column, and the query grain is higher than the level of aggregation specific to the column, the query results return null. So, can anyone help me to create a subject area in obiee. In this posting, well move to the frontend and see how dimensional support has been enhanced in oracle answers 11g, in particular through a new feature called hierarchical columns.
You can drag the columns from either the h2 product logical dimension or the f1 revenue logical table. Creating a repository using the oracle bi administration tool. Check if you are applying any kind of security to that subject area by. The problem is you cant display the hierarchy and the column used to build the hierarchy at the same time with a table. Note that you can also expose dimension hierarchies by adding one or more columns from each hierarchy level to a subject area in the presentation layer. A subject area contains columns that represent information about the. In 11g, we can create a calculated item for the members of an attribute column or of a hierarchical column. In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you. Aug 24, 20 the session variables get initialized when they are actually used in obiee 11g unlike obiee 10g where they were initialized as soon as a user logs in. Then the logical columns are associated with logical levels in the hierarchy. For example, a company might want to measure its revenue based on the country, based on the region, and based on the city. Hierarchy objects are not available in 10g presentation layer. Adding and removing columns in analyses using oracle bi ee. In 10g you were able to sort by a column, and then put a secondary sort on another column, regardless of the first.
You can export logical keys to odbcbased query and reporting tools. Querying across two subject areas in oracle business intelligence suite obiee ask question. A hierarchical column is only called by that name once it resides in the presentation layer ultimately the subject area, right. Obiee how to work with logical dimension objects in bmm. Table names listed in the query wizard are derived from the presentation level hierarchical objects representing each hierarchy level individually. There are many things which were constrained till previous release, 11g fixed most of them. Parent child hierarchies are different from normal level based hierarchies not only in the nature of their structure but also in the way aggregations are done. You can rename subject area, table and columns with the help of an alias. Supports creating hierarchy objects in subject area. Creating and managing dimensions with levelbased hierarchies. Obiee 10g11g presentation layer gerardnico the data blog. Some of the new features have been longtime awaited before finally coming into light. Subject area in 11g was called as presentation catalog in 10g.
The hierarchical column was created but it only has products total, products type, and products detail. The bi server doesnt itself hold data, instead, it translates the incoming logical query into one or more outgoing physical queries against the relevant data sources. Level based measure in obiee a levelbased measure is a column whose values are always calculated to a specific level of aggregation. It is not applied even when it is present in the excluded section. A subject area contains folders, measure columns, attribute columns, hierarchical columns, and hierarchy levels that represent information about the areas of an. The physical column that belongs to the presentation column element is deleted, but the logical column where this physical column was mapped to, is still in the logical model. Obiee 11g download alldisplay all of rows in answers hi all, i have created a request in obiee 11g and now displaying it on dashboard.
Order item level, you dont need to create a single subject area that contains both order and. In addition to the primary subject area that you select when you create a new analysis, filter, or dashboard prompt, you can include. With this release, presentation columns have been renamed to attribute columns and a new column type, hierarchical column, is introduced. In obiee answers, when you mix hierarchy columns with attribute columns that make up the hierarchy, the sort order of the corresponding attribute columns does not work. Hence we used to use training and development box purpose. Along with the new column type comes new ways to do the following. Hierarchical columns, and enhancements to pivot table views july 2010 in our previous postings, we looked at the new user interface for obiee 11g, and how the metadata layer for the bi server has been enhanced to better handle olapstyle data. Oracle biee 11g reports and dashboard hands on vlamis software solutions is one of the most respected training organizations in the oracle business intelligence community because our training programs and materials are informed by our experience leading implementations in many of the worlds foremost corporations. At clearpeaks we found some new features really worthnoting, especially when casually most of those are actually not caught at first sight.
Business intelligence suite enterprise edition version 11. One of the newest feature of 11g is the possibility to expandcollapse hierarchy level yep even in 2014 it seems to be a killer featureheh. Expand all items and expand one level across nodes options for hierarchical columns not available doc id 2060288. A hierarchy can be created when a parent child table exists. The quickest way is to drag one or more columns from the logical dimension table to each level except grand total level. Hierarchies in obiee 11g part 1 its extremely exciting to see the breadth and depth of obiee 11g features. Im lacking dashboard page name and analysis name from the available columns when i choose to report on dashboard. For example, the day table is listed as a separate table in the query wizard whereas it is a child object of date in the corresponding obiee subject area. If the logical column is a primary key, this column is displayed with the key icon. In addition, it includes enhancements in the connectivity from tableau to obiee, so we recommend existing users of bi connector to upgrade. The problem is that there is a folder in the subject area in analytics and it is empty, but in the repository itself i dont see that folder. I understand that filters on hierarchy prompts can be applied in selection steps and cannot be viewed in the physical query as such. There are times you want to create a subject area or data model based on a single table in the oracle bi administration tool. This video teaches you how to combine values in a column to create a group in an analysis.
To create an hierarchy out of this parent child table we follow the steps as detailed below. Nov 27, 2012 obiee 11g parentchild hierarchies differing aggregations mark has already explained the new parentchild hierarchy new feature in 11g here. Creating a repository using the oracle bi 11g administration toolin order to complete this tutorial you must have access to the bisample schema that is includedwith the sample application for oracle business intelligence suite enterprise edition plus. Ive tried connecting to the catalog in offline and online mode and through putty on the machine itself just to see if there were any differences, but the available columns for me differ from the list in your picture.
You would model this by either joining on these attributes in the physical model if you want to go down the restrictive, databaselike way. Jan 18, 20 its the most updated latest version actually bundle patch of obiee, installed on top of 11. Obiee 11g hierarchy columns after migrating from obiee 10g to 11g, i notice that the hierarchies defined in 10g are not showing up in 11g as hierarchy columns. Hierarchical table feature is a new addition to obiee 11g. Obiee 10g 11g dimension hierarchy logical dimensions obiee subject area presentation catalog. Conditional formatting is now possible on pivot tables even on hierarchical columns. The weblogic biserver is a weblogic managed server and not an obiee bi server.
Download a file for working with the results of the analysis in excel. The obiee answers interface will look like this screenshot when creating or editing an analysis. So it is like a ghost empty folder in the subject area. Obiee 11g map views integration with mapviewer one of the biggest new features in bi ee 11g is the ability to create native mapviewer maps and then overlay reporting componentsvisualizations on top of maps. When the obiee version is installed, sales and catering advanced reporting subject areas are included within the obi subject areas. You can also define parentchild hierarchy in obiee 11g as well. Obiee 11g sort order not working when using hierarchy column. Remove hierarchical columns where no hierarchy exists. However, what happens is, the hierarchy prompt only gets applied when the hierarchy is displayed in the report. A subject area contains columns that represent information about the areas of an organizations business or about groups of users within an organization. Creating and maintaining the presentation layer 11g release 1. This allows end users to just pick columns from a subject area and. If the request only contains ordinary columns and no hierarchical columns, the levelbased measure is not replaced with null. 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 are related to the primary subject area with which to work interaction with other oracle products.
This video teaches you how to add, remove, and reorder columns in an analysis. Hi all, i have an issue with implementing hierarchy prompts in obiee 11g. Use this area at the top of the tab to access links that are identified with the name of the. Searching subject area for measure names in answers hello, i have installed obiee 11g sampleapp 825 and just exploring the provided set of dashboards. In the lefthand selection pane of the answers interface, click the plus icon. Never mix hierarchies and attribute columns of the same dimension in a. If not explicitly associated with a level, a column is. After creating the parent object and child objects, columns must be created for each level. 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. Obiee 10g 11g presentation column attribute columns obiee 10g 11g period to period comparison with the ago function. Its the most updated latest version actually bundle patch of obiee, installed on top of 11.
In the presentation layer, rightclick on subject area presentation catalog dialog box, click the presentation tables tab go to presentation tables tab, select a table and click remove. Consists of values that define the hierarchy in a parentchild relationship and does not contain named levels. Metadata modeling in the database with analytic views. A confirmation message appears click yes to remove the table or no to leave the table in the catalog click ok. Hierarchies in obiee 11g part 1 its all about business. A view becomes a master when you set up the interaction of a column to send masterdetail events on designated channels. Fusion middleware metadata repository builders guide for oracle business.
Reporting using more than one fusion otbi subject area. Subject area, catalog and functional area security to restrict access to a particular subject area, or to certain tables or columns in a subject area, there are actually two main approaches you can take. Passing hierarchy values to the detail reports obiee 11g. When you create a new analysis, this subject area is known as the primary subject area and will appear in the subject areas pane of the analysis editor. Some features that are useless like shortcuts, visual format, navigation panels or icons, were not considered in this study. A parentchild hierarchy is a hierarchy of members that all have the same type. Any hierarchical columns, selection steps, groups, or formatting that are. Difference between obiee 10g and obiee 11g datawarehouse. Set object permissions on subject areas, presentation tables, and presentation columns to restrict access as necessary.
Obiee comparison between 10g and 11g features my oracle blog. Obiee i about the tutorial oracle business intelligence enterprise edition obiee is a business intelligence bi tool by oracle corporation. Make subject areas as simple as possible mapping to a single logical star. If the column has an aggregation function, it is displayed with a sigma icon. Logical columns in bmm layer are automatically created when you drag tables from the physical layer to the business model layer. At the moment the patch is available for windows 64, linux 64 and linux 32. Consider an employee and manager table with the following hierarchy. The hierarchy will be ok but the columns will display null value.
But in 11g now, we have the ability to use hierarchical columns. The natural drill down is supported and can be configured to support drill through also. Introduction to oracle business intelligence enterprise. For the descriptive columns we can create one or several dimension. While there are several third party tools that build the complete column lineage, from dashboard to subject area, to physical column, and then to column in source system, i found obiee also has something nifty that can be used to answer many questions of not all. To find out more about oracle bi ee, see the documentation at. Lesson 1 using the new hierarchical columns exercise 1a. I thought when you go to analysis, you would see the hierarchy columns with a blue icon. Its proven architecture and common infrastructure producing and delivering enterprise reports, scorecards, dashboards, adhoc analysis, and olap analysis provides a rich enduser experience. Not all columns in the logical table need be associated with a level.
In our previous postings, we looked at the new user interface for obiee 11g, and how the metadata layer for the bi server has been enhanced to better handle olapstyle data. A subject area contains folders, measure columns, attribute columns, hierarchical columns, and hierarchy levels that represent information about the areas of an organizations business or about groups of users with an organization. Jan 25, 20 11g allows us to work with multiple subject areas in same report. The readme file describes the following bugs fixed. Obiee 10g11g hierarchy drill down orand drill through orand drill chaining obiee 10g supports level based hierarchy, with obiee 11g enhancements it supports level based as well as value based hierarchies with some additional configurations. If you add a related subject area but do not add any columns from that subject area to the analysis, then the subject area is not related to the analysis after you close and reopen the analysis. Avoid assigning logical column same name as logical table or subject area. Obiee 11g now supports ragged unbalanced and skipped hierarchy. Creating a repository using the oracle business intelligence administration tool. That is because in the entire a sample sales subject area the only presentation columns representing the keys for the levels in the logical hierarchy are p1 product and p2 product type. For example, an employee hierarchy might have no levels, but instead have names of employees who are managed by other employees.
Lets see how to pass parameters from one report to the other using hierarchical columns. Hi all, i am absolutely new to obiee and i am not able to create a subject area in it. In this release, you can work with multiple subject areas. In the subject areas pane in the criteria tab or the results tab, select the subject area, folder, column, or hierarchy level for which you want to view metadata information. No hierarchical relationship exists between these members, as is the case for members of a hierarchical column. 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. Obiee 11g presentation hierarchyhierarchical column. I briefly i touched on a few administration tasks such as starting and stopping the obiee components, but in this posting i want to look at this topic in more detail, looking at where all the various files have gone and how you perform basic administration on the system. See the readme file for installation and opatch version instructions. Obiee catalog manager determine which dashboards utilize.
1323 203 942 393 142 1128 191 1167 389 326 1344 1524 727 419 406 1451 855 713 251 1104 572 1140 860 718 215 340 400 1357 42 841 1179 293 769 727 1339 21 1100 1373 1564 647 951 214 769 1343 1078 1198