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"
