Xcelsius cannot connect to ESSBASE 11.X

[Former Member]

I have the following trouble, i need to connect a dashbboard to an ESSBASE based UNX, however when i try to make the query in the query browser i get the message:

XLS 000009

the required Essbase      client Jars were not found:

ess_japi.jar; ess_es_server.jar; ojdl.jar, please check your configuration

classpath.&gt

I reviewed the classpath in the tomcat console on JAVA options and put the path to those JAR's but it still  does not work.

we are using

BO SP05 FP2 on windows server trying to connect to ESSBASE 11.X

Any help will be apretiated.
 
Regards and have a nice day.

[Henry_Banks]

Hi,

please refer to Note 1758332 - How to Configure Essbase Middleware for BI
4.0  (

http://service.sap.com/sap/support/notes/1758332)

it references this SCN page: http://scn.sap.com/docs/DOC-23141

Here is the bulk of the info copy pasted:

Step1:

The machine on which IDT is installed, please install 32bit Essbase

client.

Step2:

Please check if following Jars are available:

1)

Ess_japi.jar and

2) ess_es_server.jar under

%HYPERION_HOME%/common/EssbaseJavaAPI/11.1.2.0/lib

and,

3) Ojdl.jar under

%HYPERION_HOME%/common/loggers/ODL/1.0.0/lib

Step3:

Copy the 3 JAR

files from the Oracle Essbase client installation directory to the java\lib BIP

Client Tools installation directory.

Step4:

Set following Environment

variables

On a 32bits machine where you want to run WebIRC (always 32bits),

you need to have these variables defined:

1. SET

ESSBASEPATH=C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\ 11.1.1.4

2.

SET ARBORPATH=C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\

11.1.1.4

3. SET ESSLANG=English_UnitedStates.Latin1@Binary

4. SET

EPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1

5. SET

HYPERION_HOME=C:\Oracle\Middleware\EPMSystem11R1

6. SET

PATH=%PATH%;C:\Oracle\Middleware\EPMSystem11R1\bin;C:\Oracle\Midd

leware\EPMSystem11R1\common\EssbaseRTC\ 11.1.1.4\bin;

On a 64bits

machine where you want to run WebIRC (always 32bits), you need to have these

variables defined:

1. SET

ESSBASEPATH=C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\ 11.1.1.4

2.

SET ARBORPATH=C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\

11.1.1.4

3. SET ESSLANG=English_UnitedStates.Latin1@Binary

4. SET

EPM_ORACLE_HOME=C:\Oracle\Middleware\EPMSystem11R1

5. SET

HYPERION_HOME=C:\Oracle\Middleware\EPMSystem11R1

6. SET

PATH=%PATH%;C:\Oracle\Middleware\EPMSystem11R1\bin-32;C:\Oracle\M

iddleware\EPMSystem11R1\common\EssbaseRTC\ 11.1.1.4\bin

Regards,

H

[Former Member]

Hi Henry,

I followed the exact steps mentioned by you as well as in the Note 1758332. I am still getting  following error in IDT.

"The Essbase Client middleware is not installed".

Also I just noticed, I don't have the following file or ODL folder

3) Ojdl.jar under

%HYPERION_HOME%/common/loggers/ODL/1.0.0/lib

Any thoughts where I am going wrong?

Thanks, Siva

[former_member194862]

Hi Elio,

You can try using odbc drivers,you need to create two system dsn one 32 bit and one 64 bit both of the same name pointing to the database and use that dsn in the IDT.

Thanks and Regards,

Amit

[Former Member]

Thank you very much for your answer Amit but I'm trying to connect to an OLAP ESSBASE cube so the ODBC's are not useful or dou you mean something else???

Regards