We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

MDX to Export data from ASO cube

Received Response
19
Views
5
Comments
edited Oct 1, 2020 6:39PM in Essbase 5 comments

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
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!