Getting MDX from Pivottable (OWC)?

[mrwoopey]

Hi,

I am using pivottables from OWC10 and I was wondering how you can get
the MDX from it. I know you can set the MDX but don't know how to
retrieve the MDX.

There is a long winded solution but I get a "script out of range
error" on ".RowAxis.InsertFieldSet .FieldSets("[RowFs]")" in the
window_onload sub:

http://groups.google.com/[email protected]&rnum=1

Please post your technique on how to get the MDX from a pivottable, or
if you know how to fix the script out of range error" for the above
example.

Also, can OWC11 get MDX from a pivottable?

Thank you in advance!

P