Lookup table is a new feature in obiee 11g. This is used mainly to: • Resolve code columns and get description/name values from a lookup table. • It can also be used for checking the currency conversion values from a daily updated source. Lets try to see how this works.Assume…

Open the JDeveloper. Here we consider the user to be aware of how to use the JDeveloper. Create a project, configure design time and run time connection parameters. Create Table CONTACTS Create XX_CONTACTS (CONTACT_ID, FIRST_NAME, LAST_NAME, EMAIL_ADDRESS, MOBILE_PHONE, HOME_PHONE) table using the following script. CREATE TABLE xx_contacts( contact_id NUMBER ,…

OAF extensions or enhancements are built as OAF Projects, which can be delivered or migrated as individual files. To build OAF applications we need JDeveloper, an application Database along with server (called an instance), where we want to run the components we develop. Following are the basic steps need to…

Hierarchical table feature is a new addition to OBIEE 11g. A hierarchy can be created when a parent child table exists. Consider an Employee and manager table with the following hierarchy. To create an hierarchy out of this parent child table we follow the steps as detailed below. Step-1…

Have you tired to migrate OBIEE 10g Repository and Presentation Catalog to OBIEE11g ? As a part of OBIEE 11g uptake exercise for one of our client, We tried it and went pretty well. I thought, lets share with our blog readers.. Pre-Requisites • Start up all the OBIEE 11g related services (BI…

The objective of this post is to explain the “sorting” capabilities available in the RTF. Many might already be aware of the standard BI Publisher syntax for sorting in the RTF template: <?sort:VENDOR_NAME?> The above construct sorts the data by the VENDOR_NAME in ascending order – an alphabetic…

If you moved to BI Publisher 11g or OBIEE 11g from BI Publisher 10g, you would have realized that debug option is no more part of BI Publisher Administration UI. In 10g we can set the debug log level from Administration UI under Server configuration section but in 11g no…