[nQSError: 96002] Essbase error in OBIEE 126.96.36.199 after upgrading
Last updated on MARCH 08, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 188.8.131.52.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 184.108.40.206 reports were working as expected. However upgrading further to OBIEE 220.127.116.11, some reports showed the following error message while using Essbase 18.104.22.168 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