Double column is probably one of the most undervalued and unused features of obiee. Obiee obia onlineoffline training obiee 11g,obia 7963 contact info. Repositories can be edited with the administration tool in either online or offline mode. Download the obiee 11g version from here or from oracle edelivery site and extract all the four disk into a single folder and click setup. Visual analyzer is the primary component of oracle data visualization and will require an additional license for existing oracle bi customers. Steps to configure write back functionality in obiee 11g. In obiee 10g, there was no automated way of filtering on ids when end users chose the description values in the prompts. Double column in obiee oracle bi ee provides a feature called double columns. In general, you should limit the number of columns to as few as possible. Oracle is doing additional integration steps towards the one big oracle bi.
Feb 22, 2017 many new features has been added in the obiee 12c including new views, new ui level functions, column properties, powerful visual analyzer tool etc. Obiee answers 11g cornell customized version april 2012 minor corrections were made on page 2, for the oct 20, 2017. You may either double click the column, or you may clickholddrag the division column with the left mouse button, moving the mouse to the appropriate location for the new column, looking for a gray vertical line. If you are working with double columns, you can now write the sql statement so that. 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 multilingual columns are based on a lookup function, it is common to specify the. When a repository is configured for the double column feature, column data includes a display column that has a code column mapped to it that is, it has double columns. It provides a mechanism for associating two logical columns.
On obiee 11g, always open admintool through the start program menu within the oracle business intelligence menu. In many implementations where data is captured in multiple languages, the descriptions might be stored in different languages. A display column contains the display values for the column data, for example, excellent, good, and poor. Obiee tutorial a beginner guide by obiee professionals. Nov 15, 20 if an analysis contains a total or grand total and the associated attribute or hierarchical column contains an action link or a conditional action link, the action link or conditional action link is applied to both the column and the total or grand total 11 new bi desktop tools available for download. If an analysis contains a total or grand total and the associated attribute or hierarchical column contains an action link or a conditional action link, the action link or conditional action link is applied to both the column and the total or grand total 11 new bi desktop tools available for download. Any analysis that includes a column associated with a configured map feature is ready to be rendered in a map view without any.
In this section participants will create interactive maps using the new obiee 11g map views feature. Business models are always dimensional, unlike objects in the physical layer, which reflect the organization of the data. Oracle bi ee 11g handling double columns iddescription. Underuse of double column feature double column is probably one of the most undervalued and unused features of obiee. In part 1 of this twopart blog post series, we cover two issues that you. Oracle bi ee provides a feature called double columns.
This release includes enhancements to the parameters for prompted links. You may either doubleclick the column, or you may clickholddrag the division column with. Select revenue from the base facts folder and drag it to the selected columns area. If your repository is configured for double columns, then ensure that you select the correct display column.
For security purposes you must use references in the function rather than the values themselves. Apr 01, 20 new features for referencefollowing are new features in obiee 11. Aug 01, 2016 write back is the feature ability in obiee to allow the user to enter a value or values directly into a report and have those values written to an actual physical table in the database. The diagram above shows obiee application layer architecture. Select set a variable as presentation variable and give date as the variable name. The only way is exporting the view to another file and then copypaste.
Much waited obiee 12c is released all new features. Now it is possible to filter on the ids when an end user chooses its description. Tips for using oracle business intelligence enterprise edition. For example if you are doing a country based sales analysis, its easy to color code each country across the. But the filtering of data will be on ids which will be the same across languages. Allows up to 16 oracle bi servers in a network domain to act as a single server 2.
If you are working with double columns, you can now write the sql statement so. Each obiee 11g obiee domain contains single web logic domain. The error is generated when you try to download more than 65,000 rows in comma separated value csv format. Do not open the rpd by simply double clicking on the rpd file or typing admintool. Servers in cluster share requests from multiple oracle bi clients, including oracle bi answers and oracle bi delivers. If you want to use it on a pivot, you must first transform your table view as a pivot view. Here is a list of all the new features introduced with obiee 11.
This version has many improvements, enhancements, and advanced new features in installation, migration, analyses and dashboards, oracle bi mobile, oracle bi publisher, metadata repository development, system administration, integration and api, and localization. For example if you are doing a country based sales analysis, its easy to color code each country across the world right within the maps. Obiee 11g allows bi administrators to preassociates the business model with mapping data so that analysis results are automatically mapready. The column properties entry now allows you to anchor a column or more at any edge of a dashboard layout. You can use this functionality only in a table view. Sep, 20 we have seen lot of customers asking how to deploy samplesales rpd. There is an enhancement request for this functionality to be included in a future 11g version. The administration tool also includes a session manager and a cache manager which are available in online mode.
Weird behaviour of obiee 11g hierarchy columns hi, im facing this weird issue when i implement the obiee 11g new feature called hierarchy column. Jul 26, 2018 the double column feature provides this ability in 11g. The double column feature provides this ability in 11g. A lof of effort has been put in improving excel integration in obiee. This feature has 2 fold advantages this feature has 2 fold advantages. Universal installer window will start and will check for the initial set up and system requirement. Mar 27, 2012 once we are done with rcu, start installing obiee 11g 64bit software. The new release of oracle business intelligence foundation suite 11g, release 11. When that gray vertical line appears in the correct location.
A configured weblogic authentication chain to enable 11g users to sign in to 12c domain. The following sections describe the major new features in this release of the oracle business. This blog gives you step by step entreprise installation of obiee 11. The evaluate function enables you to send a function to the database to evaluate and return data to obiee. If i have missed anything, please feel free to add it through comments. In this topic, you will see how to download the template builder addin, and install it. Here are the steps to deploy samplesales rpd on your machine. One is used for installing installer of web logic and the other one is used for installing the installer of obiee.
For using it on a pivot, you must first convert your table view as a pivot view. Mark has covered horizontal clustering using the scaleout option in the installer in his previous post here. Write back is the feature in obiee oracle business intelligence enterprise edition which allows the user to enter a value directly into a column and have those values reflected on an actual table in the database. Cluster controller is a primary component of the cluster server feature. List of all the new features introduced with obiee 11. For information on double columns, see understanding the double column feature. Better integration between dashboards and bi publisher, better integration with hyperion tools essbase tools in obiee installation, smart view integration and initial steps of integrating endeca search in catalog using endeca out of the box and bi publisher working with endeca.
In bi ee 10g, there was no automated way of filtering on ids when end users chose the description values in the prompts. Many new features has been added in the obiee 12c including new views, new ui level functions, column properties, powerful visual analyzer tool etc. For more information, see the limit values by component in the new prompt dialog. In obiee 11g, this file is found at the following location. You can also doubleclick the column names to get it in the columns area. Sep 04, 20 list of all the new features introduced with obiee 11. Apr 02, 20 the prompts designer can now limit a column prompt value list by more than one column. The prompts designer can now limit a column prompt value list by more than one column. In the logical column dialog, in the general tab, click set next to the descriptor id column field.
Obiee 11g double column descriptor id gerardnico the data. Installing template builder and exploring the template builder user interface. The oracle application layer or popularly known as the fusion middleware layer is built upon a common domainbased architecture that can support as a set of common core functionality like security, scalability etc across various oracle products. You can also double click the column names to get it in the columns area. New features for referencefollowing are new features in obiee 11. This feature allows a column prompt to be displayed as a slider and the user can use the slider to slide thru the specific values of that column, changing the. Obiee 10g11g repository rpd file gerardnico the data. The administration tool is a windows application that allows the bi server administrator to create and edit repositories. Obiee 11g double column descriptor id kn jun 11, 2012 7. A default obiee 11g installation includes the sampleapplite rpd file and web catalog. In many implementations where data is captured in multiple languages, the descriptions might. Direct insertion recommended approach oracle bi server inserts statistics for every query directly into a relational database table.
Oracle bi ee 11g should be able to connect to a supported data source. Having seen so many ways on how you can secure your presentation layer based on logged in user profile, i thought this would be a nice place to consolidate the list together and give you step by step guides on these implementations. In any environment if there is a column change, audit table can be referred to find the change made by user and inserted in the table. From certification matrix we learn they are new sources and new versions of certified data sources.
This is one feature that i am pretty sure everyone expects by default in a reporting tool i. In the reason column, check the reason for the warning. The addition of the freeze column option to the column properties menu. Posts about column level security written by harikv. Requests or reports have been renamed to analyses, and the term reports now refers to bi publisher reports. Jul 18, 2014 obiee 11g double column support for dashboard level prompt. Thanks a lot for sharing all of this information on the features of obiee 11g. In many implementations where data is captured in multiple languages, the. Aug 18, 2010 the double column feature provides this ability in 11g. How to use the write back functionality in obiee 11g. Obiee 10g11g administration tool admintool, datamodel.
The issue is that the last value in the hierarchy is reporting example store heirachy store country store city store name store na. In 11g, the following terminology changes have been made. We have seen lot of customers asking how to deploy samplesales rpd. Once we are done with rcu, start installing obiee 11g 64bit software. Select product from the products folder and drag it to the selected columns area. To view the column details, click view to open the logical column dialog for that column, and then click cancel.
Obiee 11g double column descriptor id oracle community. Presentation columns have been renamed to attribute columns, and a new column type, hierarchical column, is introduced. Obiee 11g rpd we have new feature to show double columns value using a single one column description id double click on any of the bmm column in general tab you can see description id column as shown below let say product is our column i want to show the product names with their product keys in dashboard prompt. The other big change in bi ee 11g as mentioned before here, is the ability to assign id columns for descriptive columns more commonly known as double columns. State name column, add a filter for country code usa and c62 geo.
To add the columns to your analysis doubleclick the column name or click the column name. The number of columns that you include in a prompt can affect performance. This version has many improvements, enhancements, and advanced new features in installation, migration, analyses and dashboards, oracle bi mobile, oracle bi publisher, metadata repository development, system administration, integration and. This version is another major release from oracle after obiee 10g and11g. New features for oracle business intelligence users oracle docs.
Following are some key highlights of this new release. Mar 08, 2017 a working environment of obiee 11g 11. Write back is the feature ability in obiee to allow the user to enter a value or values directly into a report and have those values written to an actual physical table in the database. There are two jdks, one is oracle jdk and another one is jrock. Obiee 11g double column support for dashboard level prompt. Bug 10406798 unable to copy data from 11g table or pivot table like in 10g currently slated to be addressed in 11. Sending alerts in oracle biee 11g by using oracle bi delivers. Create one sample analysis, add date column on which you want to prompt and change. The business model and mapping layer of the oracle bi repository defines the business, or logical, model of the data and specifies the mapping between the business model and the physical layer schemas. Introduction to oracle business intelligence enterprise.
181 306 230 120 1218 217 734 860 1566 1376 509 887 1467 803 1129 155 634 1545 1528 1036 1140 1152 671 596 80 895 485 269 857 831 269 390 99