[nQSError: 96002] Essbase error in OBIEE 11.1.1.5 after upgrading (Doc ID 1341258.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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

ERROR
-----------------------
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)

 

Cause

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