Unable to connect OBIEE Admin to Essbase

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.

my OBIEE Admin version - 12.2.1.4.0 and Essbase version - 11.1.2.4

OS - windows 10 64bit

Installation:-

1. First, I have installed Essbase with all the diagnostics are passed.
2. 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 :-

1. OBIEE and Essbase are installed in the same machine in the "C:\Oracle\Middleware" folder
2. 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

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