Hyperion & stuff

Stuff about Hyperion and stuff

OBIEE 11 and Essbase

OBIEE 11g, Essbase 11.1.1.3

After installing OBIEE 11g on my Windows XP laptop which runs Essbase 11.1.1.3, 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 11.1.1.3.  My workaround for this is by creating a separate batch file to start the Oracle BI admin tool as pasted below.

setlocal

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”

endlocal

Now my Admin Tool can connect to the installed Essbase.

Advertisements

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: