0 Replies Latest reply on Aug 30, 2007 3:19 AM by 3004

    MDX output to text file

    3004
      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