OBIEE 11g: Error: "[nQSError: 96002] Essbase Error: Syntax error in input MDX query on line 6 at token 'Item'." when Running an Analysis

(Doc ID 1982720.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.140715 to 12.2.1 Beta
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.140715 to 12.2.1 Beta
Information in this document applies to any platform.

Symptoms

You have installed OBIEE and applied the 11.1.1.7.140715 bundle patch,
When you execute an analysis containing an asymmetric complex query, you get the following error:

[nQSError: 96002] Essbase Error: Syntax error in input MDX query on line 6 at token 'Item'.

The line number given in the error varies with each analysis.

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