Hyperion & stuff

Stuff about Hyperion and stuff

OBIEE 11 and Essbase

OBIEE 11g, Essbase

After installing OBIEE 11g on my Windows XP laptop which runs Essbase, I found out that the Oracle BI admin tool was unable to connect to the installed version of Essbase.  After a bit of research, I found out that OBIEE 11g will only run with the included Essbase 11.1.2 version client.  This caused a problem on my machine since all Essbase environment variables on my machines are pointing to version  My workaround for this is by creating a separate batch file to start the Oracle BI admin tool as pasted below.


set ARBORPATH=C:\OBIEE\Oracle_BI1\clients\epm\Essbase\EssbaseRTC
set ESSBASEPATH=C:\OBIEE\Oracle_BI1\clients\epm\Essbase\EssbaseRTC

set PATH=c:\OBIEE\Oracle_BI1\bin;c:\OBIEE\Oracle_BI1\opmn\bin;c:\OBIEE\Oracle_BI1\opmn\lib;c:\OBIEE\Oracle_BI1\perl\bin;%ARBORPATH%;%ARBORPATH%\bin

C:\WINDOWS\system32\cmd.exe “/cc:\OBIEE\instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.cmd coreapplication_obis1 2 && c:\OBIEE\Oracle_BI1\bifoundation\server\bin\AdminTool.exe”


Now my Admin Tool can connect to the installed Essbase.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: