pure MDX

[Guest]

i'd like to be able to export the MDX from OWC pivotList; and I dont' want
to have to deal with all of the extra XML stuff like formatting; etc

Is there any _EASY_ way to do this?

Maybe a component or something to do this?

-Aaron

 

[Guest]

adding ";log file=c:\mdx.txt" to the connection
string which will capture the MDX OWC generates.

 

[Guest]

or exporting it to XLS and then getting to the MDX method of the pivotTable
object worked pretty well