How to connect Essbase into OBIEE 12c

Question

Hi All,

Last two day am trying to connect OBIEE (12c) with Essbase 9,  am facing error message 0. am not able to get the solution properly, please help me to fix this

I have tried with Essbase server like

* http://ip:port/
* http://ip:port/aps
* http://hostname:port/aps/Essbase?ClusterName=EssCluster1

for your reference, I have attached a screenshot

.

Thanks & Regards

Prasanna A

User_K7682 · Answer

ya, I tried with hostname: port number combination also, it showing the same error code.

Hostname I cross-checked in cmd prompt its correct  and port number I have tried with 19000, default port 1423

please suggest some idea to fix this issue .

Gianni Ceresa · Answer

I highly doubt an Essbase server has an http:// address, "Essbase Server" is the address where the Essbase agent can be connected, it isn't an http:// link.

Read the doc, it tells you most of the things you should look for: https://docs.oracle.com/middleware/12213/biee/BIEMG/GUID-21A9BD61-C729-4F51-AEE9-630CA7B49A8F.htm#GUID-E6664744-3726-46A6-AB28-0F28C5657072

User_K7682 · Answer

Thanks, Gianni Ceresa for replaying

My OBIEE version is 12.2.1.3.0 and my Essbase version is 11.1.2.4.037.16 (by my mistake I was mentioned 9)

I have checked that certification matrix, versions are supporting

I have recreated the database in OBIEE, now it shows a different error code

(while creating the database in OBIEE by selecting database type as Essbase 11 but it showing Essbase 9+)

please help me to fix the issue.

Thanks

Prasanna A