This discussion is archived
0 Replies Latest reply: Aug 29, 2007 8:19 PM by 3004 RSS

MDX output to text file

3004 Newbie
Currently Being Moderated
I have an MDX query embedded in a MaxL script. I want the query to output to a text file on my Unix server. I have tried using the MaxL spool command, but it outputs STDOUT, not just the output from the MDX. I want the MDX results set and only the MDX results set in a separate text file. There has got to be a way to do this, right? I'm trying to use MDX instead of a report script for extracting data from one essbase cube and loading it into another.<BR><BR>Any help is appreciated,<BR><BR>James