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…
Components developed using JDeveloper can be migrated onto instance using the following simple steps. 1. DB objects creation 2. Copy the class files to custom top. 3. Importing MDS repository (UI related files) 4. Registration of the page Oracle Apps environment 1. DB objects creation: Create an sql script that…
Building OAF page for displaying contact
Written by Uday
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 ,…
How to setup JDeveloper and OAF Project
Written by Uday
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…
OBIEE 10g to OBIEE 11g Upgrade for Repository and Presentation Catalog
Written by Saurabh Kumar, OBIEE Architect, Adiva Consulting
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…
Read 17748 times
Published in
OBIEE
Advance BI Publisher Concepts - Sorting in RTF Template
Written by Venkat, Principle Consultant, Adiva consulting
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…
Read 21307 times
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…