How to connect Essbase into OBIEE 12c

User_K7682

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

1. http://ip:port/
2. http://ip:port/aps
3. http://hostname:port/aps/Essbase?ClusterName=EssCluster1

for your reference, I have attached a screenshot

.

Thanks & Regards

Prasanna A

Gianni Ceresa

What is your exact version of OBIEE? (12c doesn't mean anything as there are 5 main versions and many many more bundle patches).

Did you check the certification matrix?

OBIEE 12.2.1.4 is certified for Essbase 11 and 12, you are using Essbase 9: a very very old release (2005 or there around) and things changed with 11 and following releases.

User_K7682

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

Gianni Ceresa

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

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 .