MDX to table through ODI
Summary
MDX to table through ODIContent
Hi,
I am trying to export data to table through MDX via ODI
When I run the script in MDX editor , I get the output. But, when I call MDX in ODI, I get below error.
'Cannot perform cube view operation. Essbase Error(1260052): Syntax error in input MDX query on line 1 at token ';''
I have modified script, but it works in editor, not in ODI.
SELECT
{[3]} ON AXIS(0),
{[2014]} ON AXIS(1),
{[Account].[AC_1010101]} ON AXIS(2),
{[Functions].[FN_0024]} ON AXIS(3)
FROM APP.DB;
SELECT
{[3]} ON AXIS(0),
{[2014]} ON AXIS(1),
{AC_8010101000} ON AXIS(2),
{FN_0024} ON AXIS(3)
0