Hi,
Last three weeks am trying to connect OBIEE Admin to Essbase, am not able to connect that, it shows some errors (Error 2097266) which I mentioned below.
EssbaseError_2207.JPG (96.99 KB)my OBIEE Admin version - 12.2.1.4.0 and Essbase version - 11.1.2.4
OS - windows 10 64bit
Installation:-
First, I have installed Essbase with all the diagnostics are passed.
After that I have installed the Essbase Admin console, this one also working fine.
In OBIEE:-
I have created a new rpd, in that File -> Import metadata. this way am trying to connect.
Note :-
OBIEE and Essbase are installed in the same machine in the "C:\Oracle\Middleware" folder
I have tried with multiple Essbase server name like localhost, localhost: port, mycomputername, mycomputername : port
My previous ticket is still open with the same issue, for your reference
How to connect Essbase into OBIEE 12c (0 Bytes)for your reference, I have mentioned log's also
[2021-07-22T17:24:39.45+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 311c] Essbase Error 2097266 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66]]
[2021-07-22T17:25:31.325+05:30] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 311c] Essbase Error 2097266 [[
file: C:\ADE\fanzha_h122140_24\biserver\analytics\server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\PrivateInclude\SQXDGEssbaseCAPIImport.h; line: 66]]
My final aim is to want to get metadata in OBIEE from Essbase.
Please help me to fix this issue
Thanks