Oracle Business Intelligence

Products Banner

OBIEE 12C and Essbase 11.1.2.4 integration issue

Received Response
86
Views
12
Comments

Can I import data from Hyperion Essbase 11.1.2.4 to Obiee 12c?

1 Machine

Hyperion Essbase 11.1.2.4 integrated with OBI EE 10g without issues

2.

2.1

jdk1.8.0_171

Win Server 2012 R2

OBI EE 12.2.1.0.0

Essbase Client 11.1.2.4 Installed

When i try to connect to essbase server in bi admin tool i get

1)The connection has failed. Essbase error XXXX

2)In some cases i can see cubes from Essbase Server but when I try to import one of then admin tool crashes

2.2

jdk1.8.0_171

Win 10 Pro

OBI EE 12.2.1.4.0(fmw 12.2.1.3.0 I havent found fmw 12.2.1.4.0)

Essbase Client 11.1.2.4 Installed

When i try to connect to essbase server in bi admin tool i always get

The connection has failed. Essbase error XXXX

2.3

jdk1.8.0_171

Win Server 2012 R2

OBI EE 12.2.1.4.0(fmw 12.2.1.3.0 I havent found fmw 12.2.1.4.0)

Essbase Client 11.1.2.4 Installed

Same as 2.2

2.4

jdk1.8.0_171

Win Server 2012 R2

OBI EE 12.2.1.3.0(fmw 12.2.1.3.0)

Essbase Client 11.1.2.4 Installed

Same as 2.3

WORKAROUND

I always created 2 ENV VARS

ARBORPATH=c:\Oracle\Middleware\Oracle_Home\bi\clients\Essbase\EssbaseRTC

ESSBASEPATH=c:\Oracle\Middleware\Oracle_Home\bi\clients\Essbase\EssbaseRTC

or

ARBORPATH=c:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient

ESSBASEPATH=c:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient

I always added to Path path to appropriate client bin folder

I always added

set ARBORPATH=...

set ESSBASEPATH=...

to c:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\bin\admintool.cmd

I  really dont understand what should i do

Example of Error In admin tool log

[2018-04-25T01:16:01.649+03:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 12d4] Essbase Error 6815860 [[

file: C:\ADE\fanzha_h122130_190\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 67

]]

In essapinu.dll i see Product Name "Oracle Essbase 12.2.1.3"

Answers