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 NOVEMBER 05, 2018

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

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
Symptoms
Cause
Solution

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