[nQSError: 96002] Essbase error in OBIEE after upgrading

(Doc ID 1341258.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version [1308] and later
Information in this document applies to any platform.
***Checked for relevance on 16-Oct-2013***


Upon upgrading OBIEE from to reports were working as expected. However  upgrading further to OBIEE, some reports showed the following error message while using Essbase as data source.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 96002] Essbase Error: Calculated Members cannot be defined in Time Dimension in ASO applications, when Time Balance Accounts are present in the outline. Please try to define the Calculated Members in a different dimension (HY000)



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