(UNIX) Configuring the Environment for Essbase and Oracle BI EE Integration

If you are using Oracle BI EE as the data source for Essbase, you must set additional environment variables for the Oracle BI EE driver before launching Essbase.

Note:

Essbase Release 11.1.2 integrates with Oracle BI EE Release 10g (10.1.3.4 and later) on UNIX.

  To configure the environment for Essbase and Oracle BI EE integration:

  1. Install the Oracle BI EE ODBC driver.

    Oracle BI EE ODBC driver components are installed in their own Home directory. Ensure that the UNIX users who have access/execute privileges to Essbase have the same privileges to the Oracle BI EE ODBC driver components.

  2. Modify odbc.ini (for Essbase) and odbcinst.ini (for Essbase Studio) to add the Oracle BI EE ODBC driver. These files are in EPM_ORACLE_HOME/common/ODBC/Merant/6.0. Modify the files by editing the DSN (for odbc.ini) or the driver descriptor (for odbcinst.ini) to include the absolute path for the Oracle Business Intelligence Enterprise Edition ODBC driver.

    Use the following example for the DSN entry for odbc.ini:

    [ODBC Data Sources]
:
OBI Paint=Oracle BI Server [DSN for OBI driver]

[ODBC]
IANAAppCodePage=4
InstallDir=/EPM_ORACLE_HOME/common/ODBC/Merant/6.0
Trace=1
TraceFile=/EPM_ORACLE_HOME/common/ODBC/Merant/6.0/odbctrace.out
TraceDll=/EPM_ORACLE_HOME/common/ODBC/Merant/6.0/lib/odbctrac.so

[OBI Paint] [DSN entry]
Driver=/.../OracleBI/server/Bin/libnqsodbc.so [path to load OBI driver]
Description=Oracle BI Server
ServerMachine=qtflnx10.us.oracle.com
Repository=
Catalog=
UID=Administrator	
PWD=Administrator
Port=9703

    Use the following example for the {driver descriptor} entry for odbcinst.ini:

    [ODBC Drivers]
Oracle BI Server=Installed [driver descriptor. same as the one in essbase.cfg]

[Oracle BI Server] [driver descriptor entry]
Driver=/.../OracleBI/server/Bin/libnqsodbc.so [path to load OBI driver]
APILevel=3
ConnectFunctions=YYN
DriverODBCVer=3.52
FileUsage=0
SQLLevel=2

  3. Add the following environment variables to the opmn.xml file: 

    <variable append="true" id="LD_LIBRARY_PATH"
   value="/vol1/prod1/OracleBI/server/Bin"/>
<variable append="true" id="LD_LIBRARY_PATH"
   value="/vol1/prod1/OracleBI/web/Bin"/>
<variable id="SATEMPDIR" value="/vol1/prod1/OracleBIData/tmp"/>
<variable id="SAROOTDIR" value="/vol1/prod1/OracleBI"/>
<variable id="SA_ROOTDIR" value="/vol1/prod1/OracleBI"/>
<variable id="SADATADIR" value="/vol1/prod1/OracleBIData"/>