OBIEE 11g: Error: " [nQSError: 96002] Essbase Error: Syntax error in input MDX query on line 9 at token 'crossjoin' (HY000) " when Selecting any Filter on a Measure and Essbase is the Data Source (Doc ID 1564715.1)

Last updated on JULY 18, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.

Symptoms

You have OBIEE 11g with Essbase as the data source.  When you select any filter on a measure you get the following error:

Issue Description :  [nQSError: 96002] Essbase Error: Syntax error in input MDX query on line 9 at token 'crossjoin' (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