My Oracle Support Banner

OBIeE 12c: For Essbase NON ADMIN users , Certain Outline Filters When Used In OBIEE Reports Errors Out With Essbase Error(1260046): " Unknown Member xxxx used in query " (Doc ID 2716108.1)

Last updated on OCTOBER 09, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.3.181016 and later
Information in this document applies to any platform.

Symptoms

Certain Essbase outline filters when used in OBIEE reports errors out with " Unknown Member xxxx used in query "

1.

Essbase. log for Non-Admin user:-

====================

Query Status: [nQSError: 96002] Essbase Error: Unknown Member XXXXXXX used in query
[nQSError: 43119] Query Failed:

 

2.

 

MDX Query was run from the SmartView giving error :

" Unknown Member xxxx used in query " .

 

3.

Errors on the OBIEE browser:-

=======================

 

Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes:

OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 96002. [nQSError: 96002]
Please have your System Administrator look at the log for more details on this error. (HY000)
SQL Issued: SELECT 0 s_0, "XXXXXX"."Entity"."Gen1,Entity" s_1, "XXXXXX"."Years"."Quarters" s_2, SORTKEY("XXXXXX"."Entity"."Gen1,Entity") s_3, SORTKEY("XXXXXX"."Years"."Quarters") s_4 FROM "XXXXXX" FETCH FIRST 65001 ROWS ONLY

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
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.