My Oracle Support Banner

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.

Symptoms

OAC-Essbase Cloud

+ 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:



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.