OBIEE 10g: Error: "[nQSError: 10058] A General Error Has Occurred. Essbase Error: Login Fails Due to Invalid Login Credentials" When Querying Essbase

(Doc ID 747952.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.0 [1900] to 10.1.3.4.1 [1900] [Release 10g]
Business Intelligence Answers Option - Version 10.1.3.4.0 [1900] to 10.1.3.4.1 [1900] [Release 10g]
Information in this document applies to any platform.
***Checked for relevance on 26-Jul-2013***

Symptoms

You have imported an Essbase cube to your repository, and created Business and Presentation Layers created for it. The Connection Pool for Essbase connection can not use Shared Logon because of security reasons - each user should see information according the access rights.

Authentication in Answers with domain credentials performs successfully. The same domain user is granted with access to Essbase application. When you query the Essbase cube from Answers, an error occurs:
  

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms