MDX to Export data from ASO cube

Summary

Trying to export very large data set via MDX in ASO cube

Content

Hi Experts,

 

Not sure if this is best way, but I need to export data via MDX script.  I'm trying this:   https://docs.oracle.com/en/cloud/paas/analytics-cloud/tress/mdx-export-specification.html

EXPORT INTO FILE "ACTDATA" OVERWRITE
SELECT
 {[Mar],[Apr]}
ON COLUMNS
 Crossjoin({[NorthAmer]},
  Crossjoin({[Actual],[Actual_Adjs]},
     {[Revenue],[IntIncome]}))
ON ROWS
FROM [FINGL].[FINGL]
WHERE ([FY20])

But getting error:

Statement executed with warnings.

(1) Syntax error near ['INTO']

 

 

 

Version

11.2