On obiee 11g, always open admintool through the start program menu within the. Each logical level of each dimensional hierarchy contains a setup named number of elements at this level. The prompts designer can now limit a column prompt value list by more than one column. Oracle bi ee 11g handling double columns iddescription. Much waited obiee 12c is released all new features. Obiee 12c new features oracle business intelligence and. When you create a view, you can choose a recommended view type based on the data in your analysis and, optionally, what you want to use it for for example, to analyze trends. The diagram above shows obiee application layer architecture. You might be unable to download analysis results based on the security features that have. Enabling double column support by assigning a descriptor id column. Obiee 11g double column descriptor id kn jun 11, 2012 7. Obiee 11g double column descriptor id gerardnico the data. This chapter describes how to create analyses in oracle business. The number of columns that you include in a prompt can affect performance.
The double column feature provides this ability in 11g. 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. 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. In bi ee 10g, there was no automated way of filtering on ids when end users chose the description values in the prompts. Jul 18, 2014 in obiee 10g, there was no automated way of filtering on ids when end users chose the description values in the prompts. Nov 15, 20 new presentation features 1 recommended visualizations feature for creating views. For information on double columns, see understanding the double column feature. I have a time dimension, for which i am using year, period name and period number. Assigning a descriptor id column enables double column support, a feature which helps in defining languageindependent filters. Obiee 11g double column descriptor id hello all, i have a problem in implementing descriptor id functionality. If you do not use this parameter, it is assumed that the value is a display value. For using it on a pivot, you must first convert your table view as a pivot view.
Obiee11g lookup table is a new feature in obiee 11g. Obiee subquery in 11g edit column formula 3260117 jun 21, 2016 8. Oracle bi ee provides a feature called double columns. Sep, 20 we have seen lot of customers asking how to deploy samplesales rpd. If you are working with double columns, you can now write the sql statement so that filtering is done on code values rather than display values. Nov 21, 2011 new features in obiee 11gui new features. Here is a list of all the new features introduced with obiee 11. If you are working with double columns, you can now write the sql. Visual analyzer is the primary component of oracle data visualization and will require an additional license for existing oracle bi customers. If your repository is configured for double columns, then ensure that you select the correct display column. Export bi catalog captions from command line in obiee 11g.
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. A configured weblogic authentication chain to enable 11g users to sign in to 12c domain. In many implementations where data is captured in multiple languages, the descriptions might be stored in different languages. This brief overview highlights the new features and capabilities delivered in oracle business intelligence version 11g. Understanding obiee 11g security, application roles and application policies. This release includes an enhancement to the prompt constraint option. From certification matrix we learn they are new sources and new versions of certified data sourc. For example, in answers, users see the display column, but the query filters on the hidden descriptor id column.
A default obiee 11g installation includes the sampleapplite rpd file and web catalog. Apr 01, 20 new features for referencefollowing are new features in obiee 11. 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. Obiee tutorial a beginner guide by obiee professionals. This video shows you how to install obiee 12c on windowslinux. Topics this handson portion workshop will cover the following topics. Obiee 10g11g repository rpd file gerardnico the data.
Mar 27, 2012 obiee 11g installation 1 download obiee 11g. Sep 04, 20 here is a list of all the new features introduced with obiee 11. May 28, 2017 if you chose to create a new column, a create new data element window opens allowing you to input logical sql functions similar to the edit column formula feature in obiee analytics. I have placed period number as period name id column and in the report i am using the period n. Mar 16, 2012 this brief overview highlights the new features and capabilities delivered in oracle business intelligence version 11g. Jan 27, 20 obiee11g lookup table is a new feature in obiee 11g. This feature allows a column prompt to be displayed as a slider and the user can use the slider to slide thru the. How to create a basic obiee 11g repository oracle bi 11g. Here are the steps to deploy samplesales rpd on your machine. For security purposes you must use references in the function rather than the values themselves. 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. How to use the write back functionality in obiee 11g.
List of all the new features introduced with obiee 11. Obiee 11g double column descriptor id oracle community. The features in obiee presentation services are defined in xml and called via jsf on runtime. Uninstalling obiee 11g instance on a linux red hat. 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. The catalog and weblogic security configurations needs to be reconfiguredmigrated like in obiee 11g.
Obiee subquery in 11g edit column formula oracle community. Creating and managing logical columns oracle help center. In 10g, there was an option to download data, but it was only tab delimited, not comma seperated. In many implementations where data is captured in multiple languages, the. Common obiee implementation mistakes that impact performance. Obiee configure level number of elements in dimensional. Following are some key highlights of this new release. A display column contains the display values for the column data, for example, excellent, good, and poor. The evaluate function enables you to send a function to the database to evaluate and return data to obiee. Jul 26, 2018 the double column feature provides this ability in 11g.
Aug 18, 2010 the double column feature provides this ability in 11g. We can migrate the oracle bi 11g metadata to 12c is a two step process, and is carried out by using the bi migration script migrationtool. When that gray vertical line appears in the correct location. If i have missed anything, please feel free to add it through comments. Obiee 11g double column support for dashboard level prompt. Double column in obiee oracle bi ee provides a feature called double columns.
Mar 08, 2017 a working environment of obiee 11g 11. Introduction to oracle business intelligence enterprise. Obiee 12c installation obiee tutorials obiee traning. But the filtering of data will be on ids which will be the same across languages. 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. It also explains subject areas and columns, the double column feature, and. When multilingual columns are based on a lookup function, it is common to specify the.
Building mapbased dashboards page 2 purpose the following workshop material is designed to introduce the new map view feature of oracle business intelligence suite enterprise edition plus obiee 11g through a set of simple handson exercises. Double column is probably one of the most undervalued and unused features of obiee. It provides a mechanism for associating two logical columns. Additionally, i make use of select by code column and filter by code column, i do not view any difference. This is one feature that i am pretty sure everyone expects by default in a reporting tool i. This setup number is used by the oracle bi server when defining strategy for picking optimal aggregate physical source for a query.
In general, you should limit the number of columns to as few as possible. Home middleware oracle fusion middleware online documentation library, 11g. When multilingual columns are based on a lookup function, it is common to specify the nontranslated lookup key column as the descriptor id column of the translated column. Now it is possible to filter on the ids when an end user chooses its description.