OAC: How To Pass BI User Credential Pass Through To Essbase
(Doc ID 2409129.1)
Last updated on FEBRUARY 22, 2020
Applies to:Oracle Analytics Cloud - Classic - Version 17.4.1 to 18.1.3 [Release 17 to 18]
Information in this document applies to any platform.
+ Connecting to Essbase as Back-End DB
+ Configured rpd --> connection pool with SSO & Shared logon enabled
+ Username using :USER for USER and :PASSWORD for password
+ The reports fail with the following error
[<timestamp>] [OBIS] [TRACE:2]   [ecid: <ecid>] [sik: <ssi>] [tid: <tid>] [messageid: USER-34] [requestid: <request_id>] [sessionid: <session_id>] [username: <username>] -------------------- Query Status: [nQSError: 96002] Essbase Error: Login fails due to invalid login credentials [[[nQSError: 43119] Query Failed:
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