Essbase MDX Script Fails To Run When Used In LKM Hyperion Essbase DATA To SQL (Doc ID 2297077.1)

Last updated on AUGUST 17, 2017

Applies to:

Hyperion Essbase - Version 11.1.2.1.000 and later
Information in this document applies to any platform.

Symptoms

Essbase LKM "Hyperion Essbase DATA To SQL" fails to run when MDX script is used to extract data. ODI interface fails with following error, 

'Cannot perform cube view operation. Essbase Error(1260052): Syntax error in input MDX query on line 1 at token ';''

The same MDX script will run successfully using the Essbase Administration Services (EAS) console MDX editor. 

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