[nQSError: 96002] Essbase error in OBIEE 22.214.171.124 after upgrading
Last updated on MARCH 08, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0  and later
Information in this document applies to any platform.
***Checked for relevance on 16-Oct-2013***
Upon upgrading OBIEE from 10.1.3.4.1 to 188.8.131.52 reports were working as expected. However upgrading further to OBIEE 184.108.40.206, some reports showed the following error message while using Essbase 220.127.116.11 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