Essbase Client and OBIEE Client Connection

In order to IMPORT AN ESSBASE CUBE in Administration Tool, make sure you have all this setup:

Note: Essbase Version: 11.1.2.1 OBIEE Version: 11.1.1.6.2

    1.       Essbase Client must be installed

    2.       ARBORPATH = C:\Oracle\Middleware\Essbase1\EPMSystem11R1\products\ExcelAddin

    This is EPM_ORACLE_HOME\products\ExcelAddin 

    3.       ESSBASEPATH = C:\Oracle\Middleware\Essbase1\EPMSystem11R1\products\ExcelAddin

    This is again EPM_ORACLE_HOME\products\ExcelAddin

Incase, you haven’t installed the Excel Addin, then this will be the path for ARBORPATH AND ESSBASEPATH:

ARBORPATH = ESSBASEPATH C:\Oracle\Middleware\Essbase1\EPMSystem11R1\products\Essbase\EssbaseServer

1.       PATH = C:\Oracle\Middleware\Essbase1\EPMSystem11R1\products\Essbase\EssbaseServer\bin

This is EPM_ORACLE_HOME\products\Essbase\EssbaseServer\bin

2.       Check the Admin tool now and try to import the Essbase cube. If it still doesn’t work then…

3.       Make sure you add/have these lines included the bi-init.bat file located at your ORACLE_HOME\bifoundation\server\bin

In my case its C:\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin

Note: bi-init.bat takes care of the connections between the Admin tool and any external resources to be connected with it.

Few contents from the file are excerpted as below:

bi-init.bat

set ORACLE_HOME=C:\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome

set ORACLE_INSTANCE=C:\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst

set ORACLE_BI_APPLICATION=coreapplication

set ESSBASEPATH=C:\Oracle\Middleware\Essbase1\EPMSystem11R1\products\Essbase\EssbaseServer

set ARBORPATH=C:\Oracle\Middleware\Essbase1\EPMSystem11R1\products\Essbase\EssbaseServer

rem call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\%ORACLE_BI_APPLICATION%\setup\user.cmd

if NOT "%1" == "" set COMPONENT_NAME=%1

set PATH=%ORACLE_HOME%\bifoundation\server\bin;%ORACLE_HOME%\bifoundation\web\bin;%ORACLE_HOME%\bin;C:\Oracle Business Intelligence Enterprise Edition Plus Client\jre\bin;%windir%;%windir%\system32;%ESSBASEPATH%\bin;%ARBORPATH%\bin;%PATH%

Note: The path of the folders should point to the bin folder where you have the dll files such as essapinu.dll which are vital for establishing the connection between Essbase and other applications.