My Oracle Support Banner

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

Last updated on AUGUST 16, 2019

Applies to:

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


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. 




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.