Everything Oracle

OBIEE EBS Organization

The following diagram shows a simplified representation of OBIEE in the context of E-Business Suite (EBS) integration:

OBIEE Configuration Files

An end user’s web browser makes a request to the BI Presentation Services process to retrieve a report or dashboard. The BI Presentation Services process passes on the queries needed to retrieve the associated data to the BI Server process. The BI Server process maps the simplified queries incoming from the BI Presentation Services process into queries that target Daily Business Intelligence (DBI) Base Summary tables and forwards these queries to EBS. Data is returned and integrated in the reverse direction.

BI Presentation Services

When the BI Presentation Services process is started, it first reads configuration file “instanceconfig.xml”. This file contains the name and location of the EBS catalog, “EBSAnalyticMaster”, which contains definitions of the Fusion Intelligence reports and dashboards. Then the Presentation Services process reads the contents of the EBS catalog.

The layout and functionality of the BI Answers and BI Dashboards screens that are sent to the end user’s web browser by the BI Presentation Services process are defined by a set of XML messages. The default set of messages can be overridden by creating a set of custom messages. The set of custom messages used by Fusion Intelligence is stored in file “custommessages.xml”. This file is read and its contents processed as the BI Presentation Services process starts up.

BI Server

When the BI Server process is started, it first reads configuration file “NQSConfig.INI”. This file contains the name of the EBS repository, “EBSAnalyticMaster.rpd”, which contains the definitions of the Fusion Intelligence metadata mappings for the Base Summary tables within the DBI component of EBS. Then the BI Server reads the contents of the EBS repository.

Preparation

Locate the “Fusion Intelligence for E-Business Suite 12.0.2” DVD in the “Oracle E-Business Suite Applications Release 12.0.4” media pack, or from an equivalent source.

On the DVD, you’ll find in file “p5999439_R12.BIS_PF.A_R12_GENERIC.zip” an EBS patch that fixes a number of Fusion Intelligence related bugs. Unzip the file, and use Autopatch to apply the united driver file. Check Metalink for any additional patches that may be available.

Also on the DVD, you’ll find file “p6003217_R12_GENERIC.zip”. Unzip this file and, within directory “Oracle_EBS_Fusion_Intelligence”, you’ll find the EBS catalog folder, “EBSAnalyticMaster”, the EBS repository, “EBSAnalyticMaster.rpd”, and the custom messages file, “custommessages.xml”. Once again, check Metalink for any updates that may be available.

When you installed OBIEE you’ll have selected a home directory which contains two Oracle BI sub-folders “OracleBI” and “OracleBIData”. In the following sub-sections these sub-folders will be referred to as “<OracleBI Home>” and “<OracleBIData Home> respectively. In directory paths use forward slashes for Unix and backslashes for Windows.

Stop the BI Server and BI Presentation Services processes.

BI Server Configuration

Copy the EBS repository, “EBSAnalyticMaster.rpd”, to directory “<OracleBI Home>\ server\Repository”.

In directory “<OracleBI Home>\server\Config” you’ll find configuration file “NQSConfig.INI”. Edit this file with a text editor and alter the text within the “repository” section as follows, commenting out the existing repository definition by preceding it with a “#”:

[ REPOSITORY ]

#Star = samplesales.rpd, DEFAULT;
Star = EBSAnalyticMaster.rpd, DEFAULT;

Restart the BI Server process. Start the Administration Tool: “Start => All Programs => Oracle Business Intelligence => Administration”. Open the EBS repository online: “File => Open => Online”, and press “Open” when the pop-up window appears (“Administrator” is a predefined repository user and it has no password). If you’ve configured the BI Server correctly, then you should see the following screen:

EBS Repository

BI Presentation Services Configuration

Copy the EBS catalog folder, “EBSAnalyticMaster”, and its contents to directory “<OracleBIData Home>\web\catalog”.

Copy the custom messages file, “custommessages.xml”, to directory “<OracleBI Home>\web\msgdb\customMessages” (note, the path is via “<OracleBI Home>”, not “<OracleBIData Home>”).

In directory “<OracleBIData Home>\web\config” you’ll find configuration file “instanceconfig.xml”. Edit this file with a text editor and alter the text within the “CatalogPath” tag pair to reflect the location of the EBS catalog:

<CatalogPath> ...
... <OracleBIData Home>/web/catalog/EBSAnalyticMaster ...
... </CatalogPath>

The value of “<OracleBIData Home>” will already have been set during the OBIEE installation.

Restart the BI Presentation Services process. Display the BI Presentation Services logon screen: “Start => All Programs => Oracle Business Intelligence => Presentation Services”. Enter a value of “Administrator” in the “User ID” field, leave the “Password” field blank, and press “Log In”. If you’ve configured the BI Presentation Services correctly, then you should see the following screen:

EBS Default Dashboard

Everything Oracle

Home

Everything Oracle

Oracle’s	Fusion	Intelligence

Repository, Catalog, and Custom Messages Configuration