After Configuring the Essbase Connection Pool to Use Shared logon, Reports Fail With [nqSError: 96002] Essbase error: Login Fails Due to Invalid Login Credentials
(Doc ID 2702072.1)
Last updated on SEPTEMBER 01, 2020
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.190716 and later
Information in this document applies to any platform.
Implemented Essbase data level security in OBIEE as per document "OBIEE To Essbase Supported and Recommended Authentication Methods (Doc ID 1993210.1) and configured Essbase Connection Pool in the OBIEE RPD to use the Shared logon option, entered the variables :USER and :PASSWORD for the username and password.
However, when try to run report in Analytics, get error:
Odbc driver ruterned an error(SQLExecDirectW)
[nqSError: 96002] Essbase error: Login fails due to invalid login credentials
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document