Connecting BO IDT 4.1 with Essbase application

general discussion
1

I have BO - IDT Version: 4.1 Support Pack 2 installed in my PC. When I am trying to connect to Essbase cube present remotely, below is the error it’s throwing.
“The Essbase Client middleware is not installed”

I’ve Essbase client installed in my PC and ARBORPATH, ESSBASEPATH and PATH variables are set in Windows system environment variables in my PC (which is 64-bit desktop).

ESSBASEPATH=C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC-64\11.1.2.0
ARBORPATH=C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient
PATH=C:\Oracle\Middleware\EPMSystem11R1\bin;C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC-64\11.1.2.0\bin;C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient\bin;%PATH%

I’ve followed the steps mentioned in the below doc.
https://www.sap.com/documents/2016/06/12a937f2-757c-0010-82c7-eda71af511fa.html

Please let me know what is wrong here.

Thanks,
Jameel
Error-SS.doc (116.0 KB)

jameelj (BOB member since 2017-03-27)

2

Welcome to B:bob:B!
I found it painful setting this up. Is this an error when you attempt to create a universe connection or is this you doing an initial test of the middleware install?
Couple of things is Essbase definitely supported with that version of BO? Also, drop in to a command prompt and try the startesscmd command from the bin folder. Then type login and your server and port…provide username and password…oh I used a 32 bit set of drivers not 64.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Thank you!

  1. I am trying to create new OLAP connection in IDT.
    In next window, it’s showing the list of middleware drivers available.
    I have selected Hyperion Essbase 11x>>Essbase API for analysis.

  2. I saw in SAP forum that IDT 4.1 supports Essbase connectivity.

  3. I am able to connect to Essbase server using the Essbase client installed in my machine.

  4. I have tried setting 32-bit and 64-bit paths in environment variables, still it is showing the same error (as given in the screenshot).

jameelj (BOB member since 2017-03-27)

4

Can someone help me in setting this up. We are stuck up with this and do not find any resources, online for help.

jameelj (BOB member since 2017-03-27)