OBIEE 12c connects to Essbase

Question

Dear experts,

I'm trying to connect OBIEE 12c with Essbase from a different server. Importing metadata is working fine, I got physical layer until presentation layer. But when I tried to view member in Physical layer, i got error message "[NQODBC] [SQL_STATE:HY000] [nQSError: 10058] A general error has occurred".

During Analysis in OBIEE, I manage to connect to Subject Area, which is the Essbase connection that I've created. When selecting dimension to filter, I cannot see member listed in filter box but error message "Failed to load (ODBC Driver returned an error) (SQLExecDirectW))".

My environment:

OBIEE 12c is in Linux 12.1.0.2.0 x64

Essbase 11.1.2.1 in Windows Server 2008 R2 Standard x64

BI Admin tool installed in client host Windows 8 x64

Anyone experienced this ? Kindly need your help.

Thanks,

Anna

[Deleted User] · Answer

For the benefit of other forum users can you please state what the solution was?

Yohana · Answer

Hi all,

I found the answer for this one.

Regards,

Anna